Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Filters
Created by Guest
Created on Dec 13, 2019
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit SPF-I-5063 Calculated Columns that Filter With Data.

Make Calculated columns work on filters Merged

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.

  • Guest
    Jun 23, 2023

    @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?


  • Guest
    Jan 3, 2020

    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.