Broken Key Metric

Stefano_Mazzocca

Hello,

I'm trying to count all User Person Type set as "Somministrato" and I made de below Key Metric.

As you can see I'm filtering by month 2024/06 and the assignment start/end date of these persons are included in this month.

Person Type is "Somministrato" as expected but my key metric calculates the result only for the last row, which has Assignment Start Date in June. In fact I find out that this is the logic: if the Assignment Start Date falls in the filtered month it gets calculated (with 1 or 0), otherwise the results is null, like in the fist 3 rows (green bracket with question mark).

Can anyone suggest a way to calculate the results if the assignment validity embrace the filtered month, avoiding making a rule that only considers the Assignment Start Date?

Thank you

JohnW-Oracle

Hi @Stefano_Mazzocca,

What happens if you replace:

when User Person Type = 'Somministrato'

with

when User Person Type like '%Somm%'

Also test the 'User Person Type' part of the phase by recreating the Key Metric from scratch.

This could be a metadata issue and you may need to log a SR to let us look into it in more detail.

Regards,

John