Growth Rate

Comments

2 comments

  • Avatar
    Ido Darnell

    Hi Jessica,

    I believe you'll be able to utilise this plugin which simplifies pivot API calls.

    Then have a go at this script available here.

    That script if for a running sum, but you will probably be able to modify the script so it give you the running product and not the running sum.

    If you're ok with calculating this in the EC, have a look at this article.

    Also there, you will need to manipulate the SQL query to provide a running product and not sum.

    Let me know if you'd like to further discuss,

    ido.darnell@qbeeq.pl

    www.qbeeq.pl

     

    0
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    Thanks Ido!

    I was initially trying to do the running product calculation but I am noticing the query which is similar to this one (https://support.sisense.com/hc/en-us/articles/360007490013-Calculate-Running-Sum) is dropping Months from my first Month column (October 2003 and January 2004) I noticed immediately. The InvestorName part of the query isn't messing this up because it is only filtered for one Investor so I am not sure why it is dropping certain months. 

     

     

    Here is what the table looks like without any self join

    0
    Comment actions Permalink

Please sign in to leave a comment.