19 Replies Latest reply: Jul 18, 2017 2:33 AM by kumarsuresh lulu RSS

    Rolling 30 days avg

    kumarsuresh lulu

      Hi,

      I have filters Date, Month, Year.

      Taken date in X-axis and written the expression for rolling 30 days.

      when I am selecting date, it is displaying that particular date only not previous 30 day.

       

      please find the expression

      Avg({<Day={">=$(=Date(max(Day)-30,'MM/DD/YYYY'))<=$(=Date(max(Day),'MM/DD/YYYY'))"}>}AssetRank)

       

       

      could you suggest any mistakes I have done in this expression.