Nov 05 2020 03:05 PM
I have following columns in my data and would like to answer these question by creating a chart out of it:
Questions:
Ticket ID | Ticket Type | Created Date | Due Date |
1 | Project | 09/02/20 | 11/10/2020 |
2 | Task | 09/03/20 | 11/10/2020 |
3 | Incident | 09/03/20 | 10/3/2020 |
4 | Incident | 09/03/20 | 10/15/2020 |
5 | Project | 09/04/20 | 11/13/2020 |
6 | Task | 09/04/20 | 10/27/2020 |
7 | Project | 09/04/20 | 11/05/2020 |
*last ticket has due date as of today.
Can you please me with this?
Nov 06 2020 01:35 AM
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:
=IF(X2>TODAY(),"Due Date Approachig",IF(X2=TODAY(),"Due Today","Due Date Crossed"))
Where Ticket Type in Row, Status in Column and Due Date are as Value (Count).
N.B.