Set analysis current month and year

[Anonymous]

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.

[sunny_talwar · Accepted solution]

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)

[Anonymous]

Thanks again for the support Sunny!