Variable in Diagram-Expression

[#1]

hi,

is it possible to define an expression of an diagram as variable?

[#2]

Hi

Sorry, but I'm really not sure what you are asking here, what is it that you want to do? Can you post an example of a doc that's not working?

Cheers,

[rbecher]

..just store a formula in a variable or table.

Var1 = "=sum(value)"

- Ralf

[#4]

See attached

1. I created a variable called vFormel which changes according to what you are selecting in the list box for Formel (check the variables in Settings, Variables). I then created another copy of your pivot which is using this variable.

2. I created a variable with =Sum(Wert) as the content and then created a further copy of your pivot that uses this variable.

Hope this helps,

[rbecher]

..did the wrong upload. Now the example is attached.

[#6]

.....so now Im completely confused, it looks to me like you have it working!!

Can you explain what you need to do with this now?

[rbecher]

..two different approaches. In my example user can edit expression, in your example use can select it.

- Ralf

[#8]

i've got a datatable like this:

id, group, value

1, a, 10

2, a, 5

3, a, 8

4, b, 1

5, b, 8.3

6, b, 0

in my diagram i wanna sum all values which are in group a and average all values in group b in the same column.

so the expression can look like this

if(group='a', sum(value), avg(value))

in my case i have many groups. so it would be fine to add a second datatable:

group, expresssion

a, sum(value)

b, avg(value)

and use the field "expression" to define the expression of the diagram.

[rbecher]

Frank,

I don't think it's possible to have different aggregation functions in one column.

- Ralf

[johnw]

You can have different aggregation functions in one column, and with the exact data and expression Frank mentioned.