Report on Business Application by Location

[Sean1232]

I am trying to build a report that will show in a pie chart the number of locations that have Oracle installed vs the number of locations that don't. I am trying to use our business application locations table but the locations repeat because many have more than one application installed. How can I distinctly count the Oracle and Non Oracle locations so I don't have repeated locations in the report?

[Arpan Baishya · Accepted solution]

Hi @Sean1232,

In your report settings, could you please try setting the Aggregate field to Count Distinct?  That might lead to only unique locations being considered, and solve your problem as a result.

Added an image below for your reference.