Hello, need to find a way to create a temporal evolution chart, my table looks like this:
ID Status Created Closed Updated Snapshot
1 New 01/02/2022 20/05/2022 04/02/2022 14/02/2022
1 New 01/02/2022 20/05/2022 04/02/2022 22/02/2022
1 ToDO 01/02/2022 20/05/2022 25/02/2022 11/03/2022
1 Review 01/02/2022 20/05/2022 11/04/2022 15/03/2022
1 Closed 01/02/2022 20/05/2022 20/05/2022 22/05/2022
1 Closed 01/02/2022 20/05/2022 15/06/2022 24/06/2022
1 Closed 01/02/2022 20/05/2022 15/06/2022 12/07/2022
1 ... 23/08/2022
2 ToDo 02/04/2022 11/07/2022 05/03/2022 15/03/2022
2 Review 02/04/2022 11/07/2022 02/05/2022 22/05/2022
2 Closed 02/04/2022 11/07/2022 11/06/2022 24/06/2022
2 Closed 02/04/2022 11/07/2022 11/06/2022 12/07/2022
2 ... 23/08/2022
3 Closed 12/05/2022 21/08/2022 21/05/2022 22/05/2022
3 Closed 12/05/2022 21/08/2022 21/05/2022 24/06/2022
3 Closed 12/05/2022 21/08/2022 21/05/2022 12/07/2022
3 ... 23/08/2022
Updated is a date when something is changed in that ticket, can be anything, even in other columns which i didn't specified here.
Snapshot is just a date to cumulate info about a ticket, i'm using this column to calculate how many tickets were closed from the beggning of the collection.
What's the best approch if i want to display a single Line Chart with: a number of tickets that are new(prefered to use the [Created] column because a ticket will not necessary have a status of "New"), number of tickets that are closed and others for different statuses.
