Gauge Widget - Value from Count of sub-query

MichaelGayheart1

As far as I can tell I can compare the sum/ave/min/max of one field vs. another. What I would like to be able to do is compare the count that match one query vs. the total count (or total of another query). In other words, if I had a customers table, I would like to answer the question "how many of the customers that were contacted in the last 6 months, have made a purchase within that period?" My value would be the count of contacted customers that made a purchase. The total would be customers contacted. I might want to set the threshold at 10% success. I pulled the example out of thin air, but we do have uses for this type of gauge widget. Is there a way to accomplish this now?

Mark_

Has an answer to this question come about over the last few years?

abureaux_0-1750870785112.png