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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,131)