Pie Chart from a User and Group Sharepoint List

[Dwerling]

Hello,

I searched a lot and couldn't find a solution to my problem, so I have to create a new thread.

I have a Sharepoint list with several dropdowns and one Column where you can choose a Office365 User (Type: User or Group).

I now want a Pie Chart that shows how often a User is shown in the list.

List for Example:

ID	User	Date
1	User1	01.01.2021
2	User2	02.01.2021
3	User1	03.01.2021

The Pie Chart should look like this then:

 

I think the problem is, that the Column User is a "User or Group" field but I think it has to be possible somehow.

Can someone help me out with that?

[rubin_boer · Accepted solution]

hi @Dwerling group the data by the user column , AddColumns(GroupBy(_Dwerling,"User","Users"),"Totals",CountRows(Users))

hope it helps