cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
darrenfloyd666
Post Prodigy
Post Prodigy

Pie Chart Beginner

Hi

 

I want to display a pie chart linking to a SP list on my Portal and I'm completely confused how to go about it.

 

I want it to point at a SP list which has a choice field called 'Status'. The choice field has six options and I want the pie chart to show how many items are New, Cancelled, Ready etc. So far I've found the guides to do this baffling. How do I point the pie Chart at the list and the field and what properties do I use? Any help appreciated.

PieChart.png

3 REPLIES 3
mdevaney
Super User
Super User

@darrenfloyd666 
First step is to create a new collection that groups together the data counted in a new collection called myTempData

 

ClearCollect(
    myTempData,
    AddColumns(your_datasource_name, "myStatus", "")
);

UpdateIf(myTempData, true, {myStatus=Status.Value});

ClearCollect(
    myChartData,
    DropColumns(
        AddColumns(
            GroupBy(your_datasource_name, "myStatus", "GroupedItems"),
        "Count Value",CountRows(GroupedItems)
        ),
    "GroupedItems"
    )
);

 

Then use the collection in Items property in your chart.

myTempData

 

Let me know if you need additional directions for using this in the chart.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Thanks @mdevaney I'll give that a go and get back to you! 

Morning @mdevaney I'm coming round to this again. I created a new Collection by clicking on Action on the ribbon and then Collect then on the drop down I've got Collection1 and the second drop down PieChart1.Selected. I can see it in my Data sources but can't seem to edit it? Can't find a straight answer to what's happening?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,416)