How to get field instead of field name

[#1]

Hello,

I dynamically calculate the Static max value that needs to be displayed on the Y-axis. For this I use the following formula in which I compare a defined Upper limit and the max of Y-axis expr

rangemax($(ServeLineChartYExprULimit),max(aggr($(ServeLineChartYExpr),dd_row_date)))

where dd_row_date is the first dimension in a DateCyclic(Date,Week,Month).

Obviously when I change the DateCyclic to month it automatically doesn't change the above expr.

My question is:

Is there any other solution then writing 3(for D,W,M) if condition using the GetCurrentField("DateCyclic") .In another words is there anything that would return the field instead of the fieldname so I can directly write an expression as

rangemax($(ServeLineChartYExprULimit),max(aggr($(ServeLineChartYExpr),GetCurrentField("DateCyclic"))))

[biester · Accepted solution]

Don't know whether I'm getting you right, but try to use

$(= GetCurrentField("DateCyclic"))

instead of

GetCurrentField("DateCyclic")

in your last mentioned expression.

Rgds,
Joachim

[#3]

It worked!!!

Thanks so much

Aparna