Hi *,
I want to filter my querys with a dropdown. I know how to create the dropdown and filter the queries. But I want to show a name in the dropdown and filter by id. I don’t know how to do this. For MySQL I found https://grafana.com/blog/2019/07/17/ask-us-anything-how-to-alias-dashboard-variables-in-grafana-in-sql/. I know about label_values() described in https://grafana.com/docs/grafana/latest/features/datasources/prometheus/. My id and my value are in separate labels, e. g.:
feathers_server_customer_info{db="somedb",id="4c25eeaa-5837-4347-8a11-9c67d17b1cd2",name="Bochum Coorp",country="US"} 0
So I want to filter by ID and show the name label. How can I achieve this? Any help is greatly appreciated!
Thanks in advance!
André