https://signoz.io logo
Title
r

Romario Lopez C

04/07/2023, 5:53 PM
Hello! I’m translating a grafana dashboard into signoz. I want to import PromEx dashboards but variables aren’t working as expected. How do I translate this promql query to clickhouse query?
label_values(gitstart_engine_prom_ex_prom_ex_status_info, job)
s

Srikanth Chekuri

04/07/2023, 5:56 PM
SELECT DISTINCT JSONExtractString(labels, 'job') AS job
FROM signoz_metrics.distributed_time_series_v2
WHERE metric_name = 'gitstart_engine_prom_ex_prom_ex_status_info'
https://signoz.io/docs/userguide/manage-variables/#supported-variables-types
r

Romario Lopez C

04/07/2023, 5:57 PM
It returns no data
🤔
s

Srikanth Chekuri

04/07/2023, 5:58 PM
Are you sure the metric and label exist in your sending data?
r

Romario Lopez C

04/07/2023, 5:58 PM
Aaa it doesn’t return data either in grafana
but yea I got how to translate them
thanks!