Forum Discussion
How to visualise a date dependent status
After some steps I have this data set comming from a issue management software. Each number (Nummer) is a issues with a status that changes overtime. The date (Datum) column refers to the date the issue changed status. As un output, I would like a graph showing the evolution of the issue status overtime in a stacked area chart.
To visualize the date-dependent status of the issues in a stacked area chart, you can use the following steps:
Convert the "Datum" column to a date format, if it is not already in a date format.
Pivot the data to create a new column for each unique status value, using the "Nummer" column as the identifier and the "Datum" column as the values.
Fill any missing dates with the most recent status value using a method such as forward filling.
Plot the pivoted data in a stacked area chart, with the date on the x-axis and the count of each status value on the y-axis.
This will give you a visual representation of the status of each issue over time.
1 Reply
- MAwwad
Solution Sage
To visualize the date-dependent status of the issues in a stacked area chart, you can use the following steps:
Convert the "Datum" column to a date format, if it is not already in a date format.
Pivot the data to create a new column for each unique status value, using the "Nummer" column as the identifier and the "Datum" column as the values.
Fill any missing dates with the most recent status value using a method such as forward filling.
Plot the pivoted data in a stacked area chart, with the date on the x-axis and the count of each status value on the y-axis.
This will give you a visual representation of the status of each issue over time.