time pie chart

[master_student]

Hello community,

I have a table that contains measures about timings

Every row contains the timing of a case (that an agent spent to accomplich his task) SLA GLOBALE and a field SLA that contains the timing should be spent in evry task

i CREATED a calculated field to knwo witsh case are in time and witch one are out of time

SLA globale : =Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')

SLA = SUM(sla)

Delais : if(Column(1)>Column(2),'Hors Delais','Dans les delais')

I need to create a pie chart that contains number of case in time and number of case out of time

ANY idea please? i need your help

[swuehl · Accepted solution]

Maybe like this:

Calculated dimension:

=Aggr(

If( Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')) > SUM(sla)

,'Hors Delais'

,'Dans les delais')

,[Code Cas], PROVIDER_GRP_ID)

//not sure about the aggr dimensions needed, basically add all your chart dimensions shown above

Expression:

=Count(DISTINCT [Code Cas] &'/'& PROVIDER_GRP_ID)

//Again, create a value to count as combination of your aggr() dimensions

[master_student]

Thanks Stefan

Have a nice day