How can we exclude the latest date which is available in date column

Options
M_A
M_A Member
edited July 7 in Calculations & Variables (Beast Mode)

I was trying this beastmode formula, and it is giving NULL value for the latest date but when i am putting this formula as filter and selecting this option "Not in" the data shows like "No Data in Filtered Range"

CASE
WHEN Date = MAX(Date) OVER () THEN 'NULL'
ELSE Date
END

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    When using the over function, you need to use two aggregations. This should do it:

    MAX(MAX(date)) OVER()

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • M_A
    M_A Member

    I have also tried with max('date') formula and got the latest date and excluded the same but got the same issue.

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    When using the over function, you need to use two aggregations. This should do it:

    MAX(MAX(date)) OVER()

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories