topic Max Data within Set Analysis in App Development

Max Data within Set Analysis

gleybson_calyx — Thu, 05 Apr 2018 12:32:17 GMT

Hello people,

I would like to know how to do to return the max (Date) within Set Analysis.

In the image below I show that when selecting the pro product it shows the value and when it does not have product select (Imagem2) it does not bring.

exeples I've already tried:

sum ({<YearMessageDay = {'$ (= MAX (YearMessage))}}}} VALUE)

sum ({<YearMindDay = {"$ (= MAX (YearMindDay))"}>} VALUE)

Imagem1

Imagem2

Re: Max Data within Set Analysis

gleybson_calyx — Thu, 05 Apr 2018 12:55:55 GMT

sum( {<AnoMesDia = {'$(=MAX(AnoMesDia))'} >} VALOR )

sum( {<AnoMesDia = {"$(=MAX(AnoMesDia))"} >} VALOR )

Re: Max Data within Set Analysis

gleybson_calyx — Thu, 05 Apr 2018 14:38:53 GMT

Anyone have any suggestions?

Re: Max Data within Set Analysis

gleybson_calyx — Thu, 05 Apr 2018 15:03:49 GMT

Tabela			o que preciso
nome	dt	valor		nome	dt	valor
abacate	01/01/2018	10		abacate	02/01/2018	9
abacate	02/01/2018	9		abacaxi	04/01/2018	16
abacaxi	03/01/2018	15
abacaxi	04/01/2018	16

Re: Max Data within Set Analysis

gleybson_calyx — Thu, 05 Apr 2018 18:37:21 GMT

Funcionou assim:

FirstSortedValue({<Tipo = {'Entradas'}>} VALOR,-DATA)

Fica a dica!