Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Is there a way to use the values from table in pie chart?
Table:
column1 column2 column3 column4
exp1 exp2 exp3 exp1+exp2+exp3
I want to put the values of column4 in pie chart.
Is it posssible?
No, that's not possible. You'll have to reuse the expressions from the chart and create one expression from them for the pie chart. What you can do is put the original expressions in variables and use the variables in the table and the pie chart. That way you'll have to maintain them in only one place.
vVar1: sum(X)
vVar2: sum(Y)
vVar3: sum(Z)
exp1: $(vVar1)
exp2: $(vVar2)
exp3: $(vVar3)
exp4: $(vVar1) + $(vVar2) + $(vVar3)
Nemanja
a pie chart will display 1 expression according to dimension
More than 1 (or 2) expression won't be easily readable.
You have to store your total at the same level of other dimension
best regards
Chris
No, that's not possible. You'll have to reuse the expressions from the chart and create one expression from them for the pie chart. What you can do is put the original expressions in variables and use the variables in the table and the pie chart. That way you'll have to maintain them in only one place.
vVar1: sum(X)
vVar2: sum(Y)
vVar3: sum(Z)
exp1: $(vVar1)
exp2: $(vVar2)
exp3: $(vVar3)
exp4: $(vVar1) + $(vVar2) + $(vVar3)
Hi Yo can write your expression as
exp1+exp2+exp3
You cannot use it from another chart
Regards
ASHFAQ