Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a table that contains the following dimensions and measures
Here are my expressions :
SLA INTER=num#(Interval(Sum({<[Code Cas] = p({<[Statut Cas] = {'Fermé crédit', 'Fermé-remboursé', 'Fermé activation', 'Fermé BO', 'Fermé DT', 'Fermé Rétention', 'Fermé Rétention Client Perdu', 'Fermé Rétention Client Retenu'}>})>}TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_INTERM, 's')), 'm'))
SLA INTER obje=If(
ser ='Bo Facturation' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
), '2880',
if(
ser ='Bo Facturation' and (
segment= 'LowEndUser'
or segment='HighEndUser'
or segment='Entreprise'
or segment='One to one'
), '1440',
if (
ser ='BO TECKNO ' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
or segment ='LowEndUser'
or segment ='LowEndUser'
or segment ='HighEndUser'
or segment ='Entreprise'
or segment ='One to one'
), '1440'
,
if (
ser ='DT Support +Fixe + Delivery' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
), '2880'
,
if (
ser ='DT Support +Fixe + Delivery' and (
segment= 'LowEndUser'
or segment='HighEndUser'
or segment='Entreprise'
or segment='One to one'
), '1440'
)))))
Hors delais :
if(Column(1)>=Column(2),count(DISTINCT([Code Cas])))
DANS delais : if(Column(1)<Column(2),count(DISTINCT([Code Cas])))
I would like to make a graph number of cases hors delais / dans les delais per services
here is my dimensions calculated :
=Aggr(
If( Sum(TOTAL <[Code Cas], segment,PROVIDER_GRP_ID> num#(Interval(Interval#(SLA_INTERM, 's'), 'm'))) >
If(
ser ='Bo Facturation' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
), '2880',
if(
ser ='Bo Facturation' and (
segment= 'LowEndUser'
or segment='HighEndUser'
or segment='Entreprise'
or segment='One to one'
), '1440',
if (
ser ='BO TECKNO ' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
or segment ='LowEndUser'
or segment ='LowEndUser'
or segment ='HighEndUser'
or segment ='Entreprise'
or segment ='One to one'
), '1440'
,
if (
ser ='DT Support +Fixe + Delivery' and (
segment= 'VLV'
or segment='LV'
or segment='MV'
or segment='HV'
or segment='HD'
or segment='Premium'
), '2880'
,
if (
ser ='DT Support +Fixe + Delivery' and (
segment= 'LowEndUser'
or segment='HighEndUser'
or segment='Entreprise'
or segment='One to one'
), '1440'
)))))
,'Hors Delais'
,'Dans les delais')
,[Code Cas],segment, PROVIDER_GRP_ID)
My expression :
cas traités :
count(DISTINCT
[Code Cas])
My graph
The problem is the number in my graph are not identiqual to the detailed tables, can you please help me to correcte the expressions on my graphs ?
Thanks