I’m looking to re-create my calculated field ("% change" - pictured below) as a measure - so that I can pull only that measure into a report, without pulling in the other fields that it is calculating from.
Here is the calculated field definition:
And here is the Lookml for my “Weeks since release” dimension, that I am pivoting on:
The challenge here is that there is no objective “last week” or “last month” range to partition this data on. The release date/sale start dates for various products are converted to integers, so that we can compare multiple products with different release dates against their week-on-week sales.