topic Re: Craziest Set Analysis Yet (Only Experts) in App Development

Craziest Set Analysis Yet (Only Experts)

Mario_ES — Thu, 23 May 2024 15:20:54 GMT

Hello,

I'm trying to filter lines of a table that has multiple dimensions and only one expression that I use for filtering.

The field's values are something like this:

And the end product has to be something like this:

I believe that the correct expressión is this one:

Count ( Distinct {<form_order={"max(<[No. Proceso]>form_order)"}>} [No. Proceso])

Do you have any idea why this isn't working?

Thanks!

Re: Craziest Set Analysis Yet (Only Experts)

MatheusC — Thu, 23 May 2024 18:52:38 GMT

Maybe this:

For your form_order dimension form_order :

=AGGR(max(form_order), [No.Proceso])

to your measure:

=count(Aggr(FirstSortedValue([No.Proceso],-form_order),[No.Proceso]))

Regarts, Matheus

Re: Craziest Set Analysis Yet (Only Experts)

marcus_sommer — Fri, 24 May 2024 05:50:59 GMT

Your max-condition isn't evaluated else taken as a search-string. Therefore try it in this way:

Count ( Distinct {<form_order={"$(=max(<[No. Proceso]>form_order))"}>} [No. Proceso])

Re: Craziest Set Analysis Yet (Only Experts)

Mario_ES — Fri, 24 May 2024 11:16:28 GMT

Thank you very much for your answer.

I think that it shouldn't be evaluated.

Look at the screenshot:

In the dialog, you can see that it doesn't find the max form_order because there are many No. Proceso at the same time.

With this formula, I get no results even though I haven't filtered the information on any field:

You can try it in your QS if you want.

Re: Craziest Set Analysis Yet (Only Experts)

TauseefKhan — Sat, 25 May 2024 04:52:32 GMT

Hi @Mario_ES,

Result:

form_order =
Count( Distinct {<form_order={"=max({<No_Procesol= >} form_order)"} >} form_order)

Count =
Count( Distinct {<form_order={"=max({<No_Procesol={$(=max(No_Procesol))}>} form_order)"}>} No_Procesol)

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.

Re: Craziest Set Analysis Yet (Only Experts)

BrunPierre — Fri, 24 May 2024 15:17:07 GMT

As below.

Count(DISTINCT If(form_order=Aggr(Max(TOTAL<[No. Proceso]>form_order), form_order, [No. Proceso]), [No. Proceso]))