Calculation of weekdays (Saturday-Friday)

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

  • Is anyone able to help out with this request?

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

  • 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

This discussion has been closed.