Forum Discussion
SLA calculation
- 9 years ago
jopper1988 you mean like this?
AcceptedQueuetime<20 = calculate(countrows(table), queuetime < 20)
Accepted = sum(Accepted)
missed= sum(Missed)
SLA = divide(AcceptedQueuetime <20, (accepted + missed))
jopper1988 little bit difficult to conceptualise this without seeing your data?
in order to understand the underlying base measures in your calculation can you post screen shots of your data, is this at a row level or at a summarized level?
can you also give defitnions for accepted queuetime, accepted, missed etc?
- jopper19889 years agoFrequent Visitor
Hi,
Tnx for your help. I took some print screens of the data:
- vanessafvg9 years agoCommunity Champion
jopper1988 you mean like this?
AcceptedQueuetime<20 = calculate(countrows(table), queuetime < 20)
Accepted = sum(Accepted)
missed= sum(Missed)
SLA = divide(AcceptedQueuetime <20, (accepted + missed))
- jopper19889 years agoFrequent Visitor
If i use the code i get a error that the syntax is incorrect.