Creating dynamic filters based on Current date Flexera Analytics (COGNOS)

[SyedByhaqiEMT]

FNMS version 2022 R1 and IBM Cognos Analytics 11.0.13 (LTS).

Hi, 

We need to create Application Utilization report based on Last Use Date. e.g. Apps not used in last 120 days, 60 days, 30 days.

I understand this needs a filter/ query which checks current date and then calculates utilization based on last 120 days, 60 days, 30 days.

How to achieve this in Flexera Analytics please.

Thank you in advance.

[JohnSorensenDK]

@SyedByhaqiEMT 

For very specific Cognos Analytics questions you may be better off searching the Internet or IBM documentation and community. I quickly searched and found a found many hits using keywords 'cognos analytics 11.0 filter on number of days between two dates' on the Internet. I would encourage forum members with experience in doing this with FNMS to chime in.

Thanks,