Filter report by specific Labels

Questions & Answers
1

Hi,

I’m quite new to eazyBI and am currently struggeling with one report.

I want to have a report (to shows remaining time estimates) which shall include all tickets except tickets which have specific labels set.

Current approach:

Aggregate(
Except(
[Label].[All Labels],
{
[Label].[Label_1],
[Label].[Label_2]
}
)
)

Example:
Ticket 1
Label_1 ; Label_3
Ticket 2
Label_1; Label_2
Ticket 3
Label_3; Label_4
Ticket 4

Only Ticket 3 and Ticket 4 shall be considered for the report.
Unfortunately the output of my current approach is emtpy and I couldn’t find a solution yet.

Many thanks in advance!

2

Solved via

Aggregate(
Except(
[Label].Members,
{
[Label].[All Labels],
[Label].[MoveRequest],
[Label].[RejectRequest]
}))

3

Hi @Martin

I am happy to see you found the working solution, however, I would recommend more stable syntax.

Aggregate(
Except(
[Label].[Label].Members,
{
[Label].[MoveRequest],
[Label].[RejectRequest]
}
)
)

It would aggregate members only on the “label” level in “Label” dimension. Then you don’t need to address the default member “All Labels” at all.

Martins / eazyBI

1 Like