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?
