Visualizations display nothing when renaming X-axis with custom expression in any visualization with the following custom expression on the Y-axis :
"NormInv (1 - (Rank(${Axis.X.Expression},"asc","ties.method=first") / (Count(${Axis.X.Expression}) + 1)))"
If you apply this to the Scatter Plot Y-axis and then you named the expression you'll get the same issue. This issue is only replicable with this expression while after editing the expression to : "NormInv (1 - (Rank(${Axis.X.DisplayName},"asc","ties.method=first") / (Count(${Axis.X.DisplayName}) + 1))) " will still complaining about missing ")" in a specific place in the expression.
So the Expression must be updated automatically and correctly after naming the X-axis expression or at least accepting the manual update of the Expression.
Please check TIBCO support case #01648986 for more information, their last resolution was:
The X axis has the expression [N_LD] as [X] and the y axis has the expression Avg(${Axis.X.Expression}) This expression on the y-axis is processed into Avg([N_LD] as [X]) which is an invalid expression, just as the error message indicates. It is however difficult to foresee when to expand the implicit properties with or without alias.The solution without potentially breaking existing analyses would be to add a new property(In future release), e.g. "ExpressionWithoutAlias", to be used in the use case described.
Best Regards,
Ghannam
Hi,
What is the plan to implement this idea?