1 Reply Latest reply: Apr 1, 2016 6:21 PM by Sunny Talwar RSS

    Format Dimension axis labels

    Senarath Bandara Herath

      Hi

       

      I have created a combo chart adding Day as Dimension. My requirement is to show WeekEnds by a different color

       

      Appreciate any advice as to how to handle this. I need any solution in order to identify week ends.

       

      Thanks

      Senarath

       

      Capture.PNG

        • Re: Format Dimension axis labels
          Sunny Talwar

          Are you viewing this chart for one month at a time? Because 1 can be weekday for 1 month and weekend for another? If it is just 1 week at a time, then may be look at the attached

           

          Capture.PNG

           

          Script:

           

          Table:

          LOAD *,

            WeekDay(Date) as WeekDay,

            Day(Date) as Day,

            Month(Date) as Month,

            MonthName(Date) as MonthYear;

          LOAD Date(MakeDate(2015, 12, 31) + RecNo()) as Date,

            NORMINV(Rand(), 1000, 10) as Sales

          AutoGenerate Today() - MakeDate(2015, 12, 31);

           

          Expression used for color:

          =If(Match(WeekDay, 'Sun', 'Sat'), LightRed())

           

          Capture.PNG