Line Chart loses order of categorical items


#1

Hi,

I’m running redash 11 ontop of BigQuery.

I have a query which returns a number per source and per quarter. I’ve visualized the data using a line chart, setting the number as the metric (Y column), quarter as X column (categorical) and grouping by source. Because there are over 20 sources, the graph can get busy, so I started removing sources which I care less about. At some point, the order of categorial items on the X axis changes, causing the lines to go “back”.

Example of how it looks without the bug - http://pasteboard.co/2SQw5rmRS.png
Example of how it looks with the bug - http://pasteboard.co/2SUgXbrX0.png

Notice how the quarters are all mixed up when the bug occurs. I’ve verified that the query itself sorts by the quarter field, and it does.