Spotfire Ideas Portal
Often we face issues while using a calculated column, they do not work on filters. Example if a calculated column is created to calculate average of a particular column, it calculates the average on the entire dataset but does not work if any filter is applied and we need the average on the sub data, it is a basic calculation need and I think developers of the tool should look into it.
@thomas -
Option 1 - I add a calc column after a filtering operation, on the filtered table, and the calc still operates over the entire table - not what I need.
Option 2 - how can I get a data value from a selection within the visualization to put into a doc prop?
JP
Would you be able to calculate the average value in a visualization? Filtering would then be applied before the average is calculated and visualized. Another option is to use the row filter data transformation to filter out the rows. Right click on your filtered values to have a transformation created for you automatically.