Finding the "Growth Rate" of a metric in Beastmode
We are currently building a dashboard where looking at change over time is critical - ideally how we'd like to accomplish this is by measuring the growth rate, or change in the metrics over the period set by the analyzer.
Is it possible to calculate this in a beastmode while still retaining the ability to change the filters and time frames observed?
For example if the page analyzer was set to Q1 2017 and we were measuring weekly sales we'd want to see:
(last week of Q1 - first week of Q1)/first week of Q1
Sure we could calculate these in an ETL before it gets to the dataset but then we would lose our ability to determine what time period we want to look at, what granularity we want to see, and what other filters we can apply.