How to change the day of week number to text... like Monday, Tuesday....etc?

Looker Q&A Looker
1

StephenW_1-1733397037949.png
StephenW_1-1733397037949.png1457×571 40.5 KB

Dear ALL, would you please to guide me how to change teh day of week number to “Monday”, " Tuesday"…etc? I have used the “WEEKDAY(Date)”… Thanks ALL.

2

I’m not an authority on calculated fields in Studio, but I popped your question into Gemini and it suggested creating a calculated field using syntax like this:

CASE WHEN DayOfWeek = 1 THEN "Sunday" 

WHEN DayOfWeek = 2 THEN "Monday" 

WHEN DayOfWeek = 3 THEN "Tuesday" 

WHEN DayOfWeek = 4 THEN "Wednesday" 

WHEN DayOfWeek = 5 THEN "Thursday" 

WHEN DayOfWeek = 6 THEN "Friday" 

WHEN DayOfWeek = 7 THEN "Saturday" 

ELSE "Unknown" 

END

You would presumably have to change ‘DayOfWeek’ to whatever field is giving you those day numbers.

3

GavinW, Many thanks :folded_hands: I will try~