Vertical Column chart: Can't order on Date when using a cross tab
Since updating to version 7.3 build 20170929, we are missing a sorting functionality in the Vertical column charts for cross tabs.
For a cross tab we are using a vertical column chart to compare the metric (no SQLs) of different Suppliers over time (months). For this we use a cross tab. For visualization we used the Vertical column chart. This resulted in one bar per Supplier per month with the months ordered from oldest to newest.
Cross tab setup:
Since updating, the months are ordered alphabetically, unless we turn on Time Series. Both options result in a unreadable graph.
Time series off (picture below). We do have one bar per supplier per month and they are next to each other. That is as desired. Unfortunately the order of the months is not chronological. So this is no option.
Time series on (picture below): the months are chronological, that is good. But the bars are overlapping. So Time series also drop out as option.
Looking further into the sort options of the axis (Time series turned off). There is an third option: table. This makes it possible to display the graph as desired, provided that the date table is sorted old to new. But we would like to have the table sorted new to old, but this also swaps the order of the months in the graph.
Now, I was ready to accept this third option and order the table old to new.
But, when I look into reports with the same graph, but no cross tab, we do have the option to sort on Date. See pictures below.
So, I'm wondering whether the missing of this option in a cross tab setup is a bug or that is purposely removed in version 7.3. And, can I expect it to be different in the new version?