Create a New Dimension utilizing an existing dimension
I have a larger question that relates to this in the layout and visualization section of the community, but I was hoping to get some help with a direction that another user pointed me in.
So here is my situation.
I have a bar chart (stacked) with two dimensions. 1. Employee Name and 2. Project Stage.
I then have one dimension that averages each of my project stages stacks it into one column for employee name.
The issue that I am having is that some employees I would like to exclude from the list (no longer with us, new role, etc.)
The suggestion another user had brought up was by creating a new dimension that only includes the individuals I would like to look at and using this instead of my original Employee Name field. A sort of Employee Name 2.0 if you will. They also recommended that I convert the names I did not want included to null, which would then exclude from my reporting.
Re: Create a New Dimension utilizing an existing dimension
Thank you replying to my message.
I have not flagged them anywhere. There are several reasons I want to report on them in other areas (just not in these one chart). But, yes I would like to include only a select number of the employees (which is still the majority), and I would rather hide/exclude the others for the purpose of the story I am detailing in this report.
The flagging does seem like something I may want to do down the line to help signify management vs staff. However, for now I would like to simply include only the individuals of my choosing.
Of the above, which is the easiest/quickest to implement?