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

[elita_kalane · Accepted solution]

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.
​​If you have any follow-up questions regarding this, don't hesitate to reach out to us!
​
​Elita from support@eazybi.com

[Thejaswi S N]

Hi @elita_kalane 

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_kalane]

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.

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. 

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_kalane 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_kalane]

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_kalane 

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

[Oskars Laganovskis]

Hi @Thejaswi S N ,

Please contact us over e-mail and export and send the definition of your dashboard to see the full context.

Regards,

Oskars / support@eazyBI.com

[Thejaswi S N]

Hi @Oskars Laganovskis 

I have moved out to a different Team.

Thanks to you and the team for helping us. Much appreciated.

Regards,

Thejaswi

[elita_kalane]

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_kalane 

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