Can someone assist - new to Spotfire and looking to create an "average min" expression

blevine — Tue, 03 Apr 2012 22:02:26 GMT

Any help would be greatly appreciated...

I have a dataset of people. Each person has different activities they may engage in and amount of calories they may burn. In a HIGHLY simplified state, it essentially looks something like this:

Participant	Time	Calories Burned	Activity
John	12pm	141	Running
John	1pm	210	Running
John	2pm	331	Running
John	3pm	223	Swimming
John	4pm	296	Swimming
John	5pm	95	Swimming
John	6pm	365	Swimming
Susan	12pm	232	Swimming
Susan	3pm	220	Running
Susan	4pm	185	Running
Lee	12pm	301	Running
Lee	1pm	314	Swimming
Lee	2pm	22	Running
Lee	3pm	384	Swimming
Lee	4pm	307	Running
Lee	5pm	468	Running
Lee	6pm	457	Running
Lee	7pm	200	Swimming
Avril	1pm	228	Swimming
Avril	2pm	469	Running
Avril	3pm	3	Running
Avril	4pm	455	Swimming

If I graphed this data in Spotfire with "Activity" on the horizontal axis and calories on the vertical axis (aggregating by min), I would see a value of 3 for running and 95 for swimming.

But, what I really want is the visual to be of the average minimum (the minimum per participant averaged) of people in this study.

The min for each participant averaged is 88 for running and 189 for swimming (see below):

	Min
	running	swimming
John	141	95
Susan	185	232
Lee	22	200
Avril	3	228


	running	swimming
Average Min	87.75	188.75

Is there a way to create an expression to plot this in Spotfire? CUrrently, if I choose min as an aggregation, it will just give me the min across all bins. I need to take the min per person and then average it.

My real dataset has 120 people, maybe 30 activities and 300 to 4000 rows per person.

Thanks in advance,

Brian

Search results matching tags 'filter', 'join expression', 'custom column method', 'x axis', 'Data Table', 'cross table', 'charts', 'calculated column', 'table plot', 'edit data cell', 'selected', 'countif', 'Script', 'AnalysisApplication', 'visualization', and 'Spotfire 3.0'

Can someone assist - new to Spotfire and looking to create an "average min" expression