write a formula based on percentage... for example
if percentage <0.35 then
"Less than 35%"
elseif percentage >=0.35 and percentage<=0.60 then
"30 to 60% Group"
"above 60% groups"
use this as your first column so that automatically it will create groups... when you place districts with this automatically all districts which are less than 35% will come under 35 and vice versa....
Based on your suggestions,I have written the following formula:
IF [Penta3 <1 Coverage] >=.95 THEN ‘% Districts >=95%’
ELSEIF [Penta3 <1 Coverage] >=.8 THEN ‘% Districts >=8%’
ELSEIF ([Penta3 <1 Coverage] >0 and [Penta3 Coverage] < .8 THEN '% Districts >=50% and <80%’
Please comment on the following two points:
1. I don't need districts with coverage less than 50% to appear in my visualization
2. normally 'IF' statements have 'ELSE' row before 'END'. Is it ok to leave it out in my formula above?
Its okay ELSE is not compulsory.... also mention only those percentages which required for you. while filtering this field select only required and leave nulls and blanks and whichever is not require. Hope with this your answer is clear. Please click on correct answer or helpful... good luck...
I have used the following formula:
IF [Penta3 Coverage %] >=.95 THEN '% Districts >=95%’
ELSEIF [Penta3 Coverage %] >=.8 THEN ‘% Districts >=8%’
ELSEIF ([Penta3 Coverage %] >0 and [Penta3 Coverage %] <.8 THEN '% Districts >=50% and <80%’
But it is invalid and the error message says 'Bad Character'