Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
The below expression is not working because of timestamp issue's please find the dummy data and correct me
=count({$<State={'Resolved','Closed'},Opened={">=$(=text(date(min(Opened))))<=$(=text(date(max(Opened))))"}>}Number)
Try this:
=count({$<State={'Resolved','Closed'},Opened={">=$(=Timestamp(date(min( Opened))))<=$(=Timestamp(date(max( Opened))))"}>}Number)