Switch the query by time

Grafana Dashboards
,
1

Hi,

I need to switch the query from A, B and C after the working each shift 6am - 2pm ,2pm - 10am …etc.

Maybe someone faced such problem.

Thank you :slight_smile:

2

Welcome @bartoszaffelski

What is your datasource? Can you share the query you have written?

3

image
image1625×167 8.29 KB

I want to disable / enable the queries after each 8 hours , 6am, 2pm and 10pm.

Is it possible ?

I’m working on postgres BD, sql code looks good.

4

I do not know enough about PostgresDB if it’s possible, but using Flux in InfluxDB, they offer a function called hourSelection

|> hourSelection(start: 6, stop: 14)
5

thank you for the explanation, but I’m asking about grafane, does it have such functionality in it?

6

You want it to disable one of the queries automatically? Thats not possible
The better question is what are your requirements? What are you aiming to accomplish?

I assume each query is for a specific time range

So when 6 to 2 is enabled so you want to disable the 2 to 10 and 10 to 6 etc?

In that case just use query with dynamic time ranges and get rid of the 2 other queries