I have a user defined measure to calculate hours spent on specific issues which contain a particular string on summary, and it works. However, when I use that same code to just modify to count the resolved issue, it returns nothing.
Here is the workable one for hours spent:
[Issue].CurrentHierarchyMember.Name MATCHES “.project support.” OR
[Issue].CurrentHierarchyMember.Name MATCHES “.Project Space, Service and Support.*”
), [Measures].[Hours spent with sub-tasks]
And here is the one that not working:
[Issue].CurrentHierarchyMember.Name MATCHES “.project support.”
Could not figure out what is wrong.
Screenshot to show the one work while other not:
First, you should check if your MATCHES expression is correct and returns any result. In the first calculation, you have two MATCHES and it could be that the first one doesn’t return any result?
See related regular expression documentation page: Regular expressions
Following is an answer to a similar question that could work also in your use case:
After importing this dimension, you can use it to create a tuple with the measure “Hours spent with subtasks” and second with “Issues resolved”:
([Measures].[Hours spent with sub-tasks], [Issue summary Developer].[true])
Hi @gerda.grantina ,
The context is: I need to count the concurrent projects in a given time an admin worked on (per week).
I supposed to count the number projects a given admin worked on by determine which project that he had issue with his time spent on, then I can do a SUM to determine how many projects he worked on concurrently at that given time.
As long as admin A spent time in issue Y under project X, in the week Z => I will count A has 1 project in week Z. Ultimately, I will SUM all of them to calculate how many projects in total for A in the week Z he worked on.
this code counts the issue with timespent >0 in its lifetime, whereas I only want to count issue by 1 in particular weeks that given admin spent time on. Otherwise, it should return 0.
This code counts all the issues with timespent >0 in a project, whereas I only wanted to count the number of project actually. Example: if admin A worked on 3 issues in project X => this will count as 3, but actually I only wanted to count as 1 project.
Could you please help?