Jump to content
  • 0

Bar Graph Only Showing Yes Answers


buildmy401k
 Share

Question

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

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...