How to create a table for multiple URLs with views over year/month period?

Looker Q&A Looker
1

Hi,

I’d like to create a table for multiple URLs and their views across a year/month period. The goal is to see how content performs over time, sorted by the number of views.

Page title | Month 1 | Month 2 | Month 3 |
Page A | View 1 | View 2 | View 3
Page B | View 1 | View 2 | View 3

Currently, I have the table set up with the following settings. The issue is that I cannot sort views, only by month.

  • Dimensions: Year/ month and Page title
  • Metric: Views

Year/ month | Page title | Views
Month 1 | Page A | View 1
Month 1 | Page B | View 2

2

What happens when you pivot on Year/Month? Shouldn’t you be able to sort on views then?