I am trying to create a dashboard that projects a per-person quantity of items that meet a criteria vs. a quantity of items that don’t meet the criteria.
The criteria being that two separate date columns have values.
I was easily able to create a dashboard that shows how many items are assigned to our team members. So let’s say Justin has 17. However, only 15 have two dates filled in. I want a dashboard (stacked bar chart preferably) that shows 15 and 2.
When I wasn’t able to achieve this in dashboards, I tried to write some formulas. Then I could use the formula output to create a status and when that status was met, set up an automation for the item to be regrouped. That would allow me to display easily using the group in my x-axis.
Unfortunately, I can’t figure out this formula. Does anyone have any guidance for me? Much appreciated!