This image show currently [Measures].[Creative - Brand Selection(s)]. This is a multiselect field with a number of options. For some other measures we would like to make we need to know how many options were selected. I have tried using Count, but as it is just a string being returned the count is 1. Any help on this would be appreciated
I have the project named INT: …, in which it has the history KN-1699, in turn, this history has 4 subtasks. Within those 4 subtasks, there is a subtask that has the name block (but that in Jira has the subtask format), that ticket would be the KN-1920.
What I am looking for is to be able to differentiate between subtasks as such and block subtasks by means of the measure you put in the comment above. That is to say, to have a column with the number 3 and another column with the number 1 (which in total gives 4 that gives me the measurement that you gave).
This use case is different as you woudl like to group data first by some attributes and then count them. Simple counting by commas without any further context of each item in the field won’t work.
Check out this community post on how to create new dimension from Summary:
Check out this community posts on counting subtasks and grouping them by some attributes:
If “Block” is already a specific issue type for sub-tasks, then this information is already available in eayzBI. Check the “Issue Type” dimension.
In the report, use the “Issue” dimension Sub-task hierarchy on report rows and measure “Issue created” showing how many subtasks and issue itself are created for each row.
To get sub-task count by issue type (including sub-taks issue type), click on measure “Issues created” and chose the option Drill into >> Issue Type >> Issue Type (see documentation Create reports - Drill into measure by another dimension level).
Then you can adjust which issue types you would like to see on report columns:
Or you may create a calculated measure using tuple expression as described in this community post: