I’ve created a query with some visualizations. It worked fine but suddenly the chart shows ‘0’ despite the shape of the graph is correct and the data is fine.
You can see the data on the picture above (left side below in the picture).
Anyway, I changed my query and it works now:
format(@prev := glb.global_cnt, 0) as ‘Total Scans’,
format(c1.sender_cnt, 0) AS ‘AutoMarker’,
format(c2.sender_cnt, 0) AS ‘BidDoctor’,
format(c3.sender_cnt, 0) AS ‘Spector’
I removed the ‘format’ and it works. But I must mention that it works before with the format function.