Unusual Behaviour of the line behaviour

I wrote a simple query to just create a simple line graph, but when I create line graph it shows some unusual behaviour.

I have written this query on in Postgres database.

Please look at this graph and if anyone can help me to figure this out, that would be helpful.

Your query is returning multiple records per X value.

This is described in the “Common Mistakes” portion of our documentation on the Chart visualization.

1 Like