Changing Metrics within a container

[#1]

Hi All,

Problem

I'm having trouble getting my head round what I'm sure is a fairly simple concept.

I have a container chart which tracks different properties of metrics. For example, averages, distributions, volumes etc.

I want to be able to change the variable which is being measured by looking through a list and selecting in the list. I have a lot of different variables I would like to look at and do not want single buttons for each metric, rather a list of possible selections

How do I set this up?

Data Structure

My data is set up as so. What I want is a list of balance, age, kid etc. that I can select and the container chart in the middle will show the average of whichever metric is selected.

Balance	Product	Age	Party	Car	Kids
100	1a	18	I	BMW	0
200	2b	123	B	BMW	1
250	1d	32	N	BMW	2
130	4c	45	R	VW	0

Thanks,

Joseph

[sunny_talwar]

Try the attached

Expression: =Avg($(=List))