Hi Everyone, How do I filter my Dashboard variable...
# supports
Shaun Peusschers
09/16/2024, 11:43 AMHi Everyone, How do I filter my Dashboard variable with the relative time selected in the dashboard.
Shaun Peusschers
09/16/2024, 1:50 PMIt seems that the filter is not working.
Copy code
timestamp BETWEEN {{.start_timestamp}} AND {{.start_timestamp}}Shaun Peusschers
09/16/2024, 1:50 PMWe are running an on premise version. v0.51.0
s
Srikanth Chekuri
09/17/2024, 5:14 AMShare the full query (with specific details masked) you are using
s
Shaun Peusschers
09/17/2024, 6:35 AMHi, 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?
s
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 != ''s
Shaun Peusschers
09/18/2024, 6:44 AMThank 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
10 Views