Format Dimension axis labels

[senarath]

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

[sunny_talwar · Accepted solution]

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

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())