Show % Difference

[jamelmessaoud]

Hi guys,

I have the following line chart

Is it possible on this same chart to show the % increase/decrease from week to week? For example difference between Week 1 and Week 2 or difference between Week 3 and Week 2?

Not sure if this is possible or not, so thought i would ask the experts! 

Thanks
J

[YoussefBelloum]

Hi,

create another line on which you can try to use above() function

[jamelmessaoud]

Hi Youssef,

Thank you for the quick reply.  I have never used the above function, so I will look into that

Thanks

[jamelmessaoud]

Hi Youssef,

I cannot figure this one out.  I am using a simple sum(parcels) for the line at the moment and the dimension is a week number.

Can you offer any advice as to how to show a percentage difference between the week numbers?

Thanks
J

[timpoismans · Accepted solution]

Hi

Is this something you had in mind:

Staves is the sum of the parcels, line is the percentage (secundary).

Measure used to calculate the percentage is:

=(
Sum(Parcels)
-
Above(Sum(Parcels),1,1)
)
/
Above(Sum(Parcels),1,1)

This will result in a percentage that compares one week to the one before.
For example: In week 2, Sum(Parcels) had a positive rise of 83.31% compared to last week.

[sunny_talwar]

What expression are you using in your line chart right now? Try this
Expression - Above(Expression)

[YoussefBelloum]

@jamelmessaoud

Sunny's suggestion is what you need

[jamelmessaoud]

Thanks for all your help guys. I did sum(Parcels) / Above(Sum(Parcels))

Easy when you know how! 

Thanks everyone