Report Counting Different Entries in a Field

You can simply select the entire collumn and then copy and paste the contents into Excel then remove the duplicates. This will give you a count of all the buildings.

I have been able to get  it without duplicates by adding the Building property, and then adding it again with the Count function. This basically gives me a device count per building. If I could only get a total row count as a total building count then I'd be golden.

I was hoping to get this done directly on the report so I can point other people to it, but copying into Excel is still better than manually counting rows on 8 pages of the report.

Try this.

Change your report to a SQL Report and enter in this (assuming Building is the actual custom property name)

Select Building,COUNT (Distinct NodeID) as TotalDevices

From Nodes

Group by Building

Mike, your SQL query was returning the same results as my above standard Report, but it did get me thinking:

Select COUNT (Distinct Building) as UniqueBuildings

From Nodes

Was what I was looking for. Thanks for pointing me in the right direction!

Sorry I thought you were wanting devices per buildings....not distinct building....Misunderstood...but glad to help regardless.