How can we help?

New post
0

Show monthly change percentage in Bar Line Chart

Avatar
Eren Hukumdar
None
Follow

Hi,

I am trying to add a monthly percentage change to my Bar/Line Chart.

I tried to apply the steps explained in this post but couldn't manage to adapt it to my chart: https://support.klipfolio.com/hc/en-us/community/posts/360029668653-Calculate-monthly-increments-in-Bar-Line-Chart

My chart shows the total durations grouped by month. I am trying to add a monthly percentage change of duration to this:

Using the data below:

X Axis: @month

Y Series: @duration/60

I added a new series and wrote the below formula but this doesn't work:

(&Series: Duration-ARRAY(SUMIF(DATE_IN(DATE(@month,"MMM yyyy"),"3",-4)),SLICE(&Series: Duration,0,-1))) / ARRAY(SUMIF(DATE_IN(DATE(@month,"MMM yyyy"),"3",-4)),SLICE(&Series: Duration,0,-1))*100

How should I write the formula?

Thanks,

Date Votes

2 comments

  • Avatar
    Parker Selman Official comment

    Hi! 

    Thanks for the post.


    Your formula is missing a sum range in both the SUMIF functions, and as such the formula doesn't know what to sum. To resolve this, you'll need to add another term to your SUMIF function that references the same data that your duration series does. In fact, it's likely best to copy the formula of the duration series and insert it directly as this 2nd term. The formula below should therefore return the relative % change per month:


    Hope this helps! If you have any further questions around this, please log a ticket with us at support@klipfolio.com 

    Parker

  • 0
    Avatar
    Eren Hukumdar

    Hi Parker, this worked! Now I can see the change in duration.

    Thank you very much for your help!

Please sign in to leave a comment.