Forum Discussion
Solved
Need dashboard for Resolved VS Created Tickets.
Following is my snippet data for creating the dashboard. Ticket ID Created Status 1 11/03/2020 Closed 2 11/01/2020 To Do 3 10/28/2020 In Progress 4 10/25/2020 Closed I ...
You may try this:
How it works:
- Create Pivot Table.
- Keep Date in ROW, Details in COLUMN and Ticket in VALUE and set COUNT for Ticket.
- Select PT now from Design, then Layout & hit Grad Total, and click on for column only.
- Then Create a Line Chart.
Note: Working with PT is a wise way to do this.
You may try this:
How it works:
- Create Pivot Table.
- Keep Date in ROW, Details in COLUMN and Ticket in VALUE and set COUNT for Ticket.
- Select PT now from Design, then Layout & hit Grad Total, and click on for column only.
- Then Create a Line Chart.
Note: Working with PT is a wise way to do this.
Rajesh_Sinha Thank you so much. You are miracle Excel Expert.
- Glad to help you JayJoshi ,,, keep asking ☺
