Forum Discussion
Solved
SharePoint List Participation
Hello,
Im trying to calculate percentages of participation on a sharepoint list. I have two tables one with a list of people who are required to fill out a form on the sharepoint list and the other is the list its self.
Ex.
Table 1
| Name |
| Jim |
| Jane |
| Jerry |
Table 2.
| Name | Date | Question 1 |
| Jim | 5/1/2022 | yes |
| Jerry | 5/7/2022 | no |
Is there a way to make a measure or created column to calculate who participated.
Any help is appreaciated.
Thanks
Kincaid16 , hope the two tables are joined on Name
Divide(countrows(filter(Table2, Table2[Question]="yes")), counttows(Table1))
1 Reply
Kincaid16 , hope the two tables are joined on Name
Divide(countrows(filter(Table2, Table2[Question]="yes")), counttows(Table1))