topic Re: set analysis for a dimension in App Development

set analysis for a dimension

Amiran — Tue, 08 Dec 2020 11:25:00 GMT

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 — Tue, 08 Dec 2020 11:39:30 GMT

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

Amiran — Tue, 08 Dec 2020 12:45:29 GMT

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 — Tue, 08 Dec 2020 13:00:09 GMT

@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 — Tue, 08 Dec 2020 13:11:59 GMT

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)