Hi,
Just wondering how can we remove the “none” value here:
Hello @jemelyn_may_hipona !
Use AGGREGATE in conjunction with EXCEPT.
See here more details: Except
Edit your “Remove (none)” calculated member in “How did we do?” dimension to something like:
Aggregate(
Except(
[Issue Type].[Issue Type].Members,
{[Issue Type].[Sub-task],
[Issue Type].[Integration Subtask]}
)
)
The chart should look like this (make sure you select your calculated member):
Hope it helps!
VasileS.
Should work the same as described… add a new calculated member in your “Source” dimension.
For “testing” purpose switch your chart to table view:
To add a calculated member you need “Reports admin” access rights to your account:
Kind regards,
VasileS.