Pie Chart: GroupBy

[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!

[Brank]

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,

[CarlosFigueira]

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.

[LMP]

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

[LMP]

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!

[LMP]

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-Col...