Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using the below set analysis to give me the number of departments without any employee where in the dept.city is LN or NY.
=count({<DEPT_ID=e({<E_ID={*}>}DEPT_ID),City={'NY','LN'}>}DEPT_ID)
However, while using the same expression in Charts, I am unable to make proper selection of dimensions.
Is there any alternate way to represent this without set analysis, so that I can use it in my charts?
Thanks,
Sindhu.
No, I'm afraid you're stuck with improper selections only.