Line chart issue

[#1]

I have a line chart with X axis as calendar months and Y axis as Amount. there are 2 facts, budget amount and actual amount.

I have the budget for the entire year so the line for budget is displayed for the entire year cummulatively. But the actual amount is still the month of May.

So the line for actual amount goes up till that month and the corrosponding cumulated amount but after that goes flat till the last month.

I dont want that to happen. The actual amount line should be only till the month and should not extend flat till the last month.

Please let me know how this can be done.

[#2 · Accepted solution]

Laxmikantm,

Check out the attached application. I believe your are doing the accumulation using the "Full Accumulation" option.

But you could do this with the combination of RangeSum() and Above() functions.

Your expression should be as below.

            if(aggr(sum(Sales),Date)>0,Rangesum(above(Sum (Sales),0,rowno())))

- Sridhar

[#3]

Thanks Sridhar for help.

[#4]

Good One Shridhar sir..................

  I like this solution.....

  Shridhar can u pls send me any example qvw for rangesum ,rangeavg , and peak function etc.........

Waiting for your reply......

pls mail me @

dushyant.ntpc@gmail.com

Dushyant

[#5]

Dushyant,

I don't have any particular application for rangesum ,rangeavg and peak functions as of now. But all these functions are been discussed on the forum many times. Start searching this forum you would get many examples.

- Sridhar