total

[#1]

Hi all,

          

       Can anyone know how to set the first Total column's value to zero?

       And I also don't know why the Total column's value is '-'.

       The expression as follow:

       Please help to solve the problem.

     Thanks too much

     Going

[simenkg]

There are many issues here, but the reason you get - in the total is because [Static Field1] has both Open and Close as possible values, and therefore calling the field without an aggregation function returns null().

Could you not simplify this whole expression to simply

Count({$<OB_Call_Flag={'Yes'}>}[OB Call Id])

Then you format the expression on the "Number"-tab of the charts properties box.

[SunilChauhan]

try dimesionality()

like

if ( dimesionality()=0,0,expression)

or

if ( secondarydimesionality()=0,0,expression)

hope this helps

[#4]

Hi ,

Thanks for your reply.

But follow your advice, it also doesn't work.

Best regards,

Going

[SunilChauhan]

presentation->Null symbol and missing symbol place 0 inplace of -

hope this helps

[#6]

Hi chauhans85,

     Follow your advice, the Total column's value is zero.

    But when the "no answer", "busy" ... columns have values(not zero), the Total column should show the sum number, not zero.

    Hope you understand.

[simenkg]

I suspect this is a combination of issues.

Replace the dimension [Static Field1] with [OB.Task.Task Indicator] and [Static Field2] with [OB.Call.Activity.Status] and use the expression I suggested.

[#8]

Hi all,

 
     Can anyone help me? Thanks too much in advance.