Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Try this:
Count({<[Date error/issue discovered]={">=$(=Date(MonthStart(Max([Date error/issue discovered])), 'DateFieldFormatHere')<=$(=Date(Today(), 'DateFieldFormatHere'))"} >}[Type of error/issue])
count({<[Date error/issue discovered]={'>=$(=MonthStart(max([Date error/issue discovered]))) <=$(=(today()))'} >}
[Type of error/issue])
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