You’re offline. This is a read only version of the page.
Hi, I want to add the percentage of report status column. Please see the below attached Pie chart and table screenshots.
Kindly provide me the solution asap.
Thanks in advance.
But one of the status is showing 125%. If we calculate all the status values, the total is more than 100%.
Hi @Palans12 ,
Am glad that the Percentage code worked. Now you wanna show the status name on the legend.
Perform the following steps:
As I see you are using Percentage for both Label and Series on your PieChart1.
Keep -
Label as = Name of your status/4Itb report status
Series as = Percantage
Now for the Legend Items Property:
PieChart1.SeriesLabels
If you liked my suggestion. Please like and resolve. Happy to help.
Thanks for the help.
We tried the code. The 4RT.value produces an error. See the attached file for further information.
Thanks for your help.
Percentage is working fine. But one of the status is showing 125%. If we calculate all the status values, the total is more than 100%.
Use this code :
AddColumns(AddColumns(GroupBy(AddColumns(Table1,"name1",'4itb report status'),"name1","4itb report status"),"Number",CountRows('4itb report status')),"Percentage",Text(Value(Number / 'Total Status Count') * 100,"[$-en-US]#.00%"))
If there are total 4 different status, then replace 'Total Status Count' by 4
Hi @Palans12 ,
Could you please share the pic chart code for better understanding?
Share
Report
All responses (
Answers (
ForAll(
Distinct(
Table1,
'4itb Report Status'
) As 4RT,
{
Title: 4RT.Value,
Percentage:
(
CountRows(
Filter(
Table1,
'4itb Report Status' = 4RT.Value
)
) / CountRows(Table1)
) * 100
}
)
This should return a table containing records formatted as: {Value, Percentage}.
I had trouble loading your table image, but it looks like your Pie Chart is based off of the '4itb Report Status' column, so I used that here.
Hope this helps!
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
