cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Colinu Regular Visitor
Regular Visitor

Re: Pie Chart

hi thanks

 

i can share it but i cant see how i attach it to the post on here?

 

quentin_vigne Senior Member
Senior Member

Re: Pie Chart

@Colinu

 

Just copy the table and paste it here

 

- Quentin

Colinu Regular Visitor
Regular Visitor

Re: Pie Chart

StringCable IDSizeTowerPre-term TestingPreparationsTerminationsPost term testingPartial string testing
 2 115.0020.0015.005.00100.00
 AB01 - AB05 AB017.50 15.005.00100.00
 AB06 - AB02 AB027.50 15.005.00100.00
 AB02 - AB01 AB025.00 15.005.00100.00
 AB08 - AB03 AB035.00 15.005.00100.00
 AB03 - AB04 AB035.00 15.005.00100.00
 AB03 - AB04 AB045.00 15.005.00100.00
 AB01 - AB05 AB05  15.005.00100.00
 AB11 - AB06 AB06  15.005.00 
 AB06 - AB02 AB06  15.005.00 
 AB12 - AB07 AB07  15.00  
 AB07 - AB08 AB07  15.00  
 AB07 - AB08 AB08  15.00  
 AB08 - AB03 AB08  15.00  
quentin_vigne Senior Member
Senior Member

Re: Pie Chart

@Colinu

 

Your string and size column are empty ? 

 

- Quentin

Colinu Regular Visitor
Regular Visitor

Re: Pie Chart

They are not important for the time being.

 

quentin_vigne Senior Member
Senior Member

Re: Pie Chart

@Colinu

 

 

First thing i've did is replace the BLANK value by 0. Then everything that looked like TEXT TYPE I turned it into NUMBER.
Example : 15.00 : 15 

Example : 7.50 : 7,5

 

Then

I went back to the pie chart : 

Under Filter : Visual filter level 

I add Partial String testing (NOT the number of Partial string testing, only the field) 

I choose advanced filter > Superior or equal to > 100

 

You do that for every other value and it will work fine.

 

 

- Quentin

Colinu Regular Visitor
Regular Visitor

Re: Pie Chart

Sorry but i am doning somthing worng here or it is not working for me. 

 

please see below screeen shot. 

 

in this instance i have followed you instructions.

Added a filter to the Pie chart so it only shows CableID 2

then added the filter to Partial string test >100. the value in the filed has been adujsted in the data set to 99 so is should not show. when i apply this filter the whole chart disapears.

Capture9.JPGCapture10.JPG

 

Highlighted
Colinu Regular Visitor
Regular Visitor

Re: Pie Chart

Sorry but i am doning somthing worng here or it is not working for me. 

 

please see below screeen shot. 

 

in this instance i have followed you instructions.

Added a filter to the Pie chart so it only shows CableID 2

then added the filter to Partial string test >100. the value in the filed has been adujsted in the data set to 99 so is should not show. when i apply this filter the whole chart disapears.

Capture9.JPGCapture10.JPG