Hello,
I create a collection from excel Datasource with the formula: ClearCollect(GroupbyConcept; GroupBy(Tabla1; "Concepto"; "total"))
But I don't know how to Sum the prices by concept, por example:
Autopista: 64 €
Dieta: 117,54
Excel DataSource:
Solved! Go to Solution.
Hi @resteve, please try this. (Please note that you probably have to use ; instead of ,)
AddColumns(GroupByConcept, "SumByConcept", Sum(total, Precio))
You could even do this
ClearCollect(GroupbyConcept, AddColumns(GroupBy(Tabla1, "Concepto", "total"), "SumByConcept", Sum(total, Precio)))
Please let me know how you get on.
Hi @resteve
I have found the solution. The key is in your third screenshot. You need to change the Items property from PieChart1.SeriesLabels to GroupByConcept and then the Value to Concepto.
Please let me know how you get on.
Hi @resteve, please try this. (Please note that you probably have to use ; instead of ,)
AddColumns(GroupByConcept, "SumByConcept", Sum(total, Precio))
You could even do this
ClearCollect(GroupbyConcept, AddColumns(GroupBy(Tabla1, "Concepto", "total"), "SumByConcept", Sum(total, Precio)))
Please let me know how you get on.
Perfect, it works!
Then I need two formulas and two different buttons?
ClearCollect(GroupbyConcept; GroupBy(Tabla1; "Concepto"; "total"))
ClearCollect(GroupbyConcept;AddColumns(GroupBy(Tabla1;"Concepto";"total");"SumByConcept"; Sum(total; Precio)))
I add a chart but the legend is the same than chart, Can I change to concepto?. Thank you!
Sorry, first paragraph or question of the previous post is already solved, I can have several actions in one formula with PowerApps chaining operator: ;; (double semi-colon) but only it's necessary the second action. Thank you!
Hi,
I attach some screenshots because I've changed the labels and series but it doesn't work.
Hi @resteve
I have found the solution. The key is in your third screenshot. You need to change the Items property from PieChart1.SeriesLabels to GroupByConcept and then the Value to Concepto.
Please let me know how you get on.
Done . Thank you so much!. This community is very helpful!
User | Count |
---|---|
262 | |
110 | |
92 | |
54 | |
43 |