How to display all values in a chart with no aggregation

[#1]

Hello,

I need to represent in a line chart Depth vs Costs. So Depth should be my dimension and I need two expressions for cost.

The problem is that I need every point in the chart, but I can´t doi it, because I'm being forced to represent just one point for each dimension value.

Can anyone help.

0		2073047,18
0	2439898	2082799,39
59		2486656,697
60	2485629
60	2492270
60	2802344
61		2604272,5
61		2694392,982
61		2745781,764
61		2940486,072
65		3005381,252
65	2816615
65	2829456

The result should be something like this:

[#2]

Well please correct me if I am wrong... but you want to see 59,59,60,60,60 in place of 0,10,20,30,40 on the chart axis... If this is what you are trying to dont think you can do it normally... I mean QV sums up the values for common dimensions... its the standard functionality on any sheet object. If you want the sales for a month dimension it shows the sum(sales) for the whole month and if you want to see all then you can use a Straight table where you will see it... but i dont hink you can see it on the chart..sorry

ANDY

[Anonymous]

Instead of a straight table, you may want to look at a Table Box which is ideal to show the raw data. You may also include a rownum() in your load and include that as a dimension (you could even hide it in presentation tab) to truly avoid any aggregation..

Regards,

Dinesh.

[#4]

I´ve already tried with the row number as a dimension but the chart shows each point a as different series

[johnw · Accepted solution]

You can do it with a scatter chart instead of a line chart. See attached.

[#6]

Thank you John, it's working perfect!