-
Re: Average Maximum in Expression Calculation
Stefan Wühl Feb 14, 2012 7:16 PM (in response to David Nelson)How are add_date and update_date related? Do your tables look like this (linked by customer):
LOAD * INLINE [
Customer, add_date
A, 11/7/2011 9:56:21 PM
B, 11/8/2011 9:56:21 PM
];
LOAD * INLINE [
Customer, update_date
A,11/15/2011 6:12:16 PM
A,11/15/2011 4:46:01 PM
A,11/15/2011 3:19:17 PM
A,11/15/2011 1:07:36 PM
B,11/15/2011 6:12:16 PM
B,11/15/2011 1:07:36 PM
];
What is your dimension in the chart? I've tried with Customer, but the expression you posted above does not work. I also do not understand why it calculates the average min interval. Surely I don't really understand your setting.
It tried with above tables and created a chart with dimension Customer and then used:
= avg(aggr(interval(Min(update_date)-only(add_date),'DD'),Customer))
resp.
= avg(aggr(interval(Max(update_date)-only(add_date),'DD'),Customer))
which seem to calculate what I would assume as average min and max intervals (average over Customer in the chart total).
See also attached.
Regads,
Stefan
edit: corrected aggr dimension list
-
comm47283.qvw 150.0 K
-
Average Maximum in Expression Calculation
David Nelson Feb 15, 2012 9:40 AM (in response to Stefan Wühl )The main problem was the correct syntax for the expressions. I'll try using your examples above today and see what's what.
-
Average Maximum in Expression Calculation
David Nelson Feb 15, 2012 3:39 PM (in response to Stefan Wühl )That's the syntax I needed, thanks a bunch.
-