- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Question about Box Plots
Hello,
I'm trying to figure out how to create a Box Plot that shows the right data. I have data that in imported through SQL and each column is its own field (unique_root, 0-10% BL/day, 11-20% BL/day, etc.). I want to show a box plot of all the different BL % like the screenshot from the excel attached. Is there a way I need to group the % fields in the data load editor to do this? Currnetly I can only see one field when I would like to see all of them.
Thanks,
Cody
- Tags:
- boxplot
- data grouping
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If I understand you correctly, then you want to turn the column labels into a dimension you can use in the boxplot. If that is the case then you are probably looking for the "Crosstable" functionality:
It took me some time to wrap my head around how that function works, but there are some examples available if you search for them. This page is a good starting point:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just hoping someone could point me in the right direction.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bumping this again as I'm still stuck with this issue. Any help would be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If I understand you correctly, then you want to turn the column labels into a dimension you can use in the boxplot. If that is the case then you are probably looking for the "Crosstable" functionality:
It took me some time to wrap my head around how that function works, but there are some examples available if you search for them. This page is a good starting point:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Øystein_Kolsrud thank you for pointing me in the right direction. For anyone looking into this, I had to create another table using the crosstable function like this:
And then set up the Box plot as such: