topic univariate analysis of several variables in one graph in Using Dataiku DSS
https://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14771#M6287
<P>Hi, </P><P>I have a table like below. DSS can show the variarite analysis (like boxplot) in the 'statistics', but only seperately. Can I create a graph, which include three boxplots together, so that one can clearly see the comparision among those variaibles. </P><P>Thanks a lot!</P><P> </P><TABLE border="0" width="192" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="60">work hours 2017</TD><TD width="64">work hours 2018</TD><TD width="64">works hours 2019</TD></TR><TR><TD height="20">42</TD><TD>40</TD><TD>42</TD></TR><TR><TD height="20">41</TD><TD>45</TD><TD>43</TD></TR><TR><TD height="20">45</TD><TD>40</TD><TD>41</TD></TR><TR><TD height="20">43</TD><TD>42</TD><TD>40</TD></TR><TR><TD height="20">42</TD><TD>41</TD><TD>41</TD></TR></TBODY></TABLE><P> </P><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV><P> </P><P> </P><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV><P> </P><P> </P>Mon, 08 Mar 2021 13:04:10 GMTTong2021-03-08T13:04:10Zunivariate analysis of several variables in one graph
https://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14771#M6287
<P>Hi, </P><P>I have a table like below. DSS can show the variarite analysis (like boxplot) in the 'statistics', but only seperately. Can I create a graph, which include three boxplots together, so that one can clearly see the comparision among those variaibles. </P><P>Thanks a lot!</P><P> </P><TABLE border="0" width="192" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="64" height="60">work hours 2017</TD><TD width="64">work hours 2018</TD><TD width="64">works hours 2019</TD></TR><TR><TD height="20">42</TD><TD>40</TD><TD>42</TD></TR><TR><TD height="20">41</TD><TD>45</TD><TD>43</TD></TR><TR><TD height="20">45</TD><TD>40</TD><TD>41</TD></TR><TR><TD height="20">43</TD><TD>42</TD><TD>40</TD></TR><TR><TD height="20">42</TD><TD>41</TD><TD>41</TD></TR></TBODY></TABLE><P> </P><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV><P> </P><P> </P><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV><DIV class="mceNonEditable lia-copypaste-placeholder"> </DIV><P> </P><P> </P>Mon, 08 Mar 2021 13:04:10 GMThttps://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14771#M6287Tong2021-03-08T13:04:10ZRe: univariate analysis of several variables in one graph
https://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14774#M6290
<P><LI-USER uid="5263"></LI-USER> </P><P>several ideas come to mind</P><P>1. Restructure the data in long form, with a column for years and a column for hours. In the R world this is some times called tidy data.</P><P>2. Use dashboards and post the three charts you already know how to make to a single dashboard.</P><P> </P>Mon, 08 Mar 2021 14:49:34 GMThttps://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14774#M6290tgb4172021-03-08T14:49:34ZRe: univariate analysis of several variables in one graph
https://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14981#M6362
<P>Thanks <LI-USER uid="313"></LI-USER> the first option is good! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">ðŸ™‚</span></P>Wed, 17 Mar 2021 13:00:14 GMThttps://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14981#M6362Tong2021-03-17T13:00:14ZRe: univariate analysis of several variables in one graph
https://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14988#M6363
<P><LI-USER uid="5263"></LI-USER> ,</P><P>Excellent!</P><P>Long form or so-called "tidy data" can be super helpful for graphing.</P><P>Knowing how to use the Visual Prepare recipe to "fold" multiple columns data can be very helpful in creating tidy data set in DSS. Here is a similar example I've been working with recently related to a number of customer name columns. Where I want the column name in one column and the names in another. (You can think about this a "unpivot" function.)</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Fold Multiple.jpg" style="width: 292px;"><img src="https://community.dataiku.com/t5/image/serverpage/image-id/2989i9E22F7B690300707/image-size/large?v=v2&px=999" role="button" title="Fold Multiple.jpg" alt="Fold Multiple.jpg" /></span></P><P>In your case in the column list, you would put each one of your columns in your table.</P><UL><LI>"work hours 2017" </LI><LI>"work hours 2018" </LI><LI>"work hours 2019" </LI></UL><P> </P>Wed, 17 Mar 2021 15:25:13 GMThttps://community.dataiku.com/t5/Using-Dataiku-DSS/univariate-analysis-of-several-variables-in-one-graph/m-p/14988#M6363tgb4172021-03-17T15:25:13Z