Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
Aggr(nodistinct count(param_value),branch_type)
Can i add two dimension like this
Aggr(nodistinct count(param_value),branch_type,branch_name)
it is not working.
Hi,
The expression it's right. Maybe you need check your data
Yes, you could use more then one dimension, maybe you need a further aggregation to get your result and you should try if nodistinct really covered your aim:
sum(Aggr(nodistinct count(param_value),branch_type,branch_name))
- Marcus
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type)
i'm using this expression it shows branch_type 100% in stack bar chart which is correct.
but my dimension is group branch_type,branch_name, loc_code.
when i drilled it level 2 and level 3. they are not 100% which is not correct.
How can i make change in my expression?
Count({<param_name={'TEMP'}, param_value={'<=-1'}>} param_value)
/Aggr(Nodistinct count({<param_name={'TEMP'}, param_value={'<=-1'}>}param_value),branch_type)
i'm using this expression it shows branch_type 100% in stack bar chart which is correct.
but my dimension is group branch_type,branch_name, loc_code.
when i drilled it level 2 and level 3. they are not 100% which is not correct.
How can i make change in my expression?
On a lower data-level there could be missing data or NULL or 0 as divident. You could try to fetch it with functions like alt(). Helpful could further be to copy this chart, turn it in a chart-table and use each expression part as single-expression, too see if it returned your expected values.
- Marcus
By a dimension-group you need to query the current dimension and use them as dimension with your aggr:
aggr(YourExpression, $(=getcurrentfield(YourDimensionGroup)))
- Marcus