Calculation of weekdays (Saturday-Friday)

user01058
user01058
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!

Comments

  • Chronos
    Chronos

    Is anyone able to help out with this request?

  • RGranada
    RGranada 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 

    [email protected]

    **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.
  • Gimli
    Gimli 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.

Categories