Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a table that compares two values and display dans les delais or Hors delais according to the result of comparaison
heres my caculated dimension
=Aggr(
If( Sum(TOTAL <[Code Cas]> num#(Interval#(SLA_GLOBAL, 's'), 'm')) >
if([Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'
or segment = 'MV'
or segment = 'HD'
or segment = 'HV'
or segment = 'Premium'
),4320,
if([Criticité cas ] = 'Non Critique' and (segment ='LowEndUser' or segment = 'HighEndUser'
or segment = 'Entreprise'
),2880,
if([Criticité cas ] = 'Non Critique' and (segment ='One to one'
),1440
,
if([Criticité cas ] ='Critique' and (segment = 'VLV' or segment = 'LV'
or segment = 'MV'
or segment = 'HD'
or segment = 'HV'
or segment = 'Premium' or
segment ='LowEndUser' or segment = 'HighEndUser'
or segment = 'Entreprise'
Or segment='one to one')
,1440
))))
,'Hors Delais'
,'Dans les delais')
,[Code Cas])
expression
SLA Globale :
num#(Interval(Interval#(SLA_GLOBAL, 's'), 'm'))
SLA objective :
if([Criticité cas ] = 'Non Critique' and (segment = 'VLV' or segment = 'LV'
or segment = 'MV'
or segment = 'HD'
or segment = 'HV'
or segment = 'Premium'
),'4320' ,
if([Criticité cas ] = 'Non Critique' and (segment ='LowEndUser' or segment = 'HighEndUser'
or segment = 'Entreprise'
),'2880',
if([Criticité cas ] = 'Non Critique' and (segment ='One to one'
),'1440'
,
if([Criticité cas ] ='Critique' and (segment = 'VLV' or segment = 'LV'
or segment = 'MV'
or segment = 'HD'
or segment = 'HV'
or segment = 'Premium' or
segment ='LowEndUser' or segment = 'HighEndUser'
or segment = 'Entreprise'
Or segment='one to one')
,'1440'
))))
What is the issue?