Combo Chart % Change Missing Value

[#1]

Hi all,

I have a basic combo chart with two expressions Sum() and Column(1) / Above(Column(1)

Is it possible to adjust the expression so that it draws the line from the begging and shows the % change of the first bar?

Thanks,
Ivelin

[Gysbert_Wassenaar]

Nope, there is no bar before the first bar so the expression cannot be calculated for the first bar. The % of change for the first bar doesn't exist. There was no bar before the first bar in the chart and therefore no change.

What you can do instead is calculate the change in the script. See attached example.

[arjunkrishnan]

Hi Lvelin,

I make Little Changes In Ur App ...

Look Now It's Ok or Not

Lets Find My AttachMent

[#4]

In your combo chart you are using Sum() and Column(1) / Above(Column(1) these 2 expressions.

So for the second exprssion ur using above function.Above function takes the value from previous row. For first bar there won't be any previous value so it will be null(-).

Hence its not showing the % change of first bar.

[#5]

Is there a different expression which can do the same job? Doesn't have to be Column(1) / Above(Column(1) per se

[Gysbert_Wassenaar]

If you really want you can use this:

Column(1) / if(RowNo()>1,  Above(Column(1)), $(=sum({<date={20140101}>}value)) ) -1

[#7]

For the first row take the same value as column 1, otherwise use the same expression of above.

Like,

Column(1) / if(RowNo()>1,Above(Column(1))-1,Column(1))

Hope this will help you.!