Forum Discussion
Chart for approaching Due Dates
I have following columns in my data and would like to answer these question by creating a chart out of it: Questions: Need a chart which shows How many tickets are approaching due dates? Descend...
To fix the issue you need to summarize the data by using one Helper Column, and the name given to it is STATUS.
How it works:
- Formula in cell Y2:
=IF(X2>TODAY(),"Due Date Approachig",IF(X2=TODAY(),"Due Today","Due Date Crossed"))
- Create Pivot Tale.
Where Ticket Type in Row, Status in Column and Due Date are as Value (Count).
- Now create a Combo Pivot Chart.
N.B.
- Both PT & Pivot Chart can be filtered on Ticket Type and Status.