Calculation of weekdays (Saturday-Friday)



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!


  • Chronos

    Is anyone able to help out with this request?

  • RGranada
    RGranada Contributor



    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 


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

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