3 Replies Latest reply: Nov 13, 2017 7:25 AM by Shraddha Gajare RSS

    Count from the month before selection

    Josh Pinfold

      Trying to show the volume of feedback received in the month previous to the one that is selected via a filter pane. Eg if September '17 is selected I would like the volume of feedback from August '17. Currently the following is not working;

       

      Count({1<Feedback_Day_Start = {">=$(=monthstart(addmonths(max(Feedback_Day_Start), -1)))"},

      Feedback_Day_Start = {"<=$(=monthend(addmonths(max(Feedback_Day_Start), -1)))"}>} FeedbackFlag)