Bar Gauge - Sql Server - Help visualization

Hello Guys,
Help-me.

I am trying to configure my frist bar gauge, with the query below:

Grafana Version: 7.3.1

Query:
SELECT count(*) as total, DATEPART(dd,datai) as dia
from bilhete
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.

However:

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?

This topic was automatically closed after 365 days. New replies are no longer allowed.