Update automatic query

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'

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

In Perspective or Vision, there is a polling rate that can be used, and can be set to 3600 seconds

do you know how to?



1 Like