I have table with calculated dimension using class and aggr functions
The result looks something like this
To obtain this I forced all days lower than -30 in the "-30 <= Days <0" bucket and averything larger than 150 Days in the
"150 <= Days < 180" bucket
So what I really want to display for the first and the last row is
"Days < 0" instead of "-30 <= Days < 0" and
"150 <= Days" instead of "150 <= Days < 180"
The calculated dimension expression is
=
class(
aggr(if(Sum(Stock) < 0, -1, if(Sum(Stock)/sum(OutGoing*-1)>150,155,
round(Sum(Stock)/sum(OutGoing*-1)))),
Product,Warehouse
),
30, 'Days', -30)
Can anyone tell me how to do this