count expression is not working

[gopinadhpindra]

Hi team,

The below expression is not working because of timestamp issue's  please find the dummy data and correct me

Spoiler

=count({$<State={'Resolved','Closed'},Opened={">=$(=text(date(min(Opened))))<=$(=text(date(max(Opened))))"}>}Number)

[Frank_Hartmann]

Try this:

=count({$<State={'Resolved','Closed'},Opened={">=$(=Timestamp(date(min( Opened))))<=$(=Timestamp(date(max( Opened))))"}>}Number)