Hello, everyone.
I have a query in InfluxQL that returns some null or none values in the middle of valid values. But in the timeline of State Timeline Visualization where there should be an empty space, it appears to be filled by the last value registered before passing it to null or none.
Any help would be appreciated.
Can you please share your entire query and the settings in Grafana shown on the right side?
The query is as follows:
SELECT distinct(“PROC_RECIPE”) FROM “TEMP_VAC_SG170_M1_MS_SS” WHERE “PROC_ENB_DISB” = true AND $timeFilter GROUP BY time($__interval) fill(none) ORDER BY time DESC
The aim is that when Process SS is OFF there is an empty space in the Recipe_SS timeline.
Can you try to specify Disconnect values threshold and check if it works for you?
Thank you for your help. I had already tried to go that way but I think I left too much time, in the order of hours.
Fastest time ever from question to solution, but the lesson to be learned here is:
Specify as much as you can in your forum question: Your query, the Grafana settings, any transformations being used, etc. That makes it way easier for anyone on these forums to hone in on any potential issue that is causing the problem.
This was an easy one. Thanks again for the quick and functional reply.
If null values are not appearing on the state timeline, ensure that your data source settings are configured to include nulls. You might also need to adjust the timeline visualization settings to handle or display null values appropriately.
