Hi everyone!
This app is made for flower industry
Not sure what is the best way to achieve my goalโฆ
a little contextualization:
Variedad= flower type
Cama= Bedโ>where the flowers are planted ( one flower type per bed)
Bloque= Group of beds (in one โbloqueโ can be planted diferent type of flowers)
Fecha estimado=Date when the person did the estimate
when a flower type is near to be cutted because is ready, a person stands next to the bed and estimates the amount of flowers that they can get from that specific bed.
this process can be done up to 10 times and in everytime the person can estimate a differente amount.
thatยดs why i need only the last estimate record of that especific bed.
then when i have the information filtered(without the duplicates , only the information with the recent estimation date ) i need to show the type of flower (variedad) and group of beds(bloque) in a calendar.
Thank you very much!
Solved! Go to Solution.
Is this the row with the latest Fecha estimado for its particular Variedad, Bloque, Cama combination?
ISBLANK(
FILTER(
"table",
AND(
([Variedad] = [_THISROW].[Variedad]),
([Bloque] = [_THISROW].[Bloque]),
([Cama] = [_THISROW].[Cama]),
([Fecha estimado] > [_THISROW].[Fecha estimado]),
)
)
)
replacing table
with the name of the table.
Is this the row with the latest Fecha estimado for its particular Variedad, Bloque, Cama combination?
ISBLANK(
FILTER(
"table",
AND(
([Variedad] = [_THISROW].[Variedad]),
([Bloque] = [_THISROW].[Bloque]),
([Cama] = [_THISROW].[Cama]),
([Fecha estimado] > [_THISROW].[Fecha estimado]),
)
)
)
replacing table
with the name of the table.
Thank you Steve !
it works
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |