Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
4 years ago
Solved

look up or filter data

Hello,   i have a table with several equipments. i want to get the first and the last value of the day for one equipment in the following table the green and orange value. but i'm struggli...
Need Help
  • GeekAlfPro's avatar
    GeekAlfPro
    4 years ago

    I finally manage to get what i want

    by using firstnonblankvalue and lastnonblankvalue.

     

    thanks !

GeekAlfPro's avatar
GeekAlfPro
Helper V
4 years ago

Hello tackytechtom ,

 

thanks for your response.

unfortunately, et because i wasn't explicite enough, it not exactly the solution.

i have outliers, that's why i want to get the first data of the day and the last one

 

your formulas give me the min and max of the values.

i want the values associated with the min / max of timestamp.

i hope i'm clear enough

GeekAlfPro's avatar
GeekAlfPro
Helper V
4 years ago

I finally manage to get what i want

by using firstnonblankvalue and lastnonblankvalue.

 

thanks !