Data points outside range to be disabled

Grafana
1

Hi Guys,

Can i resolved this one by using time_filter? this is the query that i used on this dashboard.

Select time, total_request, rc2001,rc3002,rc3004,rc4010,rc4012,rc5002,rc5012,rc5030,rc5031,rc6000 from PROD_ERROR_CODES;

or Select * PROD_ERROR_CODES;

Please advise.

Capture
Capture1787×300 68.7 KB

  • What Grafana version and what operating system are you using?
    5.4.3

  • What are you trying to achieve?
    to get of rid the datapoints outside range

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

2

Yes, you can.

You didn’t mention what data source you’re using. It looks like Influx, in which case a simple WHERE $timeFilter clause will do it for you (Add and manage variables | Grafana documentation)

3

Thank you for your reply!

I’m using PostgreSQL. how can i apply that time filter on the query?

4

PostgreSQL | Grafana Labs : WHERE $__timeFilter(time)

1 Like
5

Thank you svetb :smiley:

It worked!

1 Like
6

This topic was automatically closed after 365 days. New replies are no longer allowed.