Hi,
I am looking to delete the decimals on Y, this is my Graph:
And also I receive the message data outside the time range, please help.
SELECT DISTINCT
monthname(created_on) as metric,
Y.SLAMETCLOSE/X.CLOSEDTICKETS*100,
created_on as time
from ticket T
where $__timeFilter(created_on)
GROUP by metric
order by Time desc