restrict bar

[soniasweety]

Hi @sunny_talwar   @Vegar  @tresesco 

i want to restrict  the bar value.  

i have a bar chatrt showing  percentatge  of 

DIm: branch

measure=count(total open value)/count(dtotal dispatch) 

data is showing proper values with  all bars.

but  for one branch (pune) its showing 875.0%  as   user dont want to see that much value.. cant we restrict  only for that branch percentage to 100 ?  any suggestions?

[Taoufiq_Zarra]

@soniasweety like ?

if((count(total [open value])/count(total dispatch))>1,1,(count(total [open value])/count(total dispatch)))

[soniasweety]

No luck showing 1 for all bars  😞

[Taoufiq_Zarra]

can you show me the value of (count(total [open value])/count(total dispatch)) or try this :

if((count(total [open value])/count(total dispatch))>100,100,(count(total [open value])/count(total dispatch)))

[soniasweety]

attached sample

[sunny_talwar]

Why are you using TOTAL in both your numerator and denominator expression?

[Kushal_Chawda]

@soniasweety  your expression should look like below. see the attached

=if(sum( open)/sum( distach)>1,0,sum( open)/sum( distach))

. 

[soniasweety]

Hi kush,

i didnt see  pune in your attached file ?  ..

[Kushal_Chawda]

@soniasweety  It's hidden in bar as % is more than 100