Subscribe Bookmark RSS Feed

Column hierarchy displayed on a single onway plot?

rossjason

Contributor

Joined:

Feb 3, 2017

OK maybe this isn't the right way to do it but I'll explain what I'm going for and see what gets suggest.

 

Let's say I have a character column that contains 5 different types of names for the rows (tool1, tool2, tool3, tool4, tool5). I want to have a Oneway plot showing the statistics of each tool for a given parameter (say average tool down time), but I also want the Oneway plot to group the tools into two categories because tools 1,2 and 3 are in 1 facility, and tools 3 and 5 are in another, so facility1 and facility2. I want the one way plot x-axis to display tools1-5 as well as the aggregate of facility1 and facility2 tools all horizontally and in the same y-axis so I can see how each tool compares to the overal statistics for each facility.

 

Now since Oneway plots only allow one x-axis column, I've found a hacky way of doing this by copying all the rows and added them to the table (so doubled the amount of rows with 1 duplicate for each) and then replaced the tool# with corresponding facility# so the Tool column in a one-way plot shows everything like I want it. I don't like this solutiong beccause now in other plots I ahve to be careful about the duplicate rows. The other solution is to just make two one plots and line them up next to each other but that's just not a very elegant solution.

 

I see there's this supercategories function but not sure if that's what I need. Any suggestions?