Row level Count

[sspawar88]

Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)/

Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type)

This expression gives me 100% Stack bar chart for branch_type which i have required.

but when i drill down for branch_name, loc_code, loc_type  it won't show 100%. i require all bars with perfect 100%

what Changes need to be put in expression?

gwassenaar‌

swuehl‌

[swuehl]

Instead of the aggr() function, try the TOTAL qualifier in the second count(), with all drill down dimension fields stated in the qualifier field list.

[sspawar88]

Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)

/count({<param_name={'TEMP'},param_value={'<=-1'}>}total<branch_type,branch_name,loc_code,loc_type> param_value)

when i used Total in denominator it gives 400% and all stacks are in same proportion which is incorrect.

[Kushal_Chawda · Accepted solution]

Please use the below expression. It's working for me

Num(Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)

/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),$(=GetCurrentField([BT-BN-LT-LC]))),'#,##0.00%')

[swuehl]

Would be better next time you post a request if you fully describe your scenario, best by posting a small sample QVW.

Everything else is kind of guessing and inefficient.