Open
Description
Description
Today, if you don't add the correct ordering in an area and line chart, then it looks like it's broken and zig-zagging. There isn't a scenario I can think of where you'd want your area or line chart to be zig-zagging.
Instead of requiring users to use the correct ordering in the results table, instead, we should automatically sort by the x-axis first when plotting the data
Here's more details on the issue: #9972
Acceptance criteria:
- line charts and area charts are only ordered by the dimension selected for the x-axis.
- x-axis sorting should be in ascending order by default
- the order of the data on the x-axis should only be affected by the sort order defined in the
Configure chart, Axespane, not by the sort applied to the results table.