I have a column like this

```
User time  Column

User1 time1  44 db

User1 time2  55 db

User1 time3 43 db

User1 time4  no_available

```

How to calculate average, Min, MAX by just taking 44 55 43 (without db) and ignoring values like 'no\_available' and 'no\_power' for each user

Bonus, also how take last value of the day if user has for exemple 10 values for 10 times.

Regards,

thank you.