Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try to format your date like
Date(DateField,'WWW DD-MM-YYYY')
Hi,
try this:
=WeekDay(Date)&'-'&Date
It works perfectly! Thank you very much.
Thank you youssef. Probably this function also works, but i couldn't sort the dates properly...
you're welcome. of course you can, you can always use Max(Date) ascending on the sorting expression.