Forum Discussion
Helper IIIDAX help to count 100% completion
I have a matrix table which shows the training completion rate per region and employee.
I have about 8000 employees, each assigned multiple courses to complete.
As you can see from the screenshot, user Kelly has 14 courses assigned to them, and 0% are complete.
I'd like to add a column which counts Total users who have an overall completion rate of 100%. So all courses they have assigned to them show complete
Thanks
pls see the attachment below. It will be better if you can provide some dummy data and expected output
8 Replies
ryan_mayuSuper User
could you pls provide the sample data?
m_roussakisI can't really share the data. However its quite a simple layout.
I have:
Column A = User ID
Column B = Course Title
Column C = Course Completion status
Column D = Location
So for example a user with ID 12345 could have 10 courses showing in column B. Of these, 8 are complete.
I need to know which users have 100% of the assigned courses showing complete.
And I don't need to know how to calculate the percentage of completed courses....that I already have. I need to be able to display the COUNT of 100% complete users per location as a value in a matrix table.
Thanks
- ryan_mayu
pls see the attachment below. It will be better if you can provide some dummy data and expected output