Filter users by ID in query form

[Pawel_Gorski]

I often get client requests to analyze specific group of employees selected only by their emails. The selection doesn't map to any combination of org dimensions, so it is not possible to select them using regular filters. It would be much helpful, if we could have a query filter based on a series of string values. It could work like the SQL's filtering:
WHERE EmployeeId IN ("ABC","DEF","GHI")

For my current case I need to select 450 employees from a list. Firstly, I query the whole 7k population and then choose my focus group. Not very efficient method, my initial queries are just unnecessarily big.

[Kevin_Corr]

Pawel - could you provide some examples of how the grouping is determined, and why there isn't an organizational dimension that can be used?

[Pawel_Gorski]

Hi @Kevin_Corr , I am getting back to my post after a while. It has not been a priority for some time, but still, I want to address it. I have two examples of customer's situtation.

1. In one of our analyses, we were focused on about 20 individuals, who held leadership positions. They were a mix of direct reports of a director and people who have dotted reporting lines. The latter are not formal, they are not reflected in any organizational data.
2. It is very often that extracting a certain group of employees who should be given licenses and analyzed, results in surprise from stakeholders: "oh, this is not our associate, this person has been in another department for three months.", etc. And then an ask follows: "Could we please set the Focus Group for the analysis manually?"

In the above examples it is all about compensating the data quality. The process of updating the Org File is really complicated and the team who does it is rather siloed. Asking them to update Org File with some flags "include/don't include" is a challenge. And a cumbersome process, in my opinion, as each analysis might require such filtering.

[Pawel_Gorski]

Hi @Kevin_Corr , any thoughts on the above? Is this something appearing in any customer/partner requests or @zbdrariI , @Roman_Suk_Ronny and @KamilaSalamonik are the only interested in the topic? 🙂