Need calculation syntax for a few Measures

Questions & Answers
2

Hi @H_B

Welcome to our community.
Let me help you with your questions

  1. try the approach described in another community post to filter the report by last 5 sprints
    Filter your eazyBI for last 5 closed sprints

  2. for calculated members you can always explore our Demo account:
    https://eazybi.com/accounts/1000/cubes
    It has a lot of good examples for calculated members

  3. Here you would need a calculated measure that iterates through Issues dimension members to find issues that were removed from the sprint

     NonZero(

    SUM(
    Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    [Sprint].CurrentMember.Name = [Measures].[Issue sprints]
    AND
    [Measures].[Sprint Issues committed]>0
    ),
    [Measures].[Sprint Story Points committed]
    )
    )

Don’t forget to enable “Nonempty” cross join when selecting this calculation.

image
image2092×978 191 KB

  1. To add cumulative calculations try using standard calculations for a measure.
    https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure

  2. Please find how to export eazyBI reports
    https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Savereportandtoolbarbuttons
    Also, don’t miss the feature to subscribe for dashboards and receive dashboard in PDF file automatically to your email address on a regular basis.
    https://docs.eazybi.com/eazybi/publish-reports/create-dashboards#Createdashboards-Dashboardemailsubscription

  3. Unfortunately, you can not change the font type or color in eazyBI reports from UI.
    The only customization can be done with font size.
    https://docs.eazybi.com/eazybi/analyze-and-visualize/create-charts#Createcharts-Datalabels

Martins / eazyBI team