Pie Chart: GroupBy

(0) Share

Report

Posted on by LMP

Hi Everyone, We are in need of help with grouping in Pie Chart.

Our current pie chart

Our target is

How are we going to achieve this?

Label: Type

Series: RecordId

We have been playing with GroupBy and ClearCollect but no luck, we are having a hard time making our code work.

We just started using PowerApps today and still familiarizing ourselves on constructing formulas. Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Brank 149 on at

Like (0)

Report
Copy link

Link copied!

For help you I would like to know what do you have in the property "Items" of the PieChart, if it is a context variable, how do you create it?

Regards,

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
Assuming that your Active Types collection is created as such:
ClearCollect(coll1, { type: "OperatorError", value: 1 }, { type: "Inspection", value: 1 }, { type: "Inspection", value: 1 }, { type: "Inspection", value: 1 }, { type: "Infraction", value: 1 }, { type: "Maintenance", value: 1 }, { type: "OnBoarding", value: 1 }, { type: "Infraction", value: 1 }, { type: "Inspection", value: 1 }, { type: "OperatorError", value: 1 })
Then you can group by the type using the formula below:
ClearCollect(coll2, AddColumns( GroupBy(coll1, "type", "bytype"), "sumtype", Sum(bytype, value)))
When you add a pie chart using 'coll2' in the Items property, you should get the chart that you described. The formula above first groups all the items in the original collection by the 'type' column, then adds a new column that sums the 'value' property of each group.

Was this reply helpful? Yes No
LMP 7 on at

Like (0)

Report
Copy link

Link copied!
Hi Brank and Carlos,

We are using a Common Data Service as the source of the records. Below are the data on the excel file.

CASEID ARRIVALDATE CATEGORY CLOSEDATE CURRENTCONTACT_CONTACTID CUSTOMERSATISFACTIONCODE ORIGINCODE SEVERITY SOLUTIONTYPE STATUS WORKITEMTYPE_ CASE001 2016-03-15 19:00:00.0000000 Question 2016-04-01 00:00:00.0000000 CON001 VerySatisfied Phone Normal SolvedByCustomer Active Inspection CASE002 2016-02-02 00:00:00.0000000 Problem 2016-04-02 00:00:00.0000000 CON002 VerySatisfied Email Normal SolvedByCustomer Resolved Inspection CASE003 2016-02-04 00:00:00.0000000 Question 2016-04-04 00:00:00.0000000 CON003 Neutral Phone High SolvedByCustomer Resolved Infraction CASE004 2016-02-05 00:00:00.0000000 Problem 2016-04-05 00:00:00.0000000 CON004 VerySatisfied Email Normal SolvedByCustomer Active Maintenance CASE005 2016-02-06 00:00:00.0000000 Request 2016-04-06 00:00:00.0000000 CON005 VerySatisfied Web Normal SolvedByCustomer Active OnBoarding CASE006 2016-02-07 00:00:00.0000000 Question 2016-04-07 00:00:00.0000000 CON006 Neutral Phone High SolvedByCustomer Resolved Infraction CASE007 2016-02-08 00:00:00.0000000 Problem 2016-04-08 00:00:00.0000000 CON007 VerySatisfied Email Normal SolvedByCustomer Active Inspection CASE008 2016-02-09 00:00:00.0000000 Request 2016-04-09 00:00:00.0000000 CON008 Neutral Web High SolvedByCustomer Active OperatorError CASE013 2016-03-05 00:00:00.0000000 Problem 1899-12-31 20:00:00.0000000 CON001 VerySatisfied Web High SolvedByCustomer Active OperatorError CASE016 2016-03-15 17:00:00.0000000 Problem 1899-12-31 20:00:00.0000000 CON001 VerySatisfied Web Normal SolvedByCustomer Active Inspection

Was this reply helpful? Yes No
LMP 7 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

We have added a new column with type of int and populated values to it. We then used this value field but it is diplaying the same sizes for each slices.

AddColumns(GroupBy(Case, "WorkItemType_", "Value_"),"Count", Count(Case.Value_))

We also tried the below formula...

Any help is appreciated. Thanks in advance!

Was this reply helpful? Yes No
LMP 7 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

We have achieved our goal. We followed the post by hpkeong here: https://powerusers.microsoft.com/t5/PowerApps-Forum/Help-with-a-formula-to-extract-data-from-one-Collection-into/m-p/19810#M8669

Was this reply helpful? Yes No