I may have found a solution for you-- but it's a little messy.
- I started by combining all your monthly measures together in a PIVOT table. Highlight the 8 measures and convert them to a pivot. IMPORTANT: if you have other calculations that use these field names, it may disrupt them, so check first!
- Next, I created a little calculation to determine which pivot names were being used. This allows your COMP and PERSONAL time to be listed together
- I bumped into a problem here, because when I listed the month names they came out alphabetically. I used a little CASE statement to convert them into their proper month number. I suspect there are more clever ways to do this...This is just a part f it. UPDATE: you can probably make this a lot easier using DATEPARSE("MMM",[Pivot Month]). Format it as a date
- Then I created another small calc. This just identifies which are COMP and which are PERSONAL
- Using these three calcs, I was able to graph both at the same time.
Watch closely: I'm confident someone will have other options!
Utilization Line Chart.twbx 17.4 KB
Thanks for your quick response! At this point I can take any solution that works, So I was trying to follow along your steps. In step 1, when you say to create a PIVOT table, is that in Excel? How does it look like? Could you give more illustration on this?
Michael is referring to the following functionality in Tableau: Pivot Data from Columns to Rows
This allows you to transpose columns to rows in the data connection screen in Tableau. The article will provide you with step-by-step instructions and a good example!
Thanks all! I was able to follow Michael's steps and produce the visualization that I wanted.
Thanks for all your input and help.
Thank you Michael！