set analysis for a dimension

[Amiran]

Hi,

I am trying to create a set analysis for a dimension where the final_net_wight is less than crop_forcast give me the grower names,

can anyone help me to find out what's wrong with this:

aggr(ONLY({<FINAL_NET_WEIGHT={"<CROP_FORECAST"}>}GROWER_NAME),GROWER_NAME)

[Taoufiq_Zarra]

@Amiran  can you share a sample data and the expected output ?

[Amiran]

Hi @Taoufiq_Zarra ,

here is a sample data:

data:
LOAD * inline [
grower_name, final_net_wight, crop_forcast
aa, 450, 500
bb, 351, 200
cc, 215, 100
dd, 231, 300
ee, 789, 500
ff, 654, 670
]

when using the set analysis I expect to have these values in the dimension:

aa,
dd,
ff

thank you

[Taoufiq_Zarra · Accepted solution]

@Amiran  you can for example use in dimension :

=aggr(only({<grower_name={"=final_net_wight<crop_forcast"}>}grower_name),grower_name)

and supress when value is null

like :

[Amiran · Accepted solution]

it works, thank you very much!

I had to turn nulls into 0 and to use sum()

=aggr(only({<GROWER_NAME={"=sum(FINAL_NET_WEIGHT)>sum(CROP_FORECAST)"}>}GROWER_NAME),GROWER_NAME)