Hi!, I’m trying to created a stacked Column chart using data from MSQL, with no time.
like this view
SELECT COUNT (*) EMPLEADO, SEXO,NOMINA
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?
Please post sample data not as image but as csv?
thanks for reply, here you are.
empleado, sexo, nomina
It does not seem like what you are looking for is available
please try this with a fake nanosecond for today’s date
1651665600 as time,
NOMINA as metric,
count(1) as value
GROUP BY SEXO, NOMINA
ORDER BY 1
and make sure you choose Stacking Normal under bar chart
thanks for help! I got it