5 Replies Latest reply on Jul 13, 2017 5:00 PM by Zhouyi Zhang

    Calculate Median for the same 30-Day Period Each Year


      Hi everyone,


      Is there a way to create a filter or calculated field to calculate and compare (% difference) of medians for the same period of time over years?


      For example, let's say I wanted to calculate the median of sales made in November 1-7, 2016, but is there a way to also compare that median to the median of sales made in Nov 1-7 in 2015, 2014, and 2013? I don't have any dummy data available to me for a similar scenario (so sorry!), but please feel free to upload anything or ask for further clarification!


      Thank you!