Weekday function

[Anonymous]

Hi all,

Does anybody know a way to label a date by weekday, when it is been using as a dimension? I have a bar chart in which the dimension is a date. Besides having the date, i wanted to show the correspondent weekday, eg, Thu 08-03-2018.

I know the weekday() funtion, but the problem with this function is that it aggregates all mondays, all tuesdays, etc and that's not what's needed.

Does anyone have a suggestions to this?

Thank you!

[swuehl · Accepted solution]

Try to format your date like

Date(DateField,'WWW DD-MM-YYYY')

[YoussefBelloum]

Hi,

try this:

=WeekDay(Date)&'-'&Date

[Anonymous]

It works perfectly! Thank you very much.

[Anonymous]

Thank you youssef. Probably this function also works, but i couldn't sort the dates properly...

[YoussefBelloum]

you're welcome. of course you can, you can always use Max(Date) ascending on the sorting expression.