Forum Discussion
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.
| String | Cable ID | Size | Tower | Pre-term Testing | Preparations | Terminations | Post term testing | Partial string testing |
| 2 | 1 | 15.00 | 20.00 | 15.00 | 5.00 | 100.00 | ||
| AB01 - AB05 | AB01 | 7.50 | 15.00 | 5.00 | 100.00 | |||
| AB06 - AB02 | AB02 | 7.50 | 15.00 | 5.00 | 100.00 | |||
| AB02 - AB01 | AB02 | 5.00 | 15.00 | 5.00 | 100.00 | |||
| AB08 - AB03 | AB03 | 5.00 | 15.00 | 5.00 | 100.00 | |||
| AB03 - AB04 | AB03 | 5.00 | 15.00 | 5.00 | 100.00 | |||
| AB03 - AB04 | AB04 | 5.00 | 15.00 | 5.00 | 100.00 | |||
| AB01 - AB05 | AB05 | 15.00 | 5.00 | 100.00 | ||||
| AB11 - AB06 | AB06 | 15.00 | 5.00 | |||||
| AB06 - AB02 | AB06 | 15.00 | 5.00 | |||||
| AB12 - AB07 | AB07 | 15.00 | ||||||
| AB07 - AB08 | AB07 | 15.00 | ||||||
| AB07 - AB08 | AB08 | 15.00 | ||||||
| AB08 - AB03 | AB08 | 15.00 |
They are not important for the time being.
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 : 15Example : 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
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.
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.