Answered

groupby item and get a count

(0) Share

Report

Posted on by gstlouis

I am trying to learn working with charts. I have a list that holds a category with other stuff. The categories are something like ID, DEF, ETC. These are Choices and I know GroupBy does not like choices.

Several items in this list will be in their respective categories. I want to do a chart that will show me with a count of how many items are in ID or DEF or ETC whatever.

I can seem to get it right. I tried this for instance
GroupBy(AddColumns('TOPICS',"phases",Text(phase.Value),"count",Filter('TOPICS',"phase" = "ThisRecord.phase.Value")),"phases","count")

I get this set (forgot to attach). I can only assume that column "count" is giving [Table] because of the results of Filter, but if I do CountRows in there it does not like that either saying not supported for this connector. So I must be approaching this wrong.

Any advice would be appreciated.

Screen Shot 2024-01-03 at 11.36.23 AM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @gstlouis ,

Please try:

AddColumns('GroupBy(AddColumns('TOPICS',"phases",Text(phase.Value)),"phases","NewGroup"),"count",CountRows(NewGroup))

Best Regards,

Bof

Was this reply helpful? Yes No
gstlouis on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft
You are brilliant. This worked and plugged into pie charts perfectly providing the count ratio of all the categories.
Question, I can see the results from the syntax in power apps under the Fx box like this. The group_name NewGroup shows its a [Table]. Assuming its the dataset, is this accessible?

It seems rather difficult to get a count beside the category titles. I have tried experimenting with concatenating with addcolumns but it turned into a nightmare. If you have a better approach please share.

Was this reply helpful? Yes No