Profile Picture

Category "Labels" not displaying on Pie Chart

Posted By Steve Murray 9 Years Ago

Category "Labels" not displaying on Pie Chart

Author
Message
Steve Murray
Problem Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79

I am unable to pass the "Label" from a Category Data Grouping.  I am grouping by Category to distinguish costs:
Labels are "Less than 20 OMR", "Between 20 and 35 OMR" and "Greater than 35 OMR".  The logic for each of the Category groupings is working fine e.g. (=Fields!Total_Current_Charges<20) and displays the <value> and <percent>, but the Label I assign to each Category grouping does not get passed back to the chart.  Below is a screenshot of my configuration.
Thanks in advance!




Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: 2 Weeks Ago
Posts: 3,054, Visits: 4,015
You can’t pass category labels to the pie chart data labels like that. Also, you should not use the FORMAT function in the Data -> Value field.

You should consider using only <label> in the Data Groupings -> Values -> Data Labels -> Format field:
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/50c2b1b8-5a29-4729-a2aa-8ca7.png


Then, in the Data Groupings -> Values -> General -> Data -> Label field, use an expression like this:
=IF(Fields!Total_Current_Charges<20, "Less than 20 OMR",
IF(Fields!Total_Current_Charges>35, "Greater than 35 OMR", "Between 20 and 35 OMR")) + " - " +
FORMAT(SUM(Fields!GrossProfit.Value), "N0", "en-us") + " - " +
FORMAT((SUM(Fields!GrossProfit.Value)/SUM(Parent.Fields!GrossProfit.Value)), "P0", "en-us")

73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/872ad22b-5009-49e6-b3eb-62b5.png



Best Regards,
Nevron Support Team



Steve Murray
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/2f8fa153-2f6d-460a-9f2a-2f0b.png
Thanks for your prompt reply.  I made the recommended changes (screenshot of two Format statements); but now gives
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/91222ba0-a7d1-4172-84c4-5645.png
me an error.



Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: 2 Weeks Ago
Posts: 3,054, Visits: 4,015
This is because the expression returns an array. Can you send a snapshot of your data - the field of interest is the "Total_Current_Charges".

Since you have category grouping, you may need to update your expression with FIRST for the Total_Current_Charges e.g.:

=IF(FIRST(Fields!Total_Current_Charges)<20, "Less than 20 OMR",
IF(FIRST(Fields!Total_Current_Charges)>35, "Greater than 35 OMR", "Between 20 and 35 OMR")) + " - " +
FORMAT(SUM(Fields!GrossProfit.Value), "N0", "en-us") + " - " +
FORMAT((SUM(Fields!GrossProfit.Value)/SUM(Parent.Fields!GrossProfit.Value)), "P0", "en-us")

Best Regards,
Nevron Support Team



Steve Murray
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79
Thanks.... I tried your "First" suggestion.... no joy.  I have attached a snapshot and a copy of November's data (minus cell number, department, name.)  Appreciate your help.
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/68bc81a7-2c07-46b9-ac0a-80a8.png


Steve Murray
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/92a74520-af5e-42ef-88bc-c768.png
No joy yet.  Attached is the requested information.
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/d827c257-383e-486e-9d54-208b.png


Steve Murray
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/f0eabcc0-a23a-4cc6-b360-f0c2.png
Still no joy yet.... This seems to be a pretty straight forward chart; however, I am unable to "pass" the filter criteria labels to either the Legend or the pie chart Data Labels. 
Copy of chart w/o labels and logic.
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/27601ef9-2a2d-4a9f-8445-f29f.png


Steve Murray
Posted 8 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/44c53323-f2ca-4c43-aa25-a51d.png
I am still not able to pass labels to the Label: or the Legend.
Expression appears to work correctly as the percentages are correct. Below is the expression and a picture of the chart.
73% of original size (was 694x19) - Click to enlarge
https://www.nevron.com/forum/uploads/images/b0aa5025-0fe7-4515-b350-94da.png


Nevron Support
Posted 8 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: 2 Weeks Ago
Posts: 3,054, Visits: 4,015
Steve,
Can you send a snapshot of your data (in Excel spreadsheet). We are going to prepare an example for you.


Best Regards,
Nevron Support Team



Steve Murray
Posted 8 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 17, Visits: 79
Attached is Jan/Feb data from Sharepoint list.  When creating a chart, I set a filter for Iphone charges. 
Thanks for the helping hand(mind)!


Attachments
GSM Charges.xls (750 views, 352.00 KB)


Similar Topics


Reading This Topic

1 active, 1 guest, 0 members, 0 anonymous.
No members currently viewing this topic!