Forum Discussion
ChayceDuncan
2 years agoQrew Captain
Your best bet is to make 2 new fields specific for reporting where you convert active/inactive to a numeric counter of 1 or 0.
So think like this:
Formula 1 - Active Counter: If( [Active],1,0)
Formula 2 - Inactive Counter: if( not [Active],1,0)
Then you can make a stacked bar chart where you place both of those counter fields as your Y Axis values and make the state your X.
The general idea is that checkboxes don't have a numeric quality to them, so you need to split it out to actually create the numeric equivalent of active/inactive for the report to count.
------------------------------
Chayce Duncan
------------------------------