days and numbers in chart

[#1]

hi all,

i did a chart with dimension group called: dates

the group is : dates- YYYY

                                MM

                                DD

                                HH24

i want to add that when the user choose year month and day he will see also in x-axis the NAME OF WEEK DAY. exp:

2012 feb

1      2     3     4    5    6 7 8

sun mon tue wed thu   ......

a tried to add to the group: dates - YYYY

                                                    MM

                                                    DD AND DAYSOFTHEWEEK

but its not working, does anyone have an idea.

thanks

eran

[sivarajs]

Hi,

use weekday(date)

Sivaraj S

[v_iyyappan]

Hi,

     I attached a sample QV file. Hope its help.

Iyyappan

[#4 · Accepted solution]

thank you for the help,

i succeded eventually with this formula: =date((DD),'DD-WWW')

but the chart confusing with the date of day.

thank you

[v_iyyappan]

Hi,

     I am little bit confused can u attach a sample file?

Iyyappan

[#6]

i wanted to check when can i put in chart in the x-axis, the date of the and near to him to put the name of the day.

exp:

APRIL 2012

1/4 2/4 3/4/ 4/4 5/4 ....

1/4        2/4          3/4      4/4       5/4       

SUN      MON       TUE   WED     THU

to do it we need to write this: =date((my date format),'DD-WWW')

someone answer me so i put rhis here that the answer will be here.

thanks

eran

[#7]

Hi This will work as u require

=date(today(),'DD/MM

WWW')