Forum Discussion

azaterol's avatar
azaterol
Helper V
4 years ago

Colorful Matrix

Hello everybody, I have a Matrix where the date is in. I want to get every week in diferent colors. The rows from day 1-7 in green, the rows 8-14 in blue and so on... Is this possible?     ...
Need Help
negi007's avatar
negi007
Community Champion
4 years ago

azaterol yes it is possible you can create a new calc column like below based on the day of the month

 

week_col_2 = if ([Day]<=7,"red",if([day]<=14,"green",if([day]<=21,"yellow","blue")))
 then apply the formatting like below
 
 

 


hope it helps you

 

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Hey @Syndicate_Admin ,

    ascas.PNG

    I want change in the matrix the Day"Tag" column. It is not a value...

    Any ideas?

    • negi007's avatar
      negi007
      Community Champion
      4 years ago

      azaterol you can change the color of any column basis the day like below. now below value column color is changing based on the day.