Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a bar chart with date as dimension and count(VAR) for expression. What I would like to do is using different color for Saturdays and Sundays.
I have SET DayNames='Mon;Tues;Wed;Thu;Fri;Sat;Sun';
Anyone?
// Fjalar
Another technique is to grab the 'Sat' or 'Sun' from the date as follows:
if(
right(Date (Date,'WWW'),3) ='Sat'
or
right(Date (Date,'WWW'),3) ='Sun'
,
<weekendcolor>,
<weekdaycolor>
)
Hi FJalar,
In expressions tab, expand the expression and set in Background Color:
If(weekday(DateField)>=5, Red(), Green())
Switch red and green for the colours you want.
Another technique is to grab the 'Sat' or 'Sun' from the date as follows:
if(
right(Date (Date,'WWW'),3) ='Sat'
or
right(Date (Date,'WWW'),3) ='Sun'
,
<weekendcolor>,
<weekdaycolor>
)
Thanks,
Here I got Mondays and Tuesdays colored.
Thanks! I'll use this solution.
// Fjalar