Calculated measure is not tallying up

GaetyonEazyBi · July 26, 2023, 5:07pm

I have tried so many iterations of this now and I’m just honestly tired. I have scoured the internet for a response but noting is working.
I have made some calculated measures and they work. Or at least they seem to work because when I try to tally them up they don’t work.

I think similarly to this issue Help. The sum of issues no showing in the calculated measure that I created

I tried everything but it’s not working can someone help urgently please?

This is the current code I have come to trying to do this.

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    Not IsEmpty([Issue].CurrentHierarchyMember.get('field_name'))
  ),
  CASE WHEN
    DateDiffDays(
      [Measures].[Issue due date],
      Now()
    )>90 
  AND 
    DateDiffDays(
      [Measures].[Issue due date],
      Now()
    )<180
  THEN 
    [Measures].[Issues created]
  END
)

GaetyonEazyBi · July 26, 2023, 5:08pm

Ultimately I’d like to get to this kind of visual.

@gerda.grantina @ilze.leite
Can one of you help perhaps?

GaetyonEazyBi · July 27, 2023, 10:35am

@ilze.mezite can you help?

GaetyonEazyBi · July 31, 2023, 1:53pm

@nauris.malitis @roberts.cacus Can you help?

GaetyonEazyBi · August 2, 2023, 9:37am

Can anyone help me? @eazyBI-Staff I have a deliverable today and still no help.

janis.plume · August 3, 2023, 10:01am

Hi,

Your formula should correctly calculate the number of issues with the due date between 90 and 180 days. The remaining part seems to be the correct design of the report.

As I can see from the image, the risks should be stacked by priority in the bar chart. Assuming the Priority dimension is used for the grouping, the bar chart could look like this:

You should create similar measures for other proximity ranges and add them to the report.

Kindly,
Janis, eazyBI support

GaetyonEazyBi · August 3, 2023, 10:24am

GaetyonEazyBi:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    Not IsEmpty([Issue].CurrentHierarchyMember.get('field_name'))
  ),
  CASE WHEN
    DateDiffDays(
      [Measures].[Issue due date],
      Now()
    )>90 
  AND 
    DateDiffDays(
      [Measures].[Issue due date],
      Now()
    )<180
  THEN 
    [Measures].[Issues created]
  END
)

Hi @janis.plume Janis, thank you for responding. For some reason, nothing shows up for me though. Using the formula I’ve used above, this is what I get

janis.plume · August 4, 2023, 6:31am

Hi,

You should expand the Priority dimension to the lower level and enable the stacked option in the chart:

Kindly,
Janis, eazyBI support