Forum Discussion

Qrew Member

4 years ago

Gauge Report - Select Distinct

I like how the gauge reports look on the new dashboard. I have a list of retail locations using different POS systems. I would like to display the distinct number of POS systems that we have in our to...

reports and charts

AlexanderHo

Qrew Member

Thanks for the response

Sample

Location # POS System
345 Oracle
333 Oracle
399 Clover
340 Oracle
876 SquareUp

I'd like the Gauge report to give me a total # of distinct POS systems = 3 (Oracle, Clover, SquareUp)

I'm creating a dashboard to show how fragmented our IT environment is (= opportunity to simplify/standardize)

------------------------------
Alexander Ho
------------------------------

MarkShnier__You

Qrew Legend

4 years ago

Yes this can be easily done. But unless we use Formula Queries which are still in Beta we will need to have a helper table set up. This will be a table with one Record ID in it and of course it will be Record ID = 1. Make a relationship between the helper table and your detailed records of these POS systems. Obviously because the Record ID of the helper table is 1 the reference field will be a formula of 1.

Then make a summary field on that relationship and do a distinct count on the [POS System].

Then do a gauge chart on the helper table to summarize that value.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------