Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
@Håvard Knappskog - Here it is https://docs.cognite.com/cdf/dashboards/guides/grafana/timeseries#custom-queries
@Håvard Knappskog - Was the answer helpful? And for your 1st question. I believe that the queries should automatically fetch the data from right time range regardless of timezone. Grafana by default takes the browser timezone. The pic below shows the default setting when the time window was set to last 168 hours.
For your 2nd question, I understand that if the flow is below certain threshold you want to consider that as 0. With this assumption, I propose this solution attached. The 1st query in the pic below is on_error((ts{externalId="xxx-xxxx",alignment=1653386400000}*round(ts{externalId="xxx-xxxx",alignment=1653386400000}/540,0))/round(ts{externalId="xxx-xxxx",alignment=1653386400000}/540,0),0)I want to make any value 0 that is below 270Kg. I need to use 2*270 since I'm using round function here. I hope this helps. CheersKaran.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.