topic Re: Count number by Date - Current date to the prior quarter in App Development

Count number by Date - Current date to the prior quarter

jerryr125 — Fri, 02 Apr 2021 08:48:13 GMT

Hi - I have the following formula in a master measure:

Count({<[REQUESTDATE]={'>=$(=QuarterStart(Max(REQUESTDATE), -1))<=$(=Date(Max(REQUESTDATE)))'}>} [REQUESTDATE] )

Basically, I would like a count of requests for each Request for dates from the max REQUESTDATE (say today) to the first date of the quarter (10/1/2020).

The formula gives me an 'OK' but when I display in a chart it does not work. Any thoughts ?

Thanks - Jerry

Re: Count number by Date - Current date to the prior quarter

GaryGiles — Mon, 25 Jan 2021 18:29:18 GMT

I think you need to use " instead of ' in your set analysis:

Count({<[REQUESTDATE]={">=$(=QuarterStart(Max(REQUESTDATE), -1))<=$(=Date(Max(REQUESTDATE)))"}>} [REQUESTDATE] )

Re: Count number by Date - Current date to the prior quarter

jerryr125 — Tue, 26 Jan 2021 11:25:37 GMT

Thank you - that was the solution - appreciate it ! Jerry