Dashboard report Number of Demands in screening for > 30 days in Draft or Needs More Information sta

[Community Alums]

Hello Everyone, I have a requirement that shows the Number of Demands in screening for > 30 days (in Draft or Needs More Information states). So for the only thing I've found is to create a relative query on updated greater than 30 days ago. I can see a problem where if they update anything else, make a change that's not on updated they it's going break my requirements. any help would be much appreciated. 

[AndersBGS]

Hi @Community Alums ,

according to your question, I’m in doubt if you’re looking for the demands in screening phase above 30 days, or the demands in screening not updated last 30 days?

which one is it?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Community Alums · Accepted solution]

I thought I would reply back to this with the solution I ended up with just in case. I ended up creating a custom field and a business rule that records the timestamp anytime state changes to one of the choices above. I then created a relative filter on that field to go grab all my demands that have been in that state for longer than 30 days. Reading back I can see how I might have worded my question a little confusing but I wanted to thank everyone who offered to help.