1 of 1 people found this helpful
Create a calculated field called "Day" and then put this in it:
Move it to dimensions pane, make it discrete and then use it to replace the DAY(Date) pill.
Thank you for you answer Shwan, however the function DATEPART ('day', ...) returns the date to a number and looses its date format, so it is hard to interpret for the viewers. But, that's fine, I got that it is not possible to change the alias the way I want right now. I just hope it will get fixed soon (I voted Kettan), because the display is here not optimal.
datetrunc instead should work
Yes, that worked with datetrunc.
Thanks a lot for your help!