Piechart with Dropdown

(0) Share

Report

Posted on by faithdwn

Hi,

I'm having some trouble getting a formula to work for me to display a piechart the way i want.

I have a dropdown list whose OnSelect property creates a collection for me: ClearCollect(ProgressTracker, ShowColumns('Tool & Die',"TotalHours","Hours_x002d_EDM","FullName"))

I then have a piechart where i want it to display collection items based on the dropdown selected name along with summarizing the collections values - Total hours vs Required hours. The two formulas that work fine independently but i want to combine are:

If(Dropdown1_1.Selected.Value = "Carol Barry",ProgressTracker,Dropdown1_1.Selected.Value="Darry De Guzman",ProgressTracker)

AND

AddColumns(GroupBy(ProgressTracker,"TotalHours","Hours_x002d_EDM"),"Count",Sum(Hours_x002d_EDM,TotalHours))

I've tried so many different things but it will not work such as a comma, semi colon, ||, etc. Please help me out.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@faithdwn

I made an attempt at putting together the two functions here. Let me know if it works.

DropColumns( AddColumns( GroupBy( Filter(ProgressTracker, EmployeeName=Dropdown1_1.Selected.Value), "EmployeeName","TotalHours" ), "Count", Sum(TotalHours,Hours_x002d_EDM) ), "TotalHours" )

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

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @faithdwn ,

Do you want to display pie chart based on the selection of drop down?

Could you show me

1)the fields data type in the collection?

2)data examples of your collection?

Since I do not quite know what the data like in your collection, so I could not directly show you the detailed formula.

Are you sure the first formula?

If(Dropdown1_1.Selected.Value = "Carol Barry",ProgressTracker,Dropdown1_1.Selected.Value="Darry De Guzman",ProgressTracker)

The two results are the same. So please correct this.

Best regards,

Was this reply helpful? Yes No
faithdwn 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft and @rgruian

Thanks for your responses!!

Yes - I have a sp list that collects each employees info. I want the piechart to display the individuals required hours vs accumulated hours based on the selected drop down. Drop down includes all their names.
The collection includes the full name, required hours, and accumulated hours.

The formula provided kind of works but does not distinguish the sum of Total hours vs sum
accumulated hours.
DropColumns(AddColumns(GroupBy(Filter(ProgressTracker,"Carol Barry"=Dropdown1_1.Selected.Value||"Darryl De Guzman"=Dropdown1_1.Selected.Value),"Hours_x002d_EDM","TotalHours"),"Count",Sum(TotalHours,Hours_x002d_EDM)),"TotalHours")

Should the legend have the same formula as the chart?

Photo below:

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @faithdwn ,

Could you tell me

1)the fieldnames in details of your data source and their data type?

2) the logic that you want to calculate?

I'm not sure how do you want to calculate the sum of Total hours and the sum accumulated hours.

Best regards,

Was this reply helpful? Yes No