Join Slack

Hi Everyone, How do I filter my Dashboard variable with the relative time selected in the dashboard.

# support

Shaun Peusschers

09/16/2024, 11:43 AM

Hi Everyone, How do I filter my Dashboard variable with the relative time selected in the dashboard.

Shaun Peusschers

09/16/2024, 1:50 PM

It seems that the filter is not working.

Copy code

timestamp BETWEEN {{.start_timestamp}} AND {{.start_timestamp}}

Shaun Peusschers

09/16/2024, 1:50 PM

We are running an on premise version. v0.51.0

Srikanth Chekuri

09/17/2024, 5:14 AM

Share the full query (with specific details masked) you are using

Shaun Peusschers

09/17/2024, 6:35 AM

Hi, Here you go.

Shaun Peusschers

09/17/2024, 6:35 AM

Copy code

SELECT DISTINCT JSONExtractString(labels, 'id') AS name
FROM signoz_metrics.distributed_time_series_v2
WHERE JSONExtractString(labels, 'id') IS NOT NULL
AND JSONExtractString(labels, 'id') != ''
AND (timestamp BETWEEN {{.start_timestamp}} AND {{.start_timestamp}})

Shaun Peusschers

09/17/2024, 9:46 AM

@Srikanth Chekuri does the query help?

Srikanth Chekuri

09/17/2024, 5:24 PM

Copy code

SELECT DISTINCT JSONExtractString(labels, 'id') AS name
FROM signoz_metrics.time_series_v4
WHERE metric_name IN [...]
AND (unix_milli >= intDiv({{.start_timestamp_ms}}, 3600000) * 3600000) AND (unix_milli <= intDiv({{.end_timestamp_ms}}, 3600000) * 3600000)
HAVING name != ''

Please make sure you add metric name, otherwise it will be slow.

Shaun Peusschers

09/18/2024, 6:44 AM

Thank you, it seems our version does not have the start end end time variables. PR:https://github.com/SigNoz/signoz/pull/5714 Version 0.53.0

8 Views

Open in Slack

Previous Next

SigNoz Community

SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.