7 Replies Latest reply: Nov 20, 2017 2:13 PM by Sunny Talwar RSS

    Excluding Outliers from Avg Calculations at the dimension level

    Jorge Fernandes

      All,

       

      I need to plot monthly average trend. Each month behaves differently hence the need to exclude outliers at the month level. This calculation needs to be dynamic if I need to look at the trend by a certain category (the outliers need to be recalculated at the category level by each month)

       

      I have attached a sample QVF.