
Contributor
2022-02-11
12:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Determining SLA using only dates. Must have ten day target
If I have columns similar to the example below and I have a 10 day targeted SLA. I am struggling to write the code needed to determine if we have hit our target or not? Not sure how i will display this , likely using a gauge chart with % in SLA. Any assistance would be GREATLY appreciated
Assigner | Programmer approved |
2/11/2022 | 2/18/2022 |
528 Views
1 Reply

MVP
2022-02-12
07:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, if there are 10 anatural days you only need to add 10 to the start date to get your target date:
LOAD ...
DateStart+10 as TargetDate
And in a post step calculate if the target is accomplished, I would reccomend to add a flag to check records that accomplsih the SLA so at the end you can use a simple expression like: Count({<SLAOkFlag={1}>} CaseID)/(Count CaseId)
hope this helps, there is no enough info about your model to be more especific.
495 Views
