Unanswered

Summing up new similar value in column for bar graph

(0) Share

Report

Posted on by Azrisaparwan

Hi All,

I have encountered some issues in displaying the barchart figures that I want. I have looked up everywhere but cant find the right solution. Heres the issue :

This is my sharepoint list - Drupella Collection

I would like to create a page on powerapp to input this data. So I created this screen :

The location was not able to be selected, so I have on the AddColumns('Drupella Collection',"Site",Location.Value) on items of the graph. However, i wish to sum the location of drupella collected and time required per location.

So I tried this formula -

AddColumns(GroupBy('Drupella Collection',Location,"LocationData"),

"TotalDrupellaCollected",

Sum(LocationData,'Drupella Collected')

)

However it doesnt seem to run with some error. I would like to get the total drupella collected then add the time required as another series.

Wonderin if anyone is able to assist? Greatly appreciate it 🙂

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Azrisaparwan ,

You are just missing quotes around "Location"

AddColumns( GroupBy( 'Drupella Collection', "Location", "LocationData" ), "TotalDrupellaCollected", Sum( LocationData, 'Drupella Collected' ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Azrisaparwan 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,
Thanks for replying. Tried that, still having an error.
2 errors - expected a text,numeric, bolean, function grouby has invalid argument
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Azrisaparwan ,

What type of fields are Location and 'Drupella Collected' ? I also assume they are both fields in 'Drupella Collection'