I have been able to show top countries with most views for the given date range like below
I now would like to show how the total views has changed for those countries YoY. ie. if my selected dates are between 2015-01-01 to 2015-04-01 ( first quarter of 2015). I want to see the % change in the total views for those countries compared to the first quarter of 2014 ( one year before selected date range).
I know that you could use pivot_offset to compare YoY just based on the year like suggested in Using offset and pivot_offset in table calculations (3.18+) . but how to restrict so that my YoY comparison takes into account the values set in the date filter ? As far as I see we cannot access the values supplied in filter in the calculated fields? Please advice if there is a way of doing this.