Percent Change Month to Month

Whimzyy

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! 

Screen Shot 2020-06-08 at 11.38.17 AM.png

jaeW_at_Onyx

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'.