2 Replies Latest reply: Feb 23, 2017 5:39 PM by swana woo

# Can I use a values of one charts' measure as a variable(or just use) in another chart

I have 2 table charts.

one is for average value by group

Group
Average
A//this value is calculated by the selection of date range
B//this value is calculated by the selection of date range
C//this value is calculated by the selection of date range

expression for Average column is like this: Avg({\$<[money]={">0"}>} [money])     //check 'money' for the value that has null or 0 values

since the value of 'Average' column is calculated dynamically with the selection of date range, I can't set it as a static variable on loading the data.

another table is for utilizing the calculated value of Average from above table chart.

below is the table when date range 2/20~2/22 is selected. so the corresponding Avererage value should be 6 for group A and 7 for group B.(there is no data for group C in selected range, so don't need to consider it)

Groupdate

original value

original value + Average of Group
A2/2039 //3+6
A2/21//just show nothingm, because there is no original value
A2/22915 //9+6
B2/20512 //5+7
B2/22916 //9+7

I don't know how to set expression for the 'original value + Average of Group' column.

Is there anybody can help me? It would be really appreciated.

• ###### Re: Can I use a values of one charts' measure as a variable(or just use) in another chart

maybe

Avg(TOTAL <Group>  {\$<money={">0"}>} money)

+

Avg({\$<money={">0"}>} money)

• ###### Re: Can I use a values of one charts' measure as a variable(or just use) in another chart

Thank you so much!!!