topic Re: Count from the month before selection in App Development

Count from the month before selection

Anonymous — Wed, 22 Dec 2021 15:42:54 GMT

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)

Re: Count from the month before selection

shraddha_g — Mon, 13 Nov 2017 12:21:42 GMT

Try

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

Re: Count from the month before selection

Anonymous — Mon, 13 Nov 2017 12:23:30 GMT

Yes I did try combining them into a single set but it returns '0' for each value which i know not to be the case.

Re: Count from the month before selection

shraddha_g — Mon, 13 Nov 2017 12:25:36 GMT

If possible share sample app n sample data