Latest available data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I need to select the last year and the last month avaibles when I reset the filters.

The system data is updated automatically, so when I open the file, or when I reset the filters, I would see the latest data.

I can't use:

because I couldn't have this month's data, but maybe I have the data of the previous month.

How can I do this?

Last thing, years are numeric value, but months are a string value.

Thanks.

Re: Latest available data

jduarte12 — Mon, 02 Oct 2017 10:36:31 GMT

Hi,

Try creating a new field yearmonth (e.g., today, the year-month would be 201710) and the select max(yearmonth).

Regards,

João Duarte