Beast Mode Help - Pull Last Day In the Period

Tyler18702025 · 2025-01-24T16:57:35+00:00

There was an error rendering this rich post.

Tyler18702025

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!

Find more posts tagged with

Beast Mode

Accepted answers

Tyler18702025

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)

All comments

Ashleigh

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

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)