Populating a Pie Chart using value ranges

(0) Share

Report

Posted on by scottypotty4x4

Hello all - I have a local Collection (colROSurveyData) that has a column Mileage. I am trying to create a Pie Chart that displays the mileages in ranges (0-15,000 | 15,001 to 30,000 | 30,001 to 45,000 | 45,001 to 60,000 | 60,001 to 75,000 | 75,001 to 90,000 | 90,001 and up).

How do I shape the data to create a counted table for ranges of numbers in the Items property of my Series and the Labels be the ranges listed above?

Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @scottypotty4x4 ,

I've made a test for your reference:

I assume there is a table

ClearCollect(YourTable,{Mileage:24157},{Mileage:61474},{Mileage:78451},{Mileage:10147},{Mileage:97414});

You could set the pie chart's items property to:

ShowColumns(AddColumns(GroupBy( AddColumns( YourTable, LabelColumn, If( Mileage<=15000,"0-15,000", Mileage<=30000,"15,001 to 30,000", Mileage<=45000,"30,001 to 45,000", Mileage<=60000,"45,001 to 60,000", Mileage<=75000,"60,001 to 75,000", Mileage<=90000,"75,001 to 90,000", "90,001 and up" ) ),LabelColumn,NewGroup),Count,CountRows(YourTable)),LabelColumn,Count)

Best Regards,

Bof

Was this reply helpful? Yes No
scottypotty4x4 53 on at

Like (0)

Report

PERFECT! Thank you

Was this reply helpful? Yes No