topic Re: Create table for all values matching only 1 comparison field value in App Development

Create table for all values matching only 1 comparison field value

dmanbbg24 — Sat, 16 Nov 2024 21:24:32 GMT

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.

Re: Create table for all values matching only 1 comparison field value

sunny_talwar — Thu, 14 Feb 2019 13:09:15 GMT

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?

Re: Create table for all values matching only 1 comparison field value

dmanbbg24 — Thu, 14 Feb 2019 13:10:56 GMT

sorry, fixed that now

Re: Create table for all values matching only 1 comparison field value

sunny_talwar — Thu, 14 Feb 2019 13:21:01 GMT

How about this

=Aggr(Only({<field_counter = e({<week_num -= {'$(=MaxString(week_num))'}>} field_counter)>} field_counter), field_counter)

Re: Create table for all values matching only 1 comparison field value

dmanbbg24 — Thu, 14 Feb 2019 13:30:20 GMT

great, thanks, that produces the same output