Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
hello,
I believe that if you put the DATE dimension and expression to put COUNT (VALUE) and COUNT (PRECISION) will work.
you need to use sum or other aggregation function on the value field.
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.
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.
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.