Beast Mode Help - Pull Last Day In the Period

Tyler18702025 · January 24

Hello DOMO Community,

I have a dataset that keeps a running total of users by day.

I need a beast mode that pulls the last value from the running total column for the filtered period based on date.

EX if the filtered period on a card is 5/25/24-11/16/24 I need the beast mode to return the running total value from 11/16/24.

My hope is for this to be dynamic so that no matter what dates a card is filtered by this formula will always return the last value from the running total column.

Thanks in advance DOMO community!

Tyler18702025 · January 27

For any future DOMOs experiencing this challenge we were able to achieve this using this beast mode:

MAX(CASE WHEN date field IS NOT NULL THEN running total field END)

Ashleigh · January 24

Hey @Tyler18702025 I think you may be able to use fixed function to achieve this (see link below). You could set up something for it to create a running total when the date=max(date) https://domo-support.domo.com/s/article/4408174643607?language=en_US

Tyler18702025 · January 27

For any future DOMOs experiencing this challenge we were able to achieve this using this beast mode:

MAX(CASE WHEN date field IS NOT NULL THEN running total field END)

Beast Mode Help - Pull Last Day In the Period

Best Answer

Answers

Categories