topic Set analysis current month and year in App Development

Set analysis current month and year

Anonymous — Thu, 29 Sep 2016 09:01:01 GMT

Hi,

I want to have a set analysis in place which automatically filters a graph on the last month which is available in the data set.

I've read multiple topics about this and tried the suggested solutions but didn't get the desired result and haven't got a clue where the problem might lie. Therefore I attached a sample if someone wants to take a deeper look.

Also see the attached print screen for a visual overview of the desired result.

Thanks in advance for your time.

Re: Set analysis current month and year

sunny_talwar — Thu, 29 Sep 2016 15:53:20 GMT

Try these expression

This month:

Count({<Date = {"$(='>=' & Date(MonthStart(Max(Date))) & '<=' & Date(Max(Date)))"}>}Notification)

This year:

Count({<Date = {"$(='>=' & Date(YearStart(Max(Date))) & '<=' & Date(Max(Date)))"}>}Notification)

Re: Set analysis current month and year

Anonymous — Mon, 03 Oct 2016 06:44:41 GMT

Thanks again for the support Sunny!