Converting date in chart data axis to week day name 1

[elansienna]

Can someone please instruct me on building a formula or converting a database datetime field where it will read the days of the week starting with "Monday" and repeat for each week in a month. Unfortunately I can get the chart to show only 7 days (as a result of a formula using the Weekdayname function), not the entire days of the month. It is needed for the (X) axis of a chart. Is a loop construct my only out? Any help will be appreciated.

 

[lbass]

I think you will have to use a formula something like:

totext({table.date},"dd") + " "+weekdayname(dayofweek({table.date}))

If you want to eliminate the day of month prefix, you will need to manually select each x_axis component->edit axis label and remove the prefix.

-LB

 

[elansienna]

Thanks lbass, I will try it! What a quick response.