Well rate vs cumulative production - mapping plan and actual in one plot.

[Christian Hart]

Hello

I am trying to bring together data from two distinct data tables. One data table has the actual well average production rate over time and a calculated column (within spotfire) for the total cumulative production. The second table has my planned well average production rate over time and a calculated column (within spotfire) for the total cumulative planned production. What I am trying to do is plot the actual and planned average production rates on the y axis and have the cumulative production along the x axis. The desired deliverable would be a line for the planned production and a line for the actual production.

I built a data relationship between the two tables for both the cumulative production fields and the average well rate production field, but something does not seem to be working. I constantly get a flat line along a specific y axis value for the variable that is not part of the main data table for the plot.

I have tried the following:

- Made sure that my source values were all the same data source type (real)

- Made sure the data relationships were mapped for all the variables were the same in the plot

- Confirmed the data formatting was the same for all the variables

What am I missing here Thanks again in advance for your help.

Chris

[Khushboo Rabadia]

Have you inserted planned data column in table1 from table2 or just referencing column from table2 in line chart viz

It would be easy to troubleshoot issue if you could provide sample dxp