Line Chart

[#1]

I have a table like this:

Date	Value	Precision
10.11.2012	10	0.1
11.11.2012	15	0.2
11.11.2012	20	0.15
11.11.2012	10	0.1
12.11.2012	20	0.2
12.11.2012	15	0.3

I would like to build a line chart which would have dates on the x-axis and values at y-axis. It should display values for each date. The problem is having multiple values on a single day. How can we dispay all values for each day?

[#2]

hello,

I believe that if you put the DATE dimension and expression to put COUNT (VALUE) and COUNT (PRECISION) will work.

[maleksafa]

you need to use sum or other aggregation function on the value field.

[jagan]

HI,

Try like this, you need to use aggregation function Sum(), Max() or Min() as per the requirement.

Dimension : Date

Expression: Sum(Value)

Hope this helps you.

Regards,

Jagan.

[#5]

But this will give me the sum of values for each day. I want to display all the values instead of displaying the sum or average of those values.

[jagan · Accepted solution]

Hi,

Generally in chart the expression need to use some of the aggregation functions, otherwise if there are multiple values for the same dimension value then you will get the null value for that dimension, to overcome this you need to differentiate each dimension value like below

LOAD

Date(Num(Date) + RecNo()/1000) AS Key,

Date,

Value

FROM DataSource;

Now use Key in dimension and value as expression, now you will get all the values.

Hope this helps you.

Regards,

Jagan.