title: How do I create a "Users by time of day" heatmap in Google Data Studio?
body: <p>I want to create a heatmap in Google Datastudio similar to the "Users by time of day" heatmap in Google Analytics.</p>
  
  <p>This is how it looks in Google Analytics.
  <a href="https://i.stack.imgur.com/Bo7tV.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/Bo7tV.jpg" alt="enter image description here"></a></p>
  
  <p>THE FIRST PROBLEM is that when I have my columns as the days of the week, it  sorts on ascending/descending value alphabetically, NOT Sunday, Monday, Tuesday, etc.</p>
  
  <p>THE SECOND PROBLEM is that I can't actually get the heatmap coloring.</p>
  
  <p>THE THIRD (not a problem, but a preference)...is there a way to group every 2 hours like Google Analytics does?</p>
  
  <p>I am creating this using the PIVOT TABLE chart. Should I be using a different chart? Any other ideas?</p>