Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using a bookmark (BM08) where this expression has been entered into a search box:
=dev_finish_date>now()-3
Then I have a gauge chart that is using this expression:
=count({BM08} request_id)
The problem is that it pulls the correct figures for a while but as time goes by the number doesn't change. Is there an expression I can use that's dynamic?
Much better. This expression is working for now:
Count({$<dev_finish_date={">$(=Timestamp(now()-3))"}>} request_id)
It's only a tad off now, and unless you have any other suggestions for the expression I'll have to wait and see if the server refresh rate is to blame for the discrpeancy.
EDIT:
I think it may be a server refresh issue, so this might be the most accurate they'll get. Thank you for all your time.
Message was edited by: bikeking8