I am creating buckets of revenue dimension as follows
If([Net Revenue]/1000<0,-15,
If([Net Revenue]/1000=0,15,
If([Net Revenue]/1000>255,255,
Ceil(([Net Revenue]/1000),15))))
Problem is in axis tab I have to set max value because I want to keep two adjacent charts have same y-axis.
So when I found max value by aggregating expression by above calculated dimension then according to help I cant do that because aggr can only have single field not an expression or calculated dimension. So any solution if I can use anything similar to calculate max value of chart?
One more thing I cant move this calculated dimension to the load script as user can adjust Net Revenue by a factor so every record will have dynamic adjusted net revenue.
Just as idea - you could use a variable for your max y-axis in all charts. Also you could put variables in the calculated dimension for indiviually adjustments by the users.
You could als see to class() function - perhaps it si an alternatively approach for the calculated dimension.
