topic Set Analysis on Dimensions in App Development

Set Analysis on Dimensions

linna — Thu, 09 Dec 2021 21:46:52 GMT

Hi All,

I am developing an app and wondering how should I do a set analysis on dimensions.

I have a filter field [Employee Name]

My table has fields [Employee Name], [Employee ID], [Supervisor ID], [2nd Supervisor ID]

How can I make the table show all employees if the filter selected value's corresponding Employee ID is within [Supervisor ID] or [2nd Supervisor ID]?

Thanks!

Re: Set Analysis on Dimensions

abhijitnalekar — Fri, 10 Dec 2021 07:23:38 GMT

Hi @linna,

Can you please explain the scenario with an example, table representation would be helpful

Re: Set Analysis on Dimensions

anat — Fri, 10 Dec 2021 07:49:10 GMT

can u try below calculated dimension...

if([Employee ID]= [Supervisor ID] and [Employee ID]= [2nd Supervisor ID],[Employee Name])