Weekday function

[#1]

Hi,

I tried to use the weekday function in the Group expression. It is showing the random day names and also only day is displayed in the graph. Is it possible to use the Weekday function in the Group functions....

[prieper]

The WEEKDAY-function should return only a value from 0 to 6 which then is interpreted as Daynames (loaded in the beginning of the script). Make sure that the date you wish to convert is in the same format as in your operating system, otherwise you may force the interpretatioin with

WEEKDAY(DATE#(20110213, 'YYYYMMDD'))

HTH
Peter

[#3]

Thanks Peter,

but i want to use the column instead of a static value. if we use the column then it is showing only one day.

[prieper]

I do not get the point, can you please post an example?

Peter

[#5]

Hi Peter,

I am trying in the below way in the Cyclic group expression Weekday(Date). So when i am choosing the weekday it is showing only tuesday not any other days.

[prieper]

See the attached

HTH
Peter