Answered

charts - top 10 function

(0) Share

Report

Posted on by renedd78

Hello,
Unfortunately, I'm not a specialist when it comes to programming power apps. 😞
Currently I would like to integrate a chart that gets the data from a list.
When I link this as a chart, it shows me all the colour values as a separate segment. However, I would like to group all the same values in column 1 as shown in the picture or count them and display the frequency.
Ideally, this should be filterable over a period of time.

Thanks a lot

René

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @renedd78,

You could add a couple of columns to your collection to use for group by and countrows functions.

Below is an example of that approach.

In this example I used a SharePoint list which is called ColoursCounting. I have added a column called ColourColumn (which uses the Title value like in your setup).

AddColumns(GroupBy(AddColumns(ColoursCounting, "ColourColumn", Title), "ColourColumn","Count"), "Number of Items", CountRows(Count))

Was this reply helpful? Yes No
renedd78 18 on at

Like (1)

Report
Copy link

Link copied!

Thanks Expiscornovus.It works perfect.

br
renedd78

Was this reply helpful? Yes No