I have a table comparing various outputs of teams. Eg. Activity Types.
Each ‘team’ is just a ‘Project’ in EazyBI - nice and easy.
Except one project, which is many teams. I’m only interested in displaying one of these teams for this example.
So, I have a ‘Project’, and within that project there are 3 teams defined in the ‘Team’ field, called ‘UI’, ‘UX’, ‘Design’. I only want the Design Team to be displayed in this table.
If I filter/page on the ‘Team’ = ‘Design’, then all the other Projects come up blank.
So, is there a way to specify a table which contains all Projects, but one of those projects is filtered on ‘Team’?
To add to the complication, a small number of the ‘Projects’ have the correct ‘Team’ assocaited, some are blank (which is why I’m filtering on ‘Project’ rather than ‘Team’). i.e., For the ‘Financial’ ‘Project’, some of them have ‘Team’ as ‘Financial’, and some have it (none).)
Hi,
If I’m being honest, the more accurate the data and workflow, the more accurate reports you can expect.
But, of course, there is a way to create custom calculations for this scenario.
Instead of useing the starndart measure (for example to count issues created) “issues created” you can create a calculated measure that knows how to handle the specific case.
That would count issues created differently for other projects where the Team field is not used.
Try this formula (where you must provide the correct project key for that one project which should be filtered by the selected “Team” page filter)
Sum(
DescendantsSet([Project].CurrentMember,[Project].[Project]),
CASE WHEN
[Project].CurrentMember.key = "D11" --key of project with Team field
THEN
[Measures].[Issues created]*1
ELSE
(
[Measures].[Issues created],
[Team].CurrentHierarchy.DefaultMember --to ignore page filter or other projects
)*1
END
)
And manually select “integer” output format for this calculated measure.
Another approach could be defining a new calculated field that creates new team values from Projects and Team field combined into a new eazyBI dimension. Then, import this new dimension and use it as a page filter, which would behave like a combined dimension from the Project and Team fields.
