This is my current graph,and I am trying to combine two bars to make a 5th bar in the graph. Currently, I have
If [Date Completed] > [Due Date] THEN 'Urgent'
ELSEIF ISNULL([Date Completed]) and ISNULL([Due Date]) then 'Status'
ELSEIF not ISNULL([Date Completed]) THEN 'Done'
ELSE 'Not Done' END
I am trying to combine Status and Done parts to make a Total bar. Is there any good way to combine those two fields to make an additional bar in the graph?
Thank you so much
Can you show us what you have now and sketch up what would you like to see?
1. You can just OR your two conditions in a single ELSEIF statement
2. You can alias 'Status' and 'Done' to the same value
3. You can make a group out of this calc and group 'Status' and 'Done'