Hi community,
My report Rows contains 2 Custom Members:
Issuetype = Subtask
Custom field = myCustomValue
The report Pages contains Project and then Sprint so that I can view this report per Sprint per Project.
I have created 1 Custom Measure for my report that sums up the Total Time (from the Time tracking field) for the Subtasks in my report that have this Custom field set to myCustomValue and it uses the statement: [Measures].[Hours spent].
This is working perfectly, but I wanted to add a “Number of instances” Custom Measure as the 2nd column in the report, which counts the number of records returned by the “[Measures].[Hours spent]” measure. Is there a method in eazyBI to count the data set returned by a measure?
[Measures].[Issues created] will work most of the time but if the Subtask is moved into another Sprint, then both measures will have a different context (i.e. the Time value will belong to the previous Sprint, but the “Issue created” count will now belong to the new Sprint).
Any ideas would be most helpful.
Thanks.