Line chart canvas visualization

[salma_widiarti]

Hi all, I have data like this

And this is my query

SELECT substring(labels.tanggal,1,4) as date1, SUM(labels.money::int) as a FROM "apm-*" WHERE labels.status = 'PAID' GROUP BY date1

But why when I make a visualization. y axsis to be like this

Anyone can help me?

[afharo (Alejandro Fernandez Haro)]

Hi @salma_widiarti,

I think the issue here is that there's only 1 data point and the visualization is building a Y-axis centred in the only value that exists +- some values.

You can set the Y-axis to start at 0 and jump every 1000 by setting yaxis={axisConfig min=0 tickSize=1000}. You can find more info about the axisConfig here

[salma_widiarti]

Thanks @afharo, yout solution is worked..