Calculated Column Dynamic

[Carlos Stehlik]

Hi All, I would like to create a calculated column based on the slider filter

. ____Description of the table:

The table has the following columns:

+Well Name [string]

+Date Time [Date Time]

+Hole Depth [Real]

+Diff Time [Real] (Elapsed Time Between Rows)

In the table there are many "Well Name" loaded, for example, the first 1000 rows may refer to the Well I and then, from the row number 1001 to the row 1500 refer to the Well II and from the rows 1501 to the row 2300 refer to Well III, etc (the number of rows/well vary from one well over the rest)

____Descritpion of what I need: I need to create a "dynamic Calculated Column" that sums the "Diff Time" rows and when the slider filter of MD is moved, the "dynamic Calculated Column" have to sum the values that fall within the filter. I have wrtitten the following expression:

Sum([Diff Time]) OVER (Intersect([Well Name],allPrevious([MD]))).

But it does not work well since when when the MD filter is moved, the calculated colum is still summing the values that fall out of the filter. Any idea what a I doing wrong Thanks.

[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