Hello!
“How can I create a metric in eazyBI that considers all labels except those starting with ‘GV’?”
Hello!
“How can I create a metric in eazyBI that considers all labels except those starting with ‘GV’?”
You can do the following:
In the Label Dimension, create a new Calculated Member:
Aggregate(
Except(
[Label].[Label].Members,
Filter(
[Label].[Label].Members,
[Label].CurrentMember.Name MATCHES 'GV+'
)
)
)
When selected, this will return all Labels that don’t start with GV
Hello @Viviane_Da_Silva_Mor,
The Labels is a multi-value dimension that has some implications in cases of overlapping selections.
Multiple solutions are only relevant to specific use cases.
The flexibility provided by free-text fields in Jira leads to some complexity in processing that data in reports. Please share more details about your ultimate use case to suggest the most convenient approach.
Regards,
Oskars / support@eazyBI.com