Forum Discussion
Calculate Difference Between Two Monthly Measures
I hope I can explain this well enough. I am trying to create a visual showing the difference each month in addition to rolling over open transactions to the next month's total. I have searched the i...
Greg_Deckler I hope this helps explain it better. I think I will focus on objective 1 for now.
>>The most important parts are:
1. Sample data as text, use the table tool in the editing bar - pasted below
2. Expected output from sample data - count and/or % of created work orders not closed each month
3. Explanation in words of how to get from 1. to 2. - will hold off on this one for now
- add work orders still open (sum of #1), at end of month, to next month's created work order total
- think of this as tracking monthly cellular roll over minutes (from way back when)
DATA SAMPLE SET:
Created On Work Order WO Status Assigned Type Completed Date
| 01/06/2023 10:04 AM | WO-0015133 | Completed | Internal | 1/6/23 |
| 01/06/2023 10:26 AM | WO-0015134 | In Process | External | |
| 01/18/2023 07:53 AM | WO-0015665 | Completed | External | 1/26/23 |
| 01/23/2023 10:14 AM | WO-0015915 | In Process | Internal | |
| 02/02/2023 09:11 AM | WO-0016423 | Completed | Internal | 2/2/23 |
| 03/02/2023 03:43 PM | WO-0017703 | Completed | Internal | 3/8/23 |
| 03/08/2023 07:44 AM | WO-0017952 | Completed | Internal | 3/8/23 |
| 04/03/2023 07:37 AM | WO-0019248 | Completed | Internal | 5/8/23 |
| 02/08/2023 02:07 PM | WO-0016704 | In Process | Internal |
|