Skip to Main Content
Spotfire Ideas Portal

Calculated Columns that Filter With Data

Calculated Columns are powerful but often not useful if they don't recalculated based on filtered data.  We've developed scrips to flag filtered records and calculate over that flag but this requires the user to click a button every time they filter the data.

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Jun 23, 2023

      This is an important feature - Spotfire does not support scientific workflows very well and this is one important example. Can we please get some movement on this idea?

    11 MERGED

    Option to have calculated columns that work on FIltered Data

    When I create a calculated column, especially with OVER function, it always works on all of the rows of data in the table. Can we have an option where such calculated column only work on the filtered rows of data
    over 5 years ago in Spotfire / Data Management 0 Future Consideration
    92 MERGED

    Update Calculated Column when filtering changes

    Allow calculated columns to be calculated based on filtered values instead of all values in a column.
    about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration
    28 MERGED

    Make Calculated columns work on filters

    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 filt...
    over 5 years ago in Spotfire / Filters 2 Future Consideration