Reset Running Total In Beast Mode

Options
andyRowan
andyRowan Member
in Beast Mode

Hi,

I am trying to reset the running count every time the week ending date changes. Any idea on how to do that in a beast mode as the basic setting just continues to accumulate.

image.png
Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    Adding a PARTITION BY would do it. Perhaps by WEEKNUMBER(datefield)

    **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.
  • andyRowan
    andyRowan Member

    Thanks so much!

    I did this which I am sure is wrong. I already did some manipulation to make that week ending date because for this exercise we want the week to end on sunday rather than staturday.

    count(id) OVER (PARTITION BY WEEK(Week Ending Date))

    Getting the below

    image.png
  • MarkSnodgrass
    MarkSnodgrass Coach

    @GrantSmith may know the answer to this one.

    **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