Changing a day week start to Friday

hamza_123
hamza_123 Contributor

I want to change the start of week days to Friday only for 3 cards on my dashboard. Can anyone tell me how to do that?

 

I know I can change this in company settings, but I only want to apply this rule to 3 cards and not the entire company

I know that I can change the start week day in a date filter card, but that does not apply to graph cards. 

 

 

Comments

  • You can change the week display in company settings, but what you're asking for here I think is different.  You can set up a fiscal calendar and just use it for the 3 cards you need it for, this link will show you what you'd have to do to get it.  

     

    If you just wanted to change the order of the display of the dates in your 3 cards, you could use beast mode to create a new day of week rank.  Something like:

     

    case
    when DAYOFWEEK(DATE()) = 6 then 1 -- friday
    when DAYOFWEEK(DATE()) = 7 then 2 -- saturday
    when DAYOFWEEK(DATE()) = 1 then 3 -- Sunday
    --you get the point....

    end

     

    Hope that helps.

    Matt

     

This discussion has been closed.