This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Order by day of week on pivot table heatmap

Posted on 07-08-2024 12:27 PM
PBS-LM
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have a pivot table heat map in Looker Studio for video streams by day of week name and hour.  I have the rows ordered by hour, but I can't get the columns to order correctly by day of week name.  Any suggestions?

PBSLM_0-1720466714493.png

 

0 1 406
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
ArkadyZagdan
Silver 3
Silver 3
Reply posted on --/--/---- --:-- AM

@PBS-LM 
Odd. You can try to use case formula renaming your days of week into something preceded with numbers or alphhabet letters.

1. Monday
2. Tuesday
7. Sunday

When you order it ascendingn it should do the work

0 Likes