How to set filter condition as 'most recent discovery - before - Last 20days'

Durgaprasad Jo1
Tera Contributor

‎08-09-2022 12:24 AM

Hello All,

While creating report, how to set filter condition as 'most recent discovery - before - Last 20days' in the snow report? We have option for 7days, 30days, 90days and 120days. How to set it for 20days?

image

0 Helpfuls
  • 550 Views
3 REPLIES 3

Community Alums
Not applicable

‎08-09-2022 12:37 AM

Hi,

Please don't create duplicate questions!!

I replied to your other question: https://community.servicenow.com/community?id=community_question&sys_id=04b5ea40dbd51910f77799ead396...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

0 Helpfuls

palanikumar
Giga Sage

‎08-10-2022 06:25 AM

Hi,

Use relative Operator

  1. Change Before to Relative
  2. Set the next dropdown as before
  3. Expand the next dropdown and choose
  4. First text box as 20
  5. Select Days in Next Radio
  6. Select ago as next radio

Refer below Screenshot

find_real_file.png

Thank you,
Palani
Preview file
34 KB
0 Helpfuls

Ramamoorthy N
Tera Contributor

‎08-10-2022 06:31 AM

This should be 'Relative' search, so choose 'relative' as the operator and 'before' as the interval and '20 + Days + ago' as the duration. That should solve it.

0 Helpfuls