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
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.
