10 Replies Latest reply: Jul 30, 2012 9:11 AM by aholabach

# accumulation in a diagram

Hi,

I have different values for each week and want to accumulate them. I tried it with the accumulation button and with the formula

=

rangesum(sum(VerfügtMore), above([Verfügt IST]))

I get the same result by both (picture the blue and the light green line)

Is it possible, that the line isn't over the whole x-Axis? only there, where I have accolulated values?

so that they ends at the value 25?

thanks

• ###### Re: accumulation in a diagram

Not sure if I've understood.

What do you mean with 'where I have accumulated values'? Do you mean something like where sum(VerfügtMore) is above zero?

Try maybe something like

=if( sum(VerfügtMore) <>0, rangesum(sum(VerfügtMore), above([Verfügt IST])), NULL())

or

=if( WeekField <=25, rangesum(sum(VerfügtMore), above([Verfügt IST])), NULL())

• ###### Re: accumulation in a diagram

Yes, the graph is correct now, but I have to change the week every week than.

So that I have to change the 25 to 26 next week and so on. Or is it possible to avoid that somehow?

• ###### Re: accumulation in a diagram

Potentially yes, but I can't tell how you determine that your graph should stop at week 25 only only looking at your image. You need to tell us your criterium to show / not show the accumulated values.

For example, if week number should be limited by today's week, use week(today()) as limit in your condition instead of the magic number 25. If it should be limited by looking at the presence of some other field value, do so.

• ###### Re: accumulation in a diagram

so the whole background:

the Original file is the Forecast attached (I haven't done it) and there is the formula only sum([Verfügt (EUR)]), that's my VerfügtMore and the line is correct it is only there, where it should be, so there where we have values (at the moment from week 1 to 25) but if I do it in my file Projektarbeit_Excel it display wrong, it doesn't accomulate the datas from the weeks.

So I tried the two solutions I already mentioned, but the line should look like that one from Forecast

• ###### Re: accumulation in a diagram

Not sure if I understand, if I open your Projektarbeit_excel.qvw file, the Verfügt Ist stops at week 25, so I don't see any issue here (and it seems to me that it does accumulate, but the accumulation is part of the data itself, right?):

• ###### Re: accumulation in a diagram

the blue line ends at 25 because I take the if instruction, you saies

and yes, it should accomulate the datas itself for example week 2 = value week 1 + value week 2

• ###### Re: accumulation in a diagram

That's not what I see, I see as expression for the blue line (Verfügt IST):

=sum([Verfügt (EUR)])

• ###### Re: accumulation in a diagram

in the Forecast file yes, and that's what I don't understand, because if I make =sum([VerfügtMore]) it's a whole line up to week 53 and not up to 25

• ###### Re: accumulation in a diagram

But anyway, I see the same expression in both qvw files and no field called [VerfügtMore].

Sorry, this is too confusing for me, I am giving up on this.

One last thing I noticed: Your data model is fundamentally different from the Forecast model, since you've (probably unintentionally) created a synthetic key table.

This might cause issues (which I still can't see, as said).

Have a nice day,

Stefan

• ###### Re: accumulation in a diagram

hm, maybe is that with the key, can I delet that somehow?

but thanks for your help !!

and also a nice day