Shafique Kassam

Report on a Top 3 count of several checkbox values?

Discussion created by Shafique Kassam on Dec 7, 2016

In a single module (Contacts), I’ve got a data model that looks like:

 

Name

Address

Other Stuff

IsDoctor

IsStudent

IsRetired

IsUnemployed

IsSelfEmployed

 

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!

 

Thanks,

Shafique

Outcomes