How can I calculate the site number that the state begin by 5 and finish by 7

[suzel404]

Hi all,

How can I calculate in straight table the site number that the state begin by 5 and finish by 7 ?

I want all the site that the state begins  by 5 and finish by 7 : like the site 15614.

Thanks for your help.

[maxgro]

in a str tab chart

dimension     SITE_ID

expression    

if(subfield(concat(distinct STATE_ID, '@', DATE_FROM), '@',1)=5

and subfield(concat(distinct STATE_ID, '@', -DATE_FROM), '@',1)=7,1)

[suzel404]

Thanks Massimo,

It is possibe to count that in a text object ?

[maxgro · Accepted solution]

maybe using aggr at SITE_ID level

=sum(aggr(

if(subfield(concat(distinct STATE_ID, '@', DATE_FROM), '@',1)=5

and subfield(concat(distinct STATE_ID, '@', -DATE_FROM), '@',1)=7,1)

,SITE_ID))

[suzel404]

Thanks you very much for your reactivity.