How to write expression for below requirement?

[Sra1bandi]

Hi Team,

Requests are created one by one by the users, each request will have different phases like shown below.

RequestNo      Phase                            created_date

1                      open                              01-01-2024

1                      initial review                  03-02-2024

1                      evaluation                     15-04-2024

Note:- Phases are in above mentioned order.

User need to compare request created i.e Request 1 in  phase "initial review"      date    "03-02-2024" in Feb month and next phase moved to April month.

Now user need KPI i.e when they select Feb 2024 & phase="initial review"  count=1 and in second KPI when they filter with March 2024 & phase="evaluation" count=0 but when they filter with April 2024 & phase="evaluation" it's need to show count=1.

Regards,

Sravan.

[MK_QSL]

What it the answer you are getting when you write for both KPIs?

COUNT({<Phase = {'initial review'}>}Distinct ReuqestNo)

COUNT({<Phase = {'evaluation'}>}Distinct ReuqestNo)