This content has been marked as final. Show 2 replies
I'm trying to work out how to create a cumulative line chart that displays 2 lines showing the running totals of jobs created and jobs closed over a date/time period. The attached show 2 charts created by developers using another product. I'm trying to replicate these same charts in Qlik Sense.
A very small extract of my data set is as follows:
|Job_Number||Job Created||Job Closed||Job Status|
|2017-1100||27/04/2017 16:42||27/04/2017 19:45||Completed|
|2017-1102||27/04/2017 16:46||27/04/2017 17:50||Completed|
|2017-1103||27/04/2017 16:46||27/04/2017 18:30||Completed|
|2017-1104||27/04/2017 16:46||27/04/2017 22:00||Completed|
|2017-1105||27/04/2017 16:49||28/04/2017 9:15||Completed|
Any help and guidance here will certainly be appreciated.