Gauge Widget - Value from Count of sub-query

4364
1
08-03-2013 11:35 AM
MichaelGayheart1
New Contributor III
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?
0 Kudos
1 Reply
MarkStelzel
New Contributor III

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

0 Kudos