Line Chart

[murugan123]

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.

[Lynn]

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.