Forum Discussion
Help with metric
Hi All 123rew I have a training dataset that has just under 30,000 staff. In that data set it records a Curriculum that they have to follow and each curriculum has items that need to be st...
Hey Anonymous ,
In my solution, this work at the user_id level meaning that no matter which modules from whichever curriculum he has no complete it will be not compliant.
If youwant to be able to filter also at the module level you could addNbr_non_complete = COUNTX(Filter(datasource,datasource[USER_ID] == Earlier(datasource[USER_ID],
datasource[Curriculum_ID == Earlier(datasource[Curriculum_ID])&&datasource[compStatus] == "no"),datasource[compStatus])
Which will now give the count for each curriculum and User.
Best regards,
Hey Anonymous ,
In my solution, this work at the user_id level meaning that no matter which modules from whichever curriculum he has no complete it will be not compliant.
If youwant to be able to filter also at the module level you could add
Nbr_non_complete = COUNTX(
Filter(datasource,datasource[USER_ID] == Earlier(datasource[USER_ID],
datasource[Curriculum_ID == Earlier(datasource[Curriculum_ID])
datasource[Curriculum_ID == Earlier(datasource[Curriculum_ID])
&&
datasource[compStatus] == "no"),
datasource[compStatus])
Which will now give the count for each curriculum and User.
Best regards,
Which will now give the count for each curriculum and User.
Best regards,
Fantastic, I shall try this out later. Many thanks for your help