Hi all,
I use Grafana with the Google BigQuery datasource.
I can’t display a graph with a monthly distribution (with the macro $__timeGroup)
My query :
SELECT *
FROM (
SELECT
$__timeGroup(usage_start_time, 1M),
project.id AS metric,
SUM(cost) AS value
FROM
project.view_v3
WHERE
$__timeFilter(usage_start_time)
GROUP BY 1, 2
ORDER BY 1 ASC
)
WHERE value > 0
With a visualization by table, it seems to work, but not in graphical mode :
Thanks for help,
Regards,
Didier