title: OBIEE: Line graphs from pivot table
body: <p>I am very new to the Oracle Business Intelligence tool which uses SQL. I have filtered my data and organized it into a pivot table. The pivot table returns values like this:</p>
  
  <pre><code>Week    Value
  08      100.00
  11      100.00
  13      100.00
  14      89.29
  15      99.76
  16      90.67
  17      90.24
  </code></pre>
  
  <p>There are more values, but as you can see the lowest values are in the mid to high 80s. Yet my graph is showing strange negative values:</p>
  
  <p><a href="https://i.stack.imgur.com/XHnNf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XHnNf.png" alt="enter image description here"></a></p>
  
  <p><strong>So my question is how to assure what values are being plotted in the graph are the values in my pivot table?</strong> Everything looks fine in the "Layout" section but I am curious if there is a way to assure the values are displayed in the graph <em>exactly</em> as they are in the pivot table.</p>