Forum Discussion
Help with metric
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,
Thank you philouduv
I will give that a try. The staff do have multiple curriculum that they have to complete. In my example I just displayed one curriculum. How would I apply this same principle to each Curriculum the staff are assigned.
Resolver IIIHey 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
datasource[Curriculum_ID == Earlier(datasource[Curriculum_ID])
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