Forum Discussion
Display Cumulative Percentage Over Time - Line Chart
bgierwi2 OK, well, this is going to depend a bit on what date you use for your x-axis and whether you want to count all Notifications every time or just those that were created prior to the specific date on the axis. Making some simplifying assumptions and using the only date in your sample data it should look something like this:
Measure = VAR __Date = MAX('Table'[Date Work Order Created]) VAR __AllCount = COUNTROWS(ALL('Table')) VAR __CurrentCount = COUNTROWS(FILTER(ALL('Table'),[Date Work Order Created] <> BLANK() && [Date Work Order Created] <= __Date)) RETURN DIVIDE(__CurrentCount, __AllCount, 0)
Greg_Deckler - Thank your for the response:
Here is some sample data
All of the notifications are already generated, and planners are creating WOs as they plan the work.
As a Work Order is created, another column shows the date the Work Order is created
This is in progress, eventually every notifiication will have a Work Order, and the progress will be 100%
| Notification | Work Order | Date Work Order Created |
| 17460816 | 90696104 | 9/9/2022 |
| 17452563 | ||
| 17452566 | 93072762 | 9/1/2022 |
| 17452680 | ||
| 17452682 | 95113238 | 8/15/2022 |
| 17452566 | ||
| 17451599 | 95115572 | 8/14/2022 |
| 17451601 | ||
| 17451602 | ||
| 17451604 | 99351374 | 8/1/2022 |
I would like to have a line chart:
X-Axis showing Date
Y-Axis Showing Count (Work Orders) / Count (Notifications)
That will track the progress of generating Work Orders from 0% to 100%
With this sample data, the progress should start at 0% and end at 50% (5 Work Orders generated out of 10 Notifications), between 8/1/2022 and 9/9/2022
I would like it to look something like what is below
bgierwi2 OK, well, this is going to depend a bit on what date you use for your x-axis and whether you want to count all Notifications every time or just those that were created prior to the specific date on the axis. Making some simplifying assumptions and using the only date in your sample data it should look something like this:
Measure =
VAR __Date = MAX('Table'[Date Work Order Created])
VAR __AllCount = COUNTROWS(ALL('Table'))
VAR __CurrentCount = COUNTROWS(FILTER(ALL('Table'),[Date Work Order Created] <> BLANK() && [Date Work Order Created] <= __Date))
RETURN
DIVIDE(__CurrentCount, __AllCount, 0)It worked!
Thank you so much!
I never would have come up with that on my own, this is exactly what I was looking for