0 values in Xcelsius dashboards

[Former Member]

Hi All

I have  couple of charts in my Xcelsius Dashboards. In those charts there could be few values of 0 which I do not want it to reflect it to the charts.

For eg. Sales of the month of ' January' for ' Android ' tablets could be zero and for rest of the months sales having non-zero values. In this case I do not want the month of january having 0 sales to be reflected on my charts.

Regards,

Anshul

[Former Member · Accepted solution]

Hi Anshul,

Theres a workaround for your scenario

Please see the below

Write a Formula in A1 cell

=if(C1=0,0,1)

Then Drag that Formula to all cells

U have 0's in the cells where amount is zero

Now take a Combo box ,bind the labels field to A column values(0,1)(Let Suppose A1:A12)

and set the insertion type to Filtered rows

Take the source data as B and C columns data(Let suppose B1:C12)

Give the Destination to Two columns data (Let suppose F1:G12)

Take any empty cell in excel sheet and write '1' in that cell(Let Suppose A15)

Under the behavior properties of the combo box,  in the common tab set the selected item

Type to 'Label' and bind the item to the cell where we write '1'(A15)

So for combo box the default selection is always '1'.It gives the data which doesn't have '0'

Now Take the column chart

Take the values from G1:G12

Take the Category labels from F1:F12

Under the behavior tab of column chart, in common tab check In series and In Values under Ignore blank cells.

Now u can get your requirement

Let me know if u have any issues

Regards,

MVVK

[Former Member · Accepted solution]

Great job Venkat !!!!!

Regards,

Naresh

[Former Member · Accepted solution]

Thanks Yaar

Regards

MVVK

[Former Member · Accepted solution]

Venkat Sir !!

Superb You are !!

[Former Member · Accepted solution]

Thanks Anshul

Regards,

MVVK

[vkris215 · Accepted solution]

Hello,

Even I'm facing the same issue and I tried this workaround and this Evil plan worked ..

Thanks Venkat,

KC.

[nikhil_joy2]

Hi Anshul,

As Naresh has mentioned we don't have a direct way to ignore values with 0 in the middle of the charts. But we have simple workarounds to achieve it. Please refer below thread in which i have shown a workaround for a similar requirement using one combo box extra. Please see if it is helpful for you.

http://scn.sap.com/message/13310433#13310433

Let me know if you have any doubts on this.

Regards,

Nikhil Joy

[Former Member]

Hi,

To my knowledge we cannot ignore the values with 0 in the middle of the charts but if you can sort them in descending order then you can ignore them at the end of the range ( you will have this option in Behaviour -> Common tab).

Regards,

Naresh