Forum Discussion
Allselected function not removing row context for date hierarchy
The axis is forced to Category mode when it's dealing with a non-Date/Time field. The field you are using at the bottom level is Integer (Day of the month).
If you use a DateTime field the axis will auto-scale
Yes I did try that as one of the many permutations and I got this...
But after reading your suggestion I realised there was one more permutation: using the go to next level button instead of the expand down ne level button with this on the axis:
This works for the lowest level but, not for the Month level...
The months summarised without considering the years and even if you set the sort order to Month Number, still don't sort in order. It's like they thought of everything and systematically eliminated the options to bump their frustrated customer KPI.