cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Pie Chart: GroupBy

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!

5 REPLIES 5
Advocate III
Advocate III

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,

Power Apps
Power Apps

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.

Regular Visitor

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

 

 

 

Regular Visitor

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.

 Chart1.png

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

 

 

We also tried the below formula...

Sum.png

 

Any help is appreciated. Thanks in advance!

 

Regular Visitor

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

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,852)