exclude Cases

[master_student]

Hello Guys,

I have a table that contains cases , every case_id has many status like this :

My goal is to keep cases_id that has minimum one of this status

[Statut Cas]='Fermé crédit'

OR [Statut Cas]='Fermé-remboursé'

OR [Statut Cas]='Fermé activation'

OR [Statut Cas]='Fermé BO'

OR [Statut Cas]='Fermé DT'

OR [Statut Cas]='Fermé Rétention'

OR [Statut Cas]='Fermé Rétention Client Perdu'

OR [Statut Cas]='Fermé Rétention Client Retenu'

+ the other status of the case

The output would be :

The expression of the SLA Inter is =Interval(Sum(TOTAL <[Code Cas], [Date création], [Statut Cas], PROVIDER_GRP_ID> Interval#(SLA_INTERM, 's')), 'm')

Thanks a lot

[sunny_talwar]

May be this

=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')

[master_student]

Thanks Sunny,

your expression is correct, but the problem is that so many cases still appear and they don't contain one of the status above :

[sunny_talwar]

Could a case repeat within different PROVIDER_GRP_ID? or is the case a unique identifier?

[master_student]

every case has a unique identifier

[sunny_talwar · Accepted solution]

may be it does have one of the listed status with 0 SLA_INTERM value to it?

[master_student]

Yes Sunny, what you said is correct but how to appear this status even with 0 value

[master_student]

I uncheked supress null values in the presenation TAB and 0 values appear

Thanks Sunny