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) Site favicon Customer Support 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)

Beast Mode

Beast Mode

Beast Mode Help - Pull Last Day In the Period

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories