In a single module (Contacts), I’ve got a data model that looks like:
I want to run a report across all Contacts that shows me the top 3 occupations. Essentially I want to count all of the TRUE values for each of the "Is" columns above, then display the top 3 in a bar chart or similar.
I tried a few different variations but can't seem to get the total count of TRUE values in each column.
Any ideas? I can do this report in Excel pretty easily.. just need to figure it out in SugarCRM!