set analysis max export date

martapardo — Tue, 21 Dec 2021 21:30:18 GMT

Hi, I have a sheet which will have 3 tables and two of them should take data belonging to the maximum export date and the other the other one all the data not filtre , I was trying in each measure do set analysis filtering by this condition, since I have the max(export date) as a variable saved previously but it is not working.

The code is :

=aggr(count(DISTINCT {<curso_PORCENTAJE = {'1'}, curso_Fecha_exportacion = {'Fecha_max_exportacion_1'}>} curso_Usuario), curso_curso_nombre)

The important notation is:

curso_fecha_exportacion = export date of each raw in my table

Fecha_max_exportacion_1 = maximum export date of all table(I have already compute in the data model)

and before it was like that , it was working perfectly:

=aggr(count(DISTINCT {<curso_PORCENTAJE = {'1'}>} curso_Usuario), curso_curso_nombre)

I have trying xtracting the month since the only thing that it changes is the month not the year but still not working I have try also setting Date(export_date) because I though it could be the format but still not working...

Re: set analysis max export date

sunny_talwar — Thu, 06 Jun 2019 11:41:54 GMT

Would you be able to share a sample to show the issue?

Re: set analysis max export date

JordyWegman — Thu, 06 Jun 2019 13:43:57 GMT

HI Marta,

What is the output of the 'Fecha_max_exportacion_1'? Is this a field, variable or an attribute of a field?

You can try $(Fecha_max_exportacion_1).

Jordy

Climber

topic Re: set analysis max export date in App Development

set analysis max export date

Re: set analysis max export date

Re: set analysis max export date