Answered

Group Pie Chart Data

(0) Share

Report

Posted on by Well_K

Hello There,

I am having trouble trying to group a single column in my Pie chart correctly. I have a column that contains Windows OS systems in a type choice. The choices are "Windows 22, Windows 19, Windows 16, Windows 12". However, even if the response is the same it will not group them together into one. I understand I have to use GroupBy to make this happen but I do not understand how to do so.

The Pie chart is currently set up as Labels are "servertype" and the series is "versionnumber" (the series is set to versionnumber because it displays my data correctly, if there is a better way to do it please let me know.)

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Well_K you halfway there, GroupBy will group your OS's into a ServerType group then you need to count the instance in the column for each servertype.

Consider the following:

create 20 records and assign each one a windows os with a random version number

datasource = ClearCollect(colMyOs, ForAll(Sequence(20,12,2),{os: "Windows " & RandBetween(12,15) }))

Grouping the column will result in return uniquely the windows os version number as ServerType

GroupBy(colMyOs,"os", "ServerType")

Now the count how many times a servertype occurs

AddColumns(GroupBy(colMyOs,"os","ServerType"),"Total",CountRows('ServerType'))

Result

Hope it Helps,

R

Was this reply helpful? Yes No
Well_K 6 on at

Like (0)

Report
Copy link

Link copied!

This solution worked perfectly. However, what would I do if I do not want the inputs to be random?

Was this reply helpful? Yes No