Couple of things to do here.
First sync the filter so both sheets are affected.
Second add a date axis (discrete) to the pie chart view so you end up with loads of pie charts.
Lastly you need to hide all but the last one. to do this properly you can add a calculation to the filter shelf along the lines of LAST()=0 and set this to True.
Not super simple but I've attached an example
date filter.twbx 32.7 KB
1 of 1 people found this helpful
Here is an alternate approach:
- Create a parameter for the Date for the pie chart - this will allow you to see look at different end dates
- Create a calculated field that sums the Metric on the date from the parameter
- use the new calculated field in your pie chart
Let me know if this works for you
Unfortunately another part of my dashboard changed behavior with this fix.
When I applied the fix, the sorting function kinda messed up.
For example the Countries below are sorted by sum(Metric) descending. When I added the list_date on the column, I think the sorting function takes into account all the dates in the list_date and not just on the last()=0 value that's why its not sorted properly anymore.
Nvm, managed to fixed this using index.