Remove Filtered Out data from Calculated Columns

[Manoj Chaurasia]

Hello,

 

I have a few calculated columns in my analysis. I would like the results of the calculation to change accordingly when data is filtered.

 

For instance, if my calculation is: Count([PubType])

I would like the result to be different when i filter out some of the PubTypes. Right now, this does not happen. The calculation takes into account ALL the data that is in the data table regardless of whether it is filtered out or not.

 

Does anybody know how to get around this

 

Thanks a lot!

[Manoj Chaurasia]

Calculated columns are not dynamically recalculated, so you would need to create them as 'custom expressions' which are dynamic. You can create the custom expression on any axis by right clicking on the Axis selector and selecting 'Custom Expression...'. The resulting interface looks nearly identical to the calculated column interface, but the expression will be recalculated each time you filter.

[Michael Kalada 2]

There is a wiki that shows how to make calculated columns in a table respond to filters. Its a python script, there are other posts that show how to execute a python script on filter changes

 

https://community.spotfire.com/wiki/calculated-columns-table-respond-filters