I am trying to configure my frist bar gauge, with the query below:
Grafana Version: 7.3.1
SELECT count(*) as total, DATEPART(dd,datai) as dia
where datai >= DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)
and datai <= DATEADD(DD, -DAY(DATEADD(M, 1, GETDATE())), DATEADD(M, 1, GETDATE()))
group by DATEPART(dd,datai)
order by dia
I would like see in the graph as the table, just dia and count.
1 - If in (Fields Select the fields that should be included in the panel) i choose Total, i don´t get rename the label total from axis-x to the correct day. I tried here, in the filed Display name put $__cell_0, but my graph don´t display some information
2- If in field(Fields Select the fields that should be included in the panel) i choose All fields, I tried here, in the field Display name put $__cell_1, but my graph still show all the columns.
Anyone can hel-me?