Data displayed in the wrong place in graph

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?

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

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.