Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to get count for last week( current week -1) i am using below expression but it is not working
can you please suggest on this
=count({$<RAG_STATUS={'Red'} , WEEK_DATE={$(=Date([WEEK_DATE]-7))}>} distinct[Release ID])
Try this:
=Count({$<RAG_STATUS={'Red'} , WEEK_DATE={"$(=Date(Max([WEEK_DATE])-7))"}>} Distinct [Release ID])
Also make sure that WEEK_DATE and the expression $(=Date(Max([WEEK_DATE])-7)) gives the same format.
Also do you need the count for a day or the whole week (7 days)?
For a week, try this may be:
=Count({$<RAG_STATUS={'Red'} , WEEK_DATE={"$(='>=' & Date(Max([WEEK_DATE])-14) & '<=' & Date(Max([WEEK_DATE])-7))"}>} Distinct [Release ID])