Line chart canvas visualization

Hi all, I have data like this

And this is my query

SELECT substring(labels.tanggal,1,4) as date1, SUM( 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?

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

Thanks @afharo, yout solution is worked..

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.