topic Calculation within P() in App Development

Calculation within P()

Anonymous — Mon, 22 Oct 2018 09:55:11 GMT

I've got a data island which I'm using as a date selection tool. I've got a set analysis which returns the average CSAT score for the selected month;

avg({<Date_Year_Month=P(Reporting_Month)>} CSAT)

Date_Year_Month is in the master calendar and Reporting_Month is the un-linked data table. How would I combine =addmonths(Reporting_Month,-1) with the P function to show me the average CSAT for the previous month? I thought something like

avg({<Date_Year_Month=P($(=AddMonths(Reporting_Month,-1)))>} CSAT)

but that doesn't do it. I've tried a handful of others and also referred to the help guide but without any luck.

Re: Calculation within P()

Anonymous — Mon, 22 Oct 2018 10:11:16 GMT

I also have a unique id number for each CSAT which I thought it might be possible to use like;

avg({$<feedback_id =P({1<Date_Year_Month={$(=addmonths(Reporting_Month,-1))}>}feedback_id)>}CSAT)

But still no luck

Re: Calculation within P()

Anonymous — Mon, 22 Oct 2018 10:59:11 GMT

Answer was;

avg({<feedback_id=P({<Date_Year_Month={'$(=Date(AddMonths(Reporting_Month,-1), 'YYYY-MMM'))'}>} feedback_id)>} CSAT)

If anyone can see how to improve that expression please let me know