Variable using aggr

[#1]

Dear all,

I'm looking for a substitute for an aggregation I'm using alot in my graphs: sum(aggr(column_to_be_summed,aggregation1,aggregation1,aggregation2,aggregation3)). Due to the design of my link table I cannot go arround aggregating before I do the sum.

Is there a way I can replace this with for example a variable?

I want to make it my users as easy as possible to create their own graphs.

Thanks!

[forte · Accepted solution]

Hi  bluemtms :

Just create a variable named , in example, vMyExp and give it this value :

sum(aggr(column_to_be_summed,aggregation1,aggregation1,aggregation2,aggregation3))

, be sure to not use equal at the begining. Each time you need to use it write $(vMyExp) instead of that sum.

Hope it helps

Regards

[#3]

Thanks, I tried this already but failed because I didn't use the sum of the aggr(). I thought I could just store the aggr() in a variable.

This is so easy

[#4]

Is there somewhere a good reference for working with variables? I don't really understand the difference between LET and SET and the myvar='=expression'...

The reference guide is not really helpful in that aspect