Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mmoore44
Contributor

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
1 Reply
rubenmarin

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.