Percent Change Month to Month

Hey everyone! 

 

Somewhat new to Domo and having trouble setting up a Percent Change formula for Month to Month. Below is the screen shot of the current card I am using. The claim count on the Y axis is already using COUNT(DISTINCT) but I am wanting to add more to the beastmode. 

 

For example Apr is 127 and May is 133 I am wanting to show the 4.5% difference as another line. 

 

Thanks! 

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    Hey @Whimzyy ,

     

    I recommend you try to put your report together in table builder first b/c this might require some experimentation.

     

    given that you're trying to do count(distinct) things can get hairy,

     

    but i think you can get your number using a lag function.  check out this tutorial.  https://www.youtube.com/watch?v=cnc6gMKZ9R8&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=19&t=11s

     

    from there, you'll just do sum(amount) / lag(... )

     

    In order to do a lag function, you may need to check with your CSM to see if you can get 'window functions enabled in beast modes'.


    Jae Wilson
    Check out my Domo Training YouTube Channel

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Awesome, Thank you. 

     

    I will check out the tutorial and see how it goes. 

     

    I appreciate the help! 

     

    Thanks!! 

This discussion has been closed.