
Re: Counting based on acumulated %
Sree Anarasi Dec 5, 2012 4:46 PM (in response to Clever Anjos )in the epressions u can write an if condition and assign the
if (x <30,count(customers),
if(30<x<50 ,count(customers
..
try this

Re: Counting based on acumulated %
Clever Anjos Dec 6, 2012 5:49 AM (in response to Sree Anarasi )I need to develop another graph, that does not have Dim4 as a dimension.


Re: Counting based on acumulated %
whiteline _ Dec 6, 2012 1:24 AM (in response to Clever Anjos )Hi.
Your [V%a] and [class] columns, are they calculated in script or in chart ?

Re: Counting based on acumulated %
Clever Anjos Dec 6, 2012 5:49 AM (in response to whiteline _)v%, v%a and Class are calculated at graph
v% = sum(Expression1)/sum(TOTAL Expression1)
v%a = RangeSum(above(Column(2),0,RowNo()))
and
class = if(column(3)<0.3,1,if(column(3)<0.5,2,if(column(3)<0.8,3,4))))

Re: Counting based on acumulated %
whiteline _ Dec 6, 2012 3:06 PM (in response to Clever Anjos )Hi.
You can create a chart with calculated dimension (used fractile as an example, rank() is also suitable):
aggr(
if(Sum(V)>=fractile(total aggr(Sum(V), Dim4), 0.8), dual('<30%', 0),
if(Sum(V)>=fractile(total aggr(Sum(V), Dim4), 0.6), dual('>=30%<50%', 0.3),
if(Sum(V)>=fractile(total aggr(Sum(V), Dim4), 0.26), dual('>=50%<80%', 0.5), dual('>=80%', 0.8))))
, Dim4)
The problem is I don't know how to calculate fractile parameter dynamicaly according to your percent criteria
As for expresison use just =Count(Dim4)

Re: Counting based on acumulated %
Clever Anjos Dec 7, 2012 11:18 AM (in response to whiteline _)I´ll try smething like this


