Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

Boss/employee segmenter

Good morning, I have the following problem. I have a table with user code, name and boss code. I want to generate a segmenter that allows me to select a name and bring me the data of that user and al...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
9 months ago

Hi,

The PARCHCONTAINS() function should work.  For more specific help, share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
8 months ago
EventEvent DescriptionSorterClassification StatusResearchResearch LeaderResearch StatusActionAction Description ResponsibleStatement of Action
1-200Classified1201Investigated1-202Made
1-200Classified1201Investigated2-200Made
2-201Not Classified
3-202Classified3200Not Investigated
4-200Classified4201Investigated3-202Made
4-200Classified4201Investigated4-202Earring
4-200Classified4201Investigated5-201Earring
5-201Classified5202Investigated6-200Made
5-201Classified5202Investigated7-200Made
5-201Classified5202Investigated8-201Made
5-201Classified5202Investigated9-202Earring
5-201Classified5202Investigated10-200Earring

User CodeUserBoss Code
200So-and-so-
201Stuttgart200
202Pepito201

Due to confidentiality issues I cannot upload the original tables. By way of example, these would be these. The objective would be if I select So-and-so to see all the data in three different visuals one for events, one for research and one for actions, if I select So-and-so to see only his data and Pepito's. And finally, if Pepito was selected, only see his data.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    8 months ago

    Sorry for the data in this way but it did not let me load excel or power bi.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 months ago

    Sorry but cannot understand anything there.