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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you explain this?
I would like to display the distinct number of POS systems that we have in our total footprint - as a single number.
Do you just mean the total # of POS systems? if so just make a gauge chart of the total number of systems and it will be one number.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I would like to display the distinct number of POS systems that we have in our total footprint - as a single number.
Do you just mean the total # of POS systems? if so just make a gauge chart of the total number of systems and it will be one number.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- 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__YouYes 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
------------------------------
