Convertion from text list to gauge bars

[pjcafonso]

Hi all

I’m beggining in Grafana, I need to convert a list from data source of postgres to a graph bars. When I change visualization loose the description of each value.

My query is like this.
SELECT
svl.value as “estado”,
count(sgtsd.id) as documentos
FROM
sdccs_gui_types_sd_document sgtsd
INNER JOIN
sdccs_value_lookup svl ON svl.id = sgtsd.status
WHERE
sgtsd.process_folder_id is null
GROUP BY 1
ORDER BY 2 DESC

And when I change for gauge bars, I loose the specifications of each column, only have docments text, but I need to watch “estados” related to documentos value!

Thanks in advance

[fadjar340]

Try use Graph panel, instead ot time of the X-series, use Mode: Series.

[pjcafonso]

Sorry for my stupid question, but where I change X-series to Series mode?

[fadjar340]

Graph Panel - Axes

[pjcafonso]

After all I was doing well, but the result is not shown!

Still can view as table not as graphic.

[fadjar340]

Yes, you need one more column, named as time, that will be a time series, I suggest you use timestamp, and add WHERE clouse with this:

$__timeFilter(timestamp)

This is very important if you use graph table, because it’s need time to conform with time range.