Monday to Sunday shows as 1 - 7 in my report. Is it possible to show Day Names instead?
I have used this calculate field to get the "WEEKDAY" but it presents me with day numbers:
WEEKDAY(Date)
Monday to Sunday shows as 1 - 7 in my report. Is it possible to show Day Names instead?
I have used this calculate field to get the "WEEKDAY" but it presents me with day numbers:
WEEKDAY(Date)
The FORMAT_DATETIME function can format dates in a variety of different ways. In this case, you'll want to use %A which is the full weekday name.
FORMAT_DATETIME("%A", Date)