CODEWITHSUNDEEP
looker-studio
Dav
Dav

Reputation: 31

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

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)

Upvotes: 3

Views: 5999

Answers (1)

countunique
countunique

Reputation: 4296

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)

Upvotes: 7

Related Questions