nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Display current Sprint in eazy BI dashboard

Thejaswi S N

Hi,

Please help me in displaying the ongoing Sprint (say Sprint 1 or Sprint 2 ...) in eazy BI dashboard. It should look similar to the snapshot below.

Under Sprint check. the ongoing Sprint Sprint (1 or Sprint 2 )should be displayed.

Thanks,

Thejaswi

Accepted answers

Elita Kalāne - eazyBI Support

Hi @Thejaswi S N

Thanks for sending in your question.

I recommend doing the following steps:

Create a new calculated measure with the following formula. If there are multiple active sprints, all the active sprints will be listed. More details on Generatel() function can be found here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/generate

Generate(
  Filter(
    DescendantsSet([Sprint.By status].[Active],[Sprint.By status].[Sprint]),
    [Measures].[Issues created]>0
  ),
  [Sprint].CurrentHierarchyMember.Name,
  "; "
)

Attached is a screenshot of how this solution might look. eazyBI-Active Sprints-Gauge.png
If you have any follow-up questions regarding this, don't hesitate to reach out to us!

Elita from support@eazybi.com

All comments

Elita Kalāne - eazyBI Support

Hi @Thejaswi S N

Thanks for sending in your question.

I recommend doing the following steps:

Generate(
  Filter(
    DescendantsSet([Sprint.By status].[Active],[Sprint.By status].[Sprint]),
    [Measures].[Issues created]>0
  ),
  [Sprint].CurrentHierarchyMember.Name,
  "; "
)

Thejaswi S N

Hi @Elita Kalāne - eazyBI Support

Thanks for your answer.

I created a new measure with the above code and see nothing coming up under Active sprints

Can you please re-check from your end once

Regards,

Thejaswi

Elita Kalāne - eazyBI Support

Hi @Thejaswi S N

Thank you for following up with me! From the screenshot you sent, I don't see what you have selected in your Rows and Pages, therefor I recommend first verifying what your active sprints are, to know which sprints the calculation should return.

To do that, add your Sprint dimension in Rows and Pages. In Pages, select Hierarchy level member - "By status" -"Satus" and in the filter, select "Active".
In Rows, select the same Hierarchy level member - "By status", but choose member "Sprint", to display the active sprint names.
See the screenshot below with the selections highlighted.

eazyBI-Active Sprints.png

I have also amended the formula I sent you previously, removing the filter which was in the calculation. It could be that the filter function was the reason no data was returned for you.

Generate(
    DescendantsSet([Sprint.By status].[Active],[Sprint.By status].[Sprint]),  
  [Sprint].CurrentHierarchyMember.Name,
  "; "
)

Here in the screenshot below, I have selected "Time" in rows using the formula I wrote above and you can see it returns the same list of Sprints as in the first screenshot when I verified which are my active Sprints.

eazyBI-Active Sprints-Gauge.v3.png

If still no results are returned for you, please advise (or send a screenshot) what you have selected in Pages and what is currently added/selected in your report Rows.

Best wishes,

Elita from support@eazybi.com

Thejaswi S N

Hi @Elita Kalāne - eazyBI Support Apologies for late response as I was away for a long time.

It's working fine now. Since there are many workstreams and many Sprints under each of the workstreams, all the active Sprints are displayed. For example, if the active Sprint is Sprint 4, it should only display Sprint 4 instead of D1 Sprint 4, D2 Sprint 4 and so on.

Elita Kalāne - eazyBI Support

Hi @Thejaswi S N

Can you please clarify what you mean by workstreams? How do you differentiate them? Is it a different Project? A different Board?

Based on your requirement, I could help amend the formula to return a specific active Sprint.

It would be easier to understand your use case and help come up with a solution if you could share your report definition (by sending it to support@eazybi.com).

Instructions on how to export the report definition.
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions

Best wishes,

Elita from support@eazybi.com

Thejaswi S N

Hi @Elita Kalāne - eazyBI Support

I was mentioning about different projects as workstreams.

For example, I have Project A, Project B & Project C.

In Project A, there are 3 boards say Board 1, Board 2 & Board 3. All 3 boards are currently in Sprint 3.

Similarly, there will be multiple boards for Project B & Project C.

I want to display only Sprint 3 instead of Board 1 Sprint 3, Board 2 Sprint 3, Board 3 Sprint 3 and so on..

Hope, it clarifies your doubt.

Regards,

Thejaswi

Elita Kalāne - eazyBI Support

Hi @Thejaswi S N

Apologies for the delayed response, and thank you for sending additional information!

Could you please try the formula below and see if it returns the expected results for your data? The formula will work if you have your Sprints named "Sprint 1", "Sprint 2", "Sprint 3"..etc

Generate(
  Tail(Filter(
   [Sprint].[Sprint].Members,
   [Sprint].CurrentMember.Get('Status') = "Active"
   AND
   [Measures].[Sprint issues committed]>0
  ),
  1),
  ExtractString([Sprint].CurrentHierarchyMember.Name, "Sprint.*",0),
  ","
)

Best wishes,

Elita from support@eazybi.com

Thejaswi S N

Hi @Elita Kalāne - eazyBI Support

Apologies again for my late response.

The formula will display the active sprint for all projects. Example: Project 1 Sprint 4, Project 2 Sprint 4, Project 3 Sprint 4 and so on. I just wanted to display Sprint 4.

No worries. I'll try other options.

Happy Holidays!

Regards,

Thejaswi

Oskars Laganovskis

Hi @Thejaswi S N,

The latest expression (Mar 27) returns the name of just one sprint and just the latter part with "Sprint" and the number. The outcome is one name even for multiple projects/boards/etc. selected.

Please share some more details or screenshots if this expression still returned multiple sprint names.

Regards,

Oskars / eazyBI support

Thejaswi S N

Hi @Oskars Laganovskis

Please find the screenshot

We have different naming patterns for a Sprint and I just want to display the active Sprint. In this case, it should be Sprint 4.

Regards,

Thejaswi

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

eazybi