Newbie in Grafana and not strong SQL-er.
I’ve defined variable “Project Name” and have it as a drop down.
I then have 2 tables that look something like this:
| work_id | project_name |
| 123 | Project 1 |
| 345 | Project 1 |
| 456 | Project 2 |
| work_id | customer_id |
| 123 | abc |
What I need to calculate is percentage of work_id’s with cusomer_id present per Project Name
So let’s say I select “Project 1” from the drop down, I will see value of 50%, and if I select “Project 2”, I will see 0%
I have 2 queries that select values from each table and do Outer Join transformation that puts them together. So the result I have so far is a table:
| work_id | project_name |customer_id |
| 123 | Project 1 | abc |
| 345 | Project 1 | |
| 456 | Project 2 | |