Grazia Palmisano Posted September 4, 2020 Share Posted September 4, 2020 Hi all, someone know how to format the sector value of a pie chart. the men Labels contain only the possibility to set the "sector percentage" but not the "sector value". Thank you Grazia Link to comment Share on other sites More sharing options...
Gaia Paolini Posted September 8, 2020 Share Posted September 8, 2020 isn't a sector a percentage in itself With the total size of the pie being the value and the sector a percentage of that value Link to comment Share on other sites More sharing options...
Grazia Palmisano Posted September 9, 2020 Author Share Posted September 9, 2020 No, maybe the thing is not clear. Spotfire allows to view, as label, the sector value and the sector percentage. The sector value is the size, which could also be a currency while the sector percentage is the percentage of the total. Currently it "seems" possible to format only the sector percentage and not the sector value. My request is to understand if there is a way to format the sector value as well.[/code] Thank you Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted September 9, 2020 Share Posted September 9, 2020 What version are you working with There is a 'Sector value' under Labels: Link to comment Share on other sites More sharing options...
Grazia Palmisano Posted September 15, 2020 Author Share Posted September 15, 2020 I'm working with version 10.3. The situation is similar to that of the image. Imagine you want to format the SECTOR VALUE to ONLY 1 decimals... How would you do it[/code] Link to comment Share on other sites More sharing options...
Fabian Duerr Posted September 15, 2020 Share Posted September 15, 2020 The value will have the format of your column where the value is from. In my version 7.x the format in the pie chart changes when I change the format of the column. So go to EDIT -> COLUMN PROPERTIES -> your table and column -> FORMATTING and change the decimals Link to comment Share on other sites More sharing options...
Grazia Palmisano Posted September 15, 2020 Author Share Posted September 15, 2020 I can't format a column because the size is a custom expression with an over expression on the Axis.Color. Link to comment Share on other sites More sharing options...
Fabian Duerr Posted September 15, 2020 Share Posted September 15, 2020 Understood. But what column are you aggregating Please try to format that column. Or wrap your entire expression with the INTEGER function: Integer(your custom expression). This works for me as well Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now