Hello,
I'm trying to see if there is way to update the categories in top N bars (bar chart) automatically when I change the date time frame filter. Currently, when I update the date filter, it updates the count on bars but do not show updated categories.
for example, lets say the top 3 categories are blue, green and orange for the timeframe Jan 2020-June 2020, when I update the timeframe to March 2020-June 2020, I'd like to see which categories are now in the top 3 . Currently, when I update the timeframe, I get the same categories (blue, green, and orange) and only the count (number of instances) of these categories gets updated. Thanks!
Hi
see the post at https://jimdehner2.blogspot.com/2019/12/dynamically-sort-top-n-in-drill-down.html
that presents the use of rank using lods and sorting - there are several examples - create an LOD based on date, category and count - rank the lod and then use the ranking to sort - give it a try and if you run into problem post the twbx here so we have something to work from
thanks
Jim
