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
