Question on Simple set analysis.

[Anonymous]

Hi

The result is not coming for below set analysis.

count({<[Date error/issue discovered]={">=$(MonthStart(max([Date error/issue discovered]) <=(today())"} >}[Type of error/issue])

[sunny_talwar]

Try this:

Count({<[Date error/issue discovered]={">=$(=Date(MonthStart(Max([Date error/issue discovered])), 'DateFieldFormatHere')<=$(=Date(Today(), 'DateFieldFormatHere'))"} >}[Type of error/issue])

[subathra]

count({<[Date error/issue discovered]={'>=$(=MonthStart(max([Date error/issue discovered]))) <=$(=(today()))'} >}

[Type of error/issue])

[crusader_]

Hi,

First of all check Date format of [Date error/issue discovered] field and then turn everything to single view like stalwar1‌ mentioned previously or turn everything to numbers:

Count({<[Date error/issue discovered]={">=$(=Floor(MonthStart(Max([Date error/issue discovered]))))<=$(=Floor(Today()))"} >}[Type of error/issue])

Hope this helps.

Regards,

Andrei