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.

Screenshot 2020-03-20 at 6.09.56 PM1178×646 53.7 KB

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.