Set analysis

[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 which i have required.

but when i drill down for branch_name it won't show 100% for branch_name.

what Changes need to be put in expression?

[Kushal_Chawda]

any luck?

[sspawar88]

no dear

[Kushal_Chawda]

Have you tried the expression which I had suggested? or else share the app

[Anonymous]

Try This:

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

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

BR,

Chinna

[sspawar88]

yes tried but not working

[sspawar88]

Error in Expression

[Anonymous]

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

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

[sspawar88]

it gives 100%.

but at second level it gives same stacks for all the bar's.

[sspawar88]

Hi Kush,

Have u any idea?

[Kushal_Chawda]

let me check your app.