I have a dashboard showing some singlestat values, in this case it displays the number of “Product searches” executed and the number of “Product bookings”.
These are calculated by doing an ElasticSearch query, for example the number of bookings is calculated like this:
What I would like to do is display a “Search to book ratio”, so simply the number of searches divided by the number of bookings. I’d like to display this on a third singlestat panel.
Is there a way to do this in Grafana?
If it’s not possible when using ElasticSearch queries, would it be possible with Prometheus, or any of the other data source options?