title: How to get rid of circular/cyclic dependencies in TIBCO Spotfire?
body: <p>I have two tables that are linked via a relation (edit -> data table properties -> relations). One contains some raw data, and the other contains aggregated data (calculation on the value).</p>
  
  <hr>
  
  <p>You can see some examples below. Here, data are linked on "category" column.</p>
  
  <pre><code>RAW DATA
  category | id | value
  ---------+----+------
     A     |  1 |  10
     A     |  2 |  20
     A     |  3 |  30
     A     |  4 |  30
     B     |  1 |  20
     B     |  2 |  20
  
  COMPUTED DATA
  category | any_calculation  //aggregation of raw data based on category
  ---------+----------------
     A     |       10
     B     |       20
  </code></pre>
  
  <hr>
  
  <p>To do the calculation, I use a R/TERR function that take <strong>raw data</strong> as an input, and that output <strong>computed data</strong>.</p>
  
  <p>Then I display <strong>raw data</strong> in a scatter plot (one per category), and I add a curve that is taken from the column "any_calculation" of the <strong>computed data</strong>.</p>
  
  <hr>
  
  <p>My main problem is that my table with computed data isn't filled by the R/TERR script. The cause is, in my opinion, the cyclic dependency between those two tables.</p>
  
  <p>Do you have any idea/workaround/fix ?</p>
  
  <p>I should also add that I can't do the calculation in the scatter plot (huge calculation). I use Spotfire 7.8.0.</p>