I am using Grafana version 6.7.3 with MySQL as my datasource.
My query is:
SELECT
$__timeGroupAlias(requestedDate,$__interval),
count(id) AS “Opened”
FROM table_name
WHERE
$__timeFilter(requestedDate) AND
requestedApi in (“myapi”)
GROUP BY 1
ORDER BY $__timeGroup(requestedDate,$__interval)
I am using the Graph panel to plot the results using bars. When there are multiple rows in the result, the graph plots correctly, but when there is only row, the bar graph spreads through the entire X-axis
When I select Point to represent the graph, I get a single point correctly.
How can I get a single bar correctly at the specified date instead of the bar spreading to the entire X axis? Please advise me.