SLA Calculation %

[Anonymous]

Hi there, 

Can you please support me with the following SLA calculation, given that it has two parts and somehow the functions I've experimented, don't seem to be correct: 

[% of leavers = 

Effective Start Date 

Effective End Date 

Filters: 

French <> A1, A2

Attrition Date = 
Attrition Code = Impact_1

DIVIDE 

AVERAGE Leavers

Effective Start Date 

Effective End Date 

]

Thank you! 

[nsadams87xx]

Do you have a sample data set?

[Anonymous]

Unfortunately cant share, its on my clients environment. Apologies. 

[nsadams87xx]

Can you describe what your columns are?