Best Of

Hi @etszyingho

Your beast mode should automatically take into account your date filtering. Since you're using a pivot table things get a bit funky. How are you partitioning your data within your pivot table (what are you using for the columns)?

Window functions and pivot tables can be tricky. Glad you got it figured out!

Hi @Salmas

Beast modes are evaluated on a row basis and typically don't know of other rows. So in your case it won't ever see a row with rank 1 if it's on the row of rank 2. When you subtract NULL from something the ending result is NULL which is why you have blank output.

You'd need to use the LAG (prior) or LEAD (next) function to get the appropriate value you want to evaluate. Make sure you order your data correctly with your lag/lead function otherwise you'll get unexpected results.

Here's a post I did on rolling average which might give you some additional insight into how LAG/LEAD work.

Domo IDEAs Conference - Beast Modes - Rolling Averages

If you don't have access to the LAG and LEAD functions in a beast mode you might need to talk with your CSM to get it enabled.

Its likely possible with a beast mode and just filter the card based on when that beast mode is the current month. The question is how do you define the current month?

With Domo when you're using the date selector it determines which month you're currently in and selects days 1-28/29/30/31 (month depending). It sounds like your business definition of a month is different since you're expecting the current month to be August 29th-Oct 2nd. How do you know that August 29th is the first day of the current month and the 2nd is the last day of the current month?