Filtering KPI

[Beginner]

Hi,

I have a KPI I want to include, but I want my answer to be filtered to only include dates >90 days. What sort of expression would achieve this?

The data pulled for the KPI is all dates in the format 09 May 2017, if that help.

Thanks!

[Beginner]

In my last attachment Capture 11, I want to now have a KPI which shows the number of times under Days at Current Status that are greater than 90, so my answer in this case should be 3.

Something like: 

Count({<[PD.Days at Current Status] = {'>90'}>} [PD.Days at Current Status])

I'm not sure the >90 is the right way to put it?

[sunny_talwar · Accepted solution]

It is, the only thing I would change is to use double quotes instead of single quote

Count({<[PD.Days at Current Status] = {">90"}>} [PD.Days at Current Status])

[Beginner]

Perfect thanks!