Gauge Widget - Value from Count of sub-query

Discussion created by MichaelGayheart on Aug 3, 2013
Latest reply on May 5, 2016 by mark.stelzel
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?