I am trying to calculate blog posts per month with Google Analytics (GA) data. Google Analytics does not have "creation date" as an accessible field for pages, so my idea is to use the DATE (YearMonth) of the first visit to that page (dim_pagePath) as the creation date.
I thought this would be simple enough with the set analysis below but it is not working:
firstsortedvalue (YearMonth, dim_pagePath)
Any ideas are appreciated. I feel like this solution will be very useful to GA users at large who are using QlikSense with the new connector.
- dave