Hi Eileen, if I understand your question, Tableau will combine adjacent rows if the values are same. In your example, Rows 1 and 2 have different values (for the Combined Field, Target, and Rtg%), so they can't be merged into a single row. Here's a simplified version to help you see why Rows 1 and 2 can't be combined:
Regarding your question about "inconsistency": if you look at the last two rows starting with "WAKE" (above), they're the same except for Target, so when you remove Targets, those rows will be combined since the columns have the same values and can be combined.
Getting back to your original request, I've taken a first pass by recreating the Combined Field (removing Rtg% and adding Start time), removing the Target pill from the Rows shelf, moving the Rtg% pill to the marks card (and probably a few other things), with the result looking like this:
I've attached my workbook so you can play with this.
Sample-2.twbx 136.7 KB
1 of 1 people found this helpful
Thanks for the explanation! I now understand why the bars are sometimes and sometimes not.
May I know if it is still possible to list the Rtg% column and have the bars combined+sorted in descending order based on this column? From what you have said and what I have played around so far, having Rtg% in Rows shelf will split have the columns split up once more than 1 Target is selected.
Coming back to the workbook that you have helped me with, I have updated the sorting to be by Rtg%. The sorting seem to only work if and only if I select 1 Target. When 2 Targets are chosen, it doesn't sort as well. Screenshot below. I have gone to Analysis to turn the Stack Marks to "Off", but the sorting issue I have is regardless whether this is on or off.
Once again, I appreciate on your advice and help!
Two rows with different Rtg% values will not be combined. I worked around this by moving that dimension from the Rows shelf to the Marks card, so that you can still see the values. This also allows you to select any number of targets (take a look at my workbook).
In your last screenshot, I don't quite understand the issue; if my comments here don't address them, please provide more details.
Sorry I got confused earlier on, and hence the screenshot. All's great now! Thanks a lot!