Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart with a calculated dimension and each expression uses a pick(match()) function to use a different expression for each dimension. I have run into a problem with a new function which is below. It will only return a value in the chart at the first row in the chart. So if i put the function in the second row pick(match()) slot, it will return null because it is not the first row in the chart.
aggr( if(round(($(vTxnBucketAgg('Buys',[Lower Of SP-Moody],BASE_MKT_VALUE)))/($(vTxnBucketExclusionAgg('Buys',[Lower Of SP-Moody],BASE_MKT_VALUE)))) = ORDER_ID, sp_rc_dual),
ORDER_ID)
We can simplify the above and just say aggr(if( 3 = order_id, sp_rc_dual), order_id)
The calculated dimension on this chart is a value list:
ValueList(
'Begin',
'Buys',
'Sells',
'End'
)
Is anyone aware of a reason or way to work around this restriction to get these values to display at all rows so they will pick up in the pick(match()) expressions?
Hi,
maybe you have to add NODISTINCT ?
It's the simple things in life. Thanks so much