Line Chart Offset

[matancha]

Hello all.

Is there a way to start a line graph not from 0 (line offset), something like Bar offset but with line?

I'm trying to make a graph for show movements in warehouse (in - out).

My dimention is the time (Yeaar | Month | Date), and the user choose a warehouse.

I'm hold the initial balance in variable called: (vInitBalance), and I want to start the line (Y axis) from (vInitBalance) value, and not from zero.

My problem is that my expression need to be define with "full Accumulation", so i can't define expression like (  $(vInitBalance) + In - Out).

So I looking for a way to doing "line offset".

Thanks in advance for any help -

Matan.

[#2]

Hi,

Uncheck "Forced 0" under Axes tab from chart properties. And use, Scale to setup your own Static Minimum and Static Maximum with Static Step values for your line offset's.

[matancha]

HI,

What I need is to showing the right values.

I could not understand how set Min and Max of the Y axis -  helps me.

I'm need to move the line (In your proposal the values stay the same).

Tnx -

Matan.

[MayilVahanan]

Hi

PFA - Line chart

Hope that helps

[#5]

Hi

Could you attach your sample application if possible (Or) at leat data from your table?

[matancha]

I could not understand how your example is supposed to help me. Could you try to explain me?

Matan.

[lironbaram]

hi attach is an example

[whiteline · Accepted solution]

Hi.

You could just add $(vInitBalance) only for the first dimension value where rowno()=1.

[matancha]

Thanks you all.

Liron, just because that my dimention is ciclyc dimention the solution of whiteline is better for me. Yours approach is the same.

Tnx again -

Matan.