Hello everybody
I am in the graphic form using a bar chart where I have the following query
SELECT CONVERT(VARCHAR, Fecha, 108),QTY FROM HistoricoContador WHere Linea = 'Linea_Disco' And FORMAT (Fecha, 'dd/MM/yyyy') = FORMAT (GETDATE, 'dd/MM/yyyy') AND CONVERT(VARCHAR, Fecha, 108) BETWEEN '06' AND '21'
ORDER BY ID
and I would like to see if there is any way to get it to run every hour to update the bar chart.
I have the query in the DATA properties