univariate analysis of several variables in one graph

Solved!
Tong
Level 3
univariate analysis of several variables in one graph

Hi, 

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. 

Thanks a lot!

 

work hours 2017work hours 2018works hours 2019
424042
414543
454041
434240
424141

 

 

 

 

 
 

 

 

0 Kudos
1 Solution
tgb417
Neuron
Neuron

@Tong 

several ideas come to mind

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.

2. Use dashboards and post the three charts you already know how to make to a single dashboard.

 

--Tom

View solution in original post

0 Kudos
3 Replies
tgb417
Neuron
Neuron

@Tong 

several ideas come to mind

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.

2. Use dashboards and post the three charts you already know how to make to a single dashboard.

 

--Tom

View solution in original post

0 Kudos
Tong
Level 3
Author

Thanks @tgb417 the first option is good! 🙂

tgb417
Neuron
Neuron

@Tong ,

Excellent!

Long form or so-called "tidy data" can be super helpful for graphing.

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.)

 

Fold Multiple.jpg

In your case in the column list, you would put each one of your columns in your table.

  • "work hours 2017"  
  • "work hours 2018"  
  • "work hours 2019"  

 

--Tom
0 Kudos
A banner prompting to get Dataiku DSS
Public