Using multiple Y-axis columns may throw "The expression is not valid" error in Spotfire

Using multiple Y-axis columns may throw "The expression is not valid" error in Spotfire

If you are using two columns on the Y axis and one column has aggregation and another column does not have aggregation, then the visualization will throw the error, "The expression is not valid". If you separate the Y- axis columns and put them on different visualization, it works. One reason that you may see the error "The expression is not valid" is because if the first column has an aggregation but the second column does not. All the columns that are used on the Y axis should either have aggregation on all the columns or they should not have any aggregation. See the attached (Filename: MultipleYaxis.dxp ) for reference.