Bar Graph Only Showing Yes Answers

[buildmy401k]

Hello,

 

I have three categories Eligible, Participating, and active. All 3 categories are yes/no fields. I would like to have a graph which shows all the yeses from each category. For example: there are 84 - Eligible, 25 - Participating, and 16 - Active. Is there a way to do this? 

 

If there is not a way to do it as a graph, can it be shown in text format somehow? Thanks!

 

Allen

[Jan]

Hello Allen,

 

As far as I know now it is impossible to count "yes" values on the Chart.

You can use a Calculated fields to display count of "yes" values.

 

I would like to recommend you to create a Report with one record, on the Result page, add three Calculated fields and enter the formulas like:

SELECT COUNT(Eligible) FROM tablename WHERE Eligible=1

Where "Eligible" is the name of the field and "tablename" is the name of the table.

The tablename will be the same for all three fields, but fields will be different.

 

I hope, it helps.