Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Hi Anu,
Find the attached application,you will get an idea.
Regards,
Tom
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??
Hi Anu,
Find the attached application,you will get an idea.
Regards,
Tom
Hi This works fine , Thanks.
But There is a Problem.
I can't clik on "NOt Recived" are and filler the data.
Please help.
Thanks
Hi
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