Filter measures with subtask name and version

[alokh ram]

Hi,

I am pretty new to eazyBi. 

I wanted to filter all subtasks with a particular version and subtask name  includes "XYZ". How can i do this in eazyBi dashboards? 

I have defined a new calculated measure with issue type as subtask and version.

How can i include the subtask name contains "XYZ" also into this measure or maybe create a new measure ?

Please find the attached screen short 

Thanks,

Alokh R

[Oskars Laganovskis · Accepted solution]

Hi @alokh ram,
​
​If you need to filter out issues based on a loose condition with several possible members, a tuple will not work.
​In that case, you need to process the set of filtered issues.
​
​​The code fragment for filtering the set might be as follows.
​

Filter(
--generate set of issues
  DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--filtering conditions
 ([Measures].[Issues created],
  [Issue type].[Sub-task],
  [Fix version].[<path to specific version>]) >0
 AND
  [Issue].CurrentHierarchyMember.Name matches ".*XYZ.*"
)

​You might then process the filtered set by counting members, summing, or averaging necessary measures.
​
​Regards,
​Oskars / support@eazyBI.com

[alokh ram]

@Oskars Laganovskis Thank you for the response.

Can i create a single calculated measure under user defined measures option and include these code and it will work ? But in this case i am getting an error.

Please find the below screenshot what i have created and it works fine now.

In this case i have created 2 separate calculated member one for filtering fix version and issue type as sub task, and another for filtering the specific string.

Please let me know your thoughts 

[Oskars Laganovskis]

@alokh ram 
​
Since the ultimate application of the issue filter was not disclosed, ​the provided code fragment only filters the set of issues for further processing.

​If you try using it right away as a measure - it will throw an error as the expression returns a set of issues, not a measure.

To count the number of filtered issues, you might create a calculated measure in the Measures dimension with the following expression.
​

Count(<expression for the set of issues>)

​If you want to sum a measure related to these issues, for example, hours spent - the expression might be as follows.
​

​Sum(<expression for the set of issues>,
    [Measures].[Hours spent])​

There are countless options for further processing of the filtered set.

The best option for you depends on the report's context and your further plans for analysis.
​
​Regards,
​Oskars / eazyBI support

[alokh ram · Accepted solution]

Awaiting support