Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got an expression problem I'm looking for some help with.
My data looks like:
field_counter|week_num
z |4
x |4
y |3
x |3
y |2
x |2
y |1
x |1
New week data is continually added. I want to create a table filtered for those fields appearing in the +latest week only+, i.e. newly used fields. In the above case that would be 'z'.
I can get a count using:
Count({<field_counter = e({<week_num -= {'$(=MaxString(week_num))'}>} field_counter)>} DISTINCT field_counter)
And create a table filter using (where the latest week is '4'):
=aggr(if(match(week_num, '1', '2', '3')=0, field_counter),field_counter)
But I need to replace the hardcoded list of prior weeks with, essentially, 'all weeks that are not MaxString(week_num)'. Tried 'not match' and 'only' with no luck.
How about this
=Aggr(Only({<field_counter = e({<week_num -= {'$(=MaxString(week_num))'}>} field_counter)>} field_counter), field_counter)
Can you explain the highlighted part of the expression
Count(<field_counter = e({<week_num -= {'$(=MaxString(week_num))' <GO>>} field_counter)>} DISTINCT field_counter)
Is this expression even working for you?
How about this
=Aggr(Only({<field_counter = e({<week_num -= {'$(=MaxString(week_num))'}>} field_counter)>} field_counter), field_counter)