Hi Have Created a Pie Chart.
There i have 4 catogiries and one catogory is null.
I want to display all catogories in the chart.
So in my legend the null value shows as "-".
I need to rename that value as "NOT Recived".
Please help me to do this.
if category contains all categories the 5 you write in the expression
if(catogory ='-', 'NOT Recived',catogory)
if category only contains '-' write
if(catogory ='-', 'NOT Recived')
please tell me where to put that expression in PIe chart.
my four catogories are,
Recive with Accept
Recived with reject
Recived with Data Change
Ricived with Errors
and "-" - I want to display this as "NOt Recived"
which are your dimension and you expression??
Find the attached application,you will get an idea.
Hi This works fine , Thanks.
But There is a Problem.
I can't clik on "NOt Recived" are and filler the data.
Try in script, then
You need that one chart or more than that, if more than one means,
Load *, if(isnull(FieldName)=-1,'NotReceived',FieldName) as FieldName from tablename;
Hope it helps
Retrieving data ...