I have an issue in creating the Line chart. The actual need is we need to create the line chart that shows the pressure variation along the length of the pipe. For some times, the pressure varies at the same length so we will have two values for the same length. Below is the sample data
length pressure
0 1200
100 1100
100 900
200 1300
300 1100
400 1400
400 1100
In the above case, for the x axis value of 100, the pressure is aggregated to 2000 and for length 400 it is 2500. Actually it should show the trend of pressure decreasing for the length. Below is the attached sample of chart how it should be created. I am not able to achieve this in cognos since it always aggregate the measures. I even tried with Auto group option to No. Any one have any suggestions please.
If you have a relational source you could include a running-count in your query for the length data item, then concatenate the length and count together. This would give you something like:
0 - Reading 1
100 - Reading 1
100 - Reading 2
200 - Reading 1
etc.
Of course you could append those together in any format you like for visual appeal in the chart.