Gauge Report - Select Distinct

Question

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 total footprint - as a single number.

Is there an easy way to do this?

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

markshnier__you · Answer

Can 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.&nbsp;Do you just mean the total # of POS systems?&nbsp; 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------------------------------

alexanderho · Answer

Thanks for the responseSample
Location #&nbsp; &nbsp; POS System345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oracle333​&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oracle399&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Clover340&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oracle876&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SquareUpI'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 · Answer

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
------------------------------

Forum Discussion

Gauge Report - Select Distinct