cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dwerling
New Member

Pie Chart from a User and Group Sharepoint List

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:

IDUser Date
1User101.01.2021
2User202.01.2021
3User1

03.01.2021

 

The Pie Chart should look like this then:

 

Screenshot 2021-02-18 162500.jpg

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?

1 ACCEPTED SOLUTION

Accepted Solutions
rubin_boer
Super User
Super User

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

 

rubin_boer_0-1613667294192.png

 

hope it helps

 

 

View solution in original post

1 REPLY 1
rubin_boer
Super User
Super User

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

 

rubin_boer_0-1613667294192.png

 

hope it helps

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,756)