Why are some total information is not displayed for Chart Properties -> Presentation ->Show partial Sum?

[#1]

Hi there,

Raw data from the Informix database, I find some of the data of GOS can be displayed, but some data of GOS cannot be displayed.

GOS & ACD formula follow:

GOS:

If(period1 = SLA , sum(acdcalls1_sk) ,

If(period2 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) ,

If(period3 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk),

If(period4 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk),

If(period5 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk),

If(period6 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk),

If(period7 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk),

If(period8 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk),

If(period9 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk) + sum(acdcalls9_sk),

)))))))))

ACD1~9:

ACD1=sum(acdcalls1_sk) , ACD2=sum(acdcalls2_sk) , ACD3=sum(acdcalls3_sk) , and so on.

I want to know, why some team or country 's can be displayed  (marked in green), but some team or country can't be display(marked in red)?  Thank you in advance!

[its_anandrjs]

Try to Put

SLA in 'SLA' single  cots marks like

GOS:

If(period1 = 'SLA' , sum(acdcalls1_sk) ,

If(period2 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) ,

If(period3 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk),

If(period4 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk),

If(period5 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk),

If(period6 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk),

If(period7 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk),

If(period8 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk),

If(period9 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk) + sum(acdcalls9_sk),

)))))))))

[#3]

Hi Chouhan,

Thank you so much for your reply. ☺

But after change, all the total doesn’t display. ☹

Could you please help me find the reason? Thank you in advance!

Kind regards,

BinBing

[its_anandrjs]

It seems need to check your data can you provide sample data for this.

[#5]

Hi Chouhan,

Enclosed please find sample data and excel file.

In GOS field, some team or country ‘s total can’t be displays. (marked in red)

By country by team:

Just by team:

Really appreciate your help! ☺

Kind regards,

BinBing

[#6]

The expression u have written in GOS is incorrect.

Because period1 field don't have SLA data, it contains only numeric values.

Check the conditions u have written.

[#7 · Accepted solution]

Hi ,

Kindly try with the following Exp for GOS

sum(aggr(if(period1=SLA,sum(acdcalls1_sk),

if(period2=SLA,sum(acdcalls1_sk+acdcalls2_sk),

if(period3=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk),

if(period4=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk),

if(period5=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk),

if(period6=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk),

if(period7=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk),

if(period8=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk+acdcalls8_sk),

if(period9=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk+acdcalls8_sk+acdcalls9_sk),

))))))))),PGU,[Support Country], [Team Name], SLA,split,period1,period2,period3,period4,period5,period6,period7,period8,period9))

Thanks

Saurabh

[#8]

Hi Saurabh,

That's great! Problem solved!

Thank you very much for your help!

Have a great day!

kind regards,

BinBing

[#9]

Welcome