Hi guys, i've got a little bit problem by using aggr function, see my file pls, first.
There is a simple example with 5 records with the same value on field Codice.
I need to count the last one based on Data in monitoraggio in my formula(see the formula in bar chart).
I don't know why is not working well.....
I see only one record in bar chart(correct) but it should be the last one, not the first as it's.
Pls help me.
Thx a lot.
Near the bar chart there's the same in straight table format and i adde d calulcated dimension with my aggr function, the value of this dimension is correct, but the other dimension are related to the first record of my datas.....that's wrong for my target.
yes,it's seem to be the right way,but.....really i need to create a bar chart with esito as main dimension, the bar chart should show one bar with one value as count, but the esito dimension should be Chiusa,indeed, in my example, it shows Complessa Power.
so, may you change your example to gain this goal ?
now, pls help me to apply your suggestions to one more complex formula :
COUNT(distinct If(flag_tipo_vista = 'A' and az_tipo_sospensione<>'LAVORABILE'
and aggr(max([Data in monitoraggio]),Codice) <= date_hi and ([Data chiusura] > date_hi or ISNULL([Data chiusura])), Codice))
in substance, this one has two condition (flag_tipo_vista = 'A' and az_tipo_sospensione<>'LAVORABILE') and different conditions on the date fields (Data in monitoraggio<=date_hi) and condition on Data chiusura (>=date_hi or isnull())
my formula is the rappresentation of my wrong attempt to have the last record by using this formula....