Format Dimension axis labels

senarath — Fri, 01 Apr 2016 15:09:37 GMT

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

Re: Format Dimension axis labels

sunny_talwar — Fri, 01 Apr 2016 22:21:44 GMT

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

topic Format Dimension axis labels in Scalability

Format Dimension axis labels

Re: Format Dimension axis labels