Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
below is my result formulae and i used exprsn ...
( No of Defects Re-op / Total No of ref fixed ) * 100
used exp: =num(Def_Status='Reop')/sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))*100
it shwng exprn Ok... but pie chrt values or not getting..
Error message:no data to dispaly
please help me the expression
Thanks in advance
Suresh
Does your expression contains -ve values??
FYI, Pie chart never represent -ve Values..
yeah..jagan...
this is the final exp
with i hve multiple field names
(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) )*100
it is shwng Exp ok. bu values no exposing i need in pie chart as %?
yes..but i dont hve to disply -ve values...
Hi Suresh,
Can you post your application.?
try this:
=num(
count({<Def_Status={'Reop'}>} DimensionField) //may use Distinct as well
/
sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))
,'#')*100
or
Where do you want to multiply with 100, if it is with sum() then like this
=num(
count({<Def_Status={'Reop'}>} DimensionField) //may use Distinct as well
/
sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))*100
,'#')
Then put condition like in your expression:
=if(sum(sales)>0, sum(sales)) where sum(sales) is your expression
Hi Suresh,
Give this expression
(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) )
and in number tab select percentage option.
Note: Pie chart won't display negative values, if you have negative values then you have filter it out like below
If((count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) ) > 0,
(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) ))
Hope this helps you.
Regards,
Jagan.