How to use panel results in new panels for calculations?

Grafana Dashboards
, ,
1

Hello,

I am new to Grafana and am in need of assistance. I have 2 panels created from 2 different data sources. I am using MySQL. For “Suppliers Cumulative” I am using the following Query:
image

For calculating “Active Suppliers” I am using this Query:
image

For some reason (maybe it is just a Grafana thing), but I cannot input “count(distinct name)” into my queries. Therefore, I have to go to “value options” and choose Distinct Count and Name

I want to create 3rd panel that would calculate the churn rate in % by using the results from 2 panels below
image

Is it even possible or there is another way to get my result? Even as a query that would merge the two panels and use in-query calculation method would be appreciated.

THANK YOU!!

~ the grafana team