Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on May 7, 2019

Add a new property, e.g. "ExpressionWithoutAlias" to solve the problem of adding x-axis display name by using a custom expression to scatter plot breaks y-axis expression

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

  • Attach files
  • Guest
    Reply
    |
    Jul 2, 2019

    Hi,

    What is the plan to implement this idea?