Stacked Column chart

Grafana Bar Chart Panel
1

Hi!, I’m trying to created a stacked Column chart using data from MSQL, with no time.

like this view
image

image

image

script

SELECT COUNT (*) EMPLEADO, SEXO,NOMINA
FROM [EMPLEADO]
Where ACTIVO = ‘S’
group by SEXO, NOMINA
order by NOMINA

is there a way to stacked bar with no time values?
if there isn’t a way… any advice on how to add a custom timestamp in this query?

2

Please post sample data not as image but as csv?

empleado,sexo,nomino
14,F,CNTR
3

thanks for reply, here you are.

empleado, sexo, nomina
14,F,CNTR
14,M,CNTR
32,F,WH01
149,M,WH01
22,F,WH02
142,M,WH02

1 Like
4

It does not seem like what you are looking for is available
please try this with a fake nanosecond for today’s date

SELECT
  1651665600 as time,
  NOMINA as metric,
  count(1) as value
FROM EMPLEADO
GROUP BY SEXO, NOMINA
ORDER BY 1

and make sure you choose Stacking Normal under bar chart

image
image401×703 46.5 KB

1 Like
5

thanks for help! I got it

1 Like