Hi @Nasser,
the Last value
operation will retrieve the exact last bucket value as is.
You can leverage the Filter by
feature in the Add advanced options
, asking for only existing values for that field.
For an depth guide you can check this article: Dec 4th, 2021: [en] Advanced trick and tips in Lens