topic Re: Percentage growth in chart in App Development

Percentage growth in chart

Anonymous — Thu, 28 Sep 2017 11:34:08 GMT

Hi,

In my chart visualisation I'm trying to set up a table where I can see the percentage change/growth of a value over time.

I have a table with Week in the first column and Value in the second column. To that I want to add a third column with a calculation of growth/change from week to week. Note that we cannot calculate the change for the first row since there is no previous week to compare to.

Week	Value	Change since last week(%)
10	200	-
11	400	100%
12	300	-25%
13	450	50%

How would this be calculated?

The solution doesn't have to be for weeks specifically but could just as well handle dates, months or years.

Thank you for your time.

Re: Percentage growth in chart

sunny_talwar — Thu, 28 Sep 2017 11:44:30 GMT

May be this

(Sum(Value)/Above(Sum({<Week>}Value)) - 1) * Avg(1)

Re: Percentage growth in chart

prat1507 — Thu, 28 Sep 2017 11:46:30 GMT

PFA the app for your reference.

Regards

Pratyush

Re: Percentage growth in chart

Anonymous — Thu, 28 Sep 2017 11:50:11 GMT

You made quick work of it!

The following solution works perfect!

Sum(Value)/Above(Sum({<Week>}Value)) - 1

Re: Percentage growth in chart

upaliwije — Thu, 28 Sep 2017 13:03:34 GMT

Dear Sunny

(Sum(Value)/Above(Sum({<Week>}Value)) - 1) * Avg(1)

how does -1 work in this expression. pls explain

Re: Percentage growth in chart

prat1507 — Thu, 28 Sep 2017 13:26:53 GMT

Hi Upali

Since you want to compare the current value with the previous one, using fractions the above expression would turn out to be:

(Sum(Value)/Above(Sum({<Week>}Value)) - 1) * Avg(1)

=(Sum(Value)-Above(Sum({<Week>}Value)))/Above(Sum({<Week>}Value)) * Avg(1)

(Sum(Value)-Above(Sum({<Week>}Value))) denotes --> Current - Previous

Above(Sum({<Week>}Value)) denotes --> Previous

Regards

Pratyush

Re: Percentage growth in chart

sunny_talwar — Thu, 28 Sep 2017 13:30:42 GMT

You calculate growth like this, right

(This-Previous)/Previous

If I expand the equation... it will look like this

This/Previous - Previous/Previous

Which is nothing but this

This/Previous - 1