topic Re: Filtro Ano traz valor zero in App Development

Filtro Ano traz valor zero

MatheusC — Mon, 26 Sep 2022 12:54:10 GMT

Hello,

I am using this expression below, it will return the customer who did not buy in a certain period (Current year), it is showing me the value. But when I filter or period of the current Year it returns the value zero.

Count( {$< GroupTest = E({1<Annotate={"$(=Max(Annotate))"}>})>}distinct GroupTest)

But when I filter or current year period it returns zero value. It should return the value of customers that left the current one, even when it's unfiltered.

Any help on how to solve it will be appreciated, thanks in advance!

Re: Filtro Ano traz valor zero

MatheusC — Mon, 26 Sep 2022 19:58:20 GMT

Hello. Community

After a few attempts I managed to bring it in the way I needed, I'll leave my solution in case it can help someone else who also needs to reach a similar result.

Yours sincerely, @MatheusC

count(distinct

Annotate ={"$(=Max(Annotate)-1)"},

GroupTest =e({<Annotate ={"$(=Max(Annotate))"}>} GroupTest)

GroupTest)