Google Data Studio: Day of Week Showing as Interger, Not Day Name

Question

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)

Answer 1

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)