Set Analysis Not working

[noman212]

hi Friends,

i have a speedo meter which display record on current day basis it was working fine in project but when i modified the project and add 1 field its shows 0 counts inspite of 251.

set analysis used in speedometer.

=Count ({<CalendarDate={'$(=max(CalendarDate))'} >} proposal)

[MK_QSL · Accepted solution]

May be because the Max(CalendarDate) have 0 data...

Try

Create a Straight Table with

Dimension

CalendarDate

Expression

COUNT(proposal)

Sort By CalendarDate descending order and go to presentation tab and untick suppress zero values..

let me know what is the value coming for max CalendarDate

If it is Zero, you can try below

=Count({<CalendarDate = {'$(=Date(Max(CalendarDate)-1))'}>}proposal)

[noman212]

Thanks alot for your solution , when i put Date before MAX in set expression its work fien but i dnt know why it happened...