topic Re: Set analysis - Find Current Location of employee Based on Current Designation in App Development

Set analysis - Find Current Location of employee Based on Current Designation

pratham39 — Fri, 04 Nov 2022 08:24:36 GMT

Hi,

I have below table on frontend ,

the Green one is current location of employee based on max number of Designation No which is 13,

So basically in Current Location Column that value should come (Allahabad_W_EC)

Please help me to write set analysis for Current Location....

Thanks

#SetAnalysis

BrunPierre — Fri, 04 Nov 2022 09:17:42 GMT

As below with set analysis

Only({$<[Designation No]={"$(=Max([Designation No]))"}>} [Location Area])

pratham39 — Fri, 04 Nov 2022 10:17:36 GMT

Hi,

Thanks for reply,

Your solution is working perfectly fine for any single employee ,

but in overall table for all employees it is only showing Max DesignationNo Location

The Red one in below table should show location Mumbai but as it is taking max ID - 13 as per your expression

it won't show Mumbai

Please help

Thanks

BrunPierre — Fri, 04 Nov 2022 10:31:38 GMT

Try this

Aggr(FirstSortedValue([Location Area], -[Designation No]), [Employee No])

pratham39 — Fri, 04 Nov 2022 10:47:00 GMT

It worked!

Thanks