web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps How to create pie char...

Power Apps - Building Power Apps

Answered

How to create pie chart from sharepoint list using groupby and add column

Like (0) Share

Report

Report

Posted on 16 Sep 2023 03:09:47 by lmcc

77

Hi,

Here is my sharepoint list.

I want to produce a pie chart that shows the total count of ACTIVE and INACTIVE in the status column of a sharepoint list.

I am unsure of the formula in the items property. I see some that use an ADD COLUMN and then a GROUPBY. Others do it the other way around.

Here is a screenshot of my sharepoint list and powerapp page.

Screenshot 2023-09-16 at 11.06.30.png

Screenshot 2023-09-16 at 11.08.10.png

Thank you in advance.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses Img

All responses (9)

Answers Img

Answers (1)

Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on 17 Sep 2023 at 12:13:57

Like (1)

Report
Re: How to create pie chart from sharepoint list using groupby and add column

hi @lmcc

here you go for a choice column. get the value from the complex type and group it.

AddColumns( GroupBy( AddColumns( OppsAgain, "yourNewStatus", Status.Value //Status is your choice column ), "yourNewStatus", "Statuses" ), "Totals", CountRows(Statuses) )

Result

Was this reply helpful? Yes No

Join the conversation