Hi everyone,
I try to understand why the two following Viz have a different behavior :
- The first one is obtain by setting off the option "Aggregate measures" in the Analysis menu.
The second one keep the option "Aggregate Analysis" setted on and the Row ID to obtain a non-aggregate viz :
I retrieve the good values. However, my question is : Why i don't obtain the same representation of the analysis ?
Sorry for my english.
Regards
The issue is the sort on your row ID.
When you turn off "Aggregate Measures" Tableau is forcing the sort on the measure.
When you place row ID on the detail with Aggregate Measures on, and then sort Row ID descending it should give you the same behavior.
This is because when you add the row ID detail, Tableau is sorting on that ID rather than the measure, much like you would see if you put the Row ID on rows. Tableau would sort that field by it's value rather than the measure associated to it. (Until you explicitly specified the measure as the sort value)
Let me know if that makes sense.
