You’re offline. This is a read only version of the page.
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!
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
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!
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
Assuming that your Active Types collection is created as such:
Share
Report
7
All responses (
Answers (
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.
