How to count how many sprints it took complete a story - have a Sprint Count dimension

Questions & Answers
1

I need to create a calculated member inside the Sprint Count Dimension.
This is one of the ways I’ve tried to do this:
Aggregate(
Filter(
[Sprint Count].Members,
[Sprint Count].CurrentMember.value=1
)
)

I don’t know what I am doing wrong even after pouring through the online documentation.

2

Hi @rebeccapavelka,
Welcome to the eazyBI Community!

What is the custom field type for your “Sprint Count” field in Jira?
If you have imported it as a dimension, then you can create a simple report using the dimension and measure “Issues created” to see how many issues are per each custom field value:

image
image1038×1116 56.2 KB

If you are new to eazyBI, I suggest checking out those short training videos that cover basic terms and functionality of eazyBI: Training videos

Best,
Gerda // support@eazybi.com