Skip to content

    • Archive

    Archive

    Calculation of weekdays (Saturday-Friday)

    Member
    in Archive

    Hallo,

    I want to create a card with downloads which should show the weekly development. For the week we don´t want to have the standard week (Monday-Sunday). We want to have for the week Saturday-Friday. Can you tell me how can i make the set ups in Beast Mode calculation?

     

    Thanks a lot in advance!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Member

      Is anyone able to help out with this request?

    • Contributor

      Hi,

       

      The following Beast Mode will give you the week number (weeks starting on Saturday) for a given date:

       

      MOD(FLOOR((DATEDIFF(your_date_field,'2006-01-01' )-6)/7),52)+1

       

      Tell me how it went.

      Hope this helps.

      Ricardo Granada 

      MajorDomo@Lusiaves

      **If the post solves your problem, mark it by clicking on "Accept as Solution"
      **You can say "Thank you" by clicking the thumbs up in the post that helped you.
    • Domo Employee

      If you need to do this on many cards and do not already have a fiscal calendar enabled you can reach out to our support team in order to create a fiscal calendar on cards that will do this for you without creating a beastmode. 
      support.domo.com

      **Say “Thanks" by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories