7 Replies Latest reply: Nov 5, 2014 11:48 AM by Ersen B

# Values in Line Chart

Hi experts

I have the following problem:

I created a line chart kumulating values. Problem is, the lines are not continued once there is no value added in a month. Is the a wasy to fix this problem?

Jan

• ###### Re: Values in Line Chart

Hi,

Try changing the presentation options of the line in the expressions tab of chart's properties.

Marc.

• ###### Re: Values in Line Chart

Are you pulling month dimension from a dimension table?

I assume

Try writing cumulative expression label it so you can refer it with above.

Choose No Accumulate

Label = MyCumExpression

Expression =rangeSum(Sum(MyMeasure), above(MyCumExpression))

this way you will produce accumulated numbers always

• ###### Re: Values in Line Chart

Hi Ersen

You are right, my dimension is month.

I already have a complex expression : Sum ({<Jahr={\$(VmaxJahr)}>} ([Rohertrag_AP]))

I am not sure how to integrate your text in my expression...

What does MyCumExpression do?

Jan

• ###### Re: Re: Values in Line Chart

It is the Label of your expression.

First: Label your expression as MyExpression

Then: Keep your expression and wrap with red areas below into Definition:

RangeSum(Above(MyExpression), Sum ({<Jahr={\$(VmaxJahr)}>} ([Rohertrag_AP])) )

3 - Make sure No Accumulation is picked

• ###### Re: Values in Line Chart

Hi Ersen

It looks good to me but I still do not understand the function of "MyExpression". Is this supposed to be the range in which I want to show values? The label only gives the name for the function, right?

Best

Jan

• ###### Re: Values in Line Chart

Hi,

You are right, MyExpression is just the name to reference from other expressions/calculations.

So when you say Above(MyExpression) it goes and gets the data right above/before current place in your chart. So it is the previous value of the expression.

And RangeSum sums ABOVE value and current value to make accumulated values in your cells.

Is it clear or needs further explanation?

Ersen

• ###### Re: Values in Line Chart

As suggested above you can use expression to implement the accumulation.

Where try using any supress null()  settings at dimension as well as presentation level.