Data displayed in the wrong place in graph

[MaKalvik]

Hi! I’m using the query results data source to get data from google sheets and everything has been working with no problems so far. However, now i added a new row in sheets and the data transferred over to redash nicely, but in the graph that I have set up for the table the added row isn’t shown as the last value. It’s the last value in the table, but not in the graph.

The table using the visualization:

and the graph:

Anyone ran into this problem before?

[k4s1m]

I think you’ve hit this behavior, which happens if you’re grouping data that’s not complete.

Custom sorting is overriden when stacked bars don't contain the same categories

Makes sense! Plotly draws records in the order it encounters them in your data set. Initially the data gets split by your grouping field so your one table becomes two: Blue time mintime category value 20-Jan 31/01/2020 00:00 Blue - 20-Apr 17/04/2020 10:46 Blue 6.04 20-May 1/5/20 10:23 Blue 18.5 20-Jun 1/6/20 9:43 Blue 8.43 20-Jul 1/7/20 6:38 Blue 17.2 20-Aug 3/8/20 6:56 Blue 16 20-Sep 1/9/20 7:11 Blue 8.56 Red time mintime category value 20-Feb 14/02/2020 17:33 Re…

To solve it, make sure there is at least one record for every x-axis value and group. Or just sort your data chronologically in the underlying sheet.