Dynamic data buckets aggregation issue

[#1]

Hi everyone ,

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.

Any help is highly appreciated.

Regards:

Mubbasher Khaliq

[marcus_sommer]

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.

- Marcus