-
2. Re: How do I get the sum of the parts to show in the label? Pie Chart Query
Hideki OGAWA Nov 27, 2018 1:32 AM (in response to Glenn Page)Hi Glenn,
My understanding is that you want to show the aggregated cost by city, not by item under each city name.
If that is correct, please find attached file (v2018.3).
For the label, make either of these two calculation.
Using LOD {FIXED [City] : SUM([Cost])}
Using Window Sum WINDOW_SUM(SUM((Cost))
Then put it into label mark.
If it's LOD, you should set 'Category' as context filter.
If it's Window Sum, you should set calculation by 'item'.
LOD is used for calculation which has different level of detail from what are shown in the viz.
In this case, chart is split by item, but want to show total.
Window_sum is similar and help to calculate total or sub-total of the values on the table with the dimensions you like to consider.
Best regards,
Hideki
-
Night out R.twbx 24.7 KB
-
-
3. Re: How do I get the sum of the parts to show in the label? Pie Chart Query
Glenn Page Nov 27, 2018 12:06 PM (in response to Hideki OGAWA)Thank you Hideki, this was very helpful.
-
4. Re: How do I get the sum of the parts to show in the label? Pie Chart Query
Hideki OGAWA Nov 27, 2018 4:07 PM (in response to Glenn Page)My pleasure.
LOD and window sum are beyond the basic a bit, but are really helpful.
Hope you enjoy!
Best regards,
Hideki