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.
Year/ month | Page title | Views
Month 1 | Page A | View 1
Month 1 | Page B | View 2
What happens when you pivot on Year/Month? Shouldn't you be able to sort on views then?