I have an expression which I use in a pivot table
avg(aggr(count(total customer_id), Adj_Date, birth_decade))
it at least gives me a value in each row (as opposed to the ubiquitous dashes), which equals the number of records in the resident table -- Note that Adj_Date is a floor'ed timestamp and birth_decade is a string between 190 and 200.
I've noted that if I try to use Set Analysis IN ANY WAY, it totally breaks the expression and results in dashes
e.g. <Adj_Date>, {<Adj_Date>}, {$<Adj_Date>}, <Adj_Date={'2009-12-15 0:00:00'}>, {$<Adj_Date={">max(Adj_Date)-6"}>} ...
?Has anyone had luck using Set Identifiers in AGGR expressions?
I need to know if they are mutually exclusive, so that I can start making a bunch of aggregated tables, (which of course ruins the QV ideal) that do what Set Analysis should do in this problem, instead of spending days and days chasing an imaginary solution.
Thanks in advance
Bob
