Calculated measures linked to the page filter

Questions & Answers
,
1

Hi,

I am fairly new to EazyBI and I amtrying to create a chart displaying the evolution of due dates in time, using this as a calculated measure :

NonZero(Count(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  -- Issues due in period
  DateInPeriod(
    [Issue].CurrentMember.get('Due date'),
    [Time].CurrentHierarchyMember) 
)))

It works fine when applied to the whole project but when I add the “Issue Type” in the “Pages” area in order to filter the issues, the filter does not apply to my measure like it does for the core measures (like Issues created or Issues closed).

I’m obviously missing something here but I cannot figure out how to make it work, I was hoping someone could shed some light on it :slight_smile:

Best Regards,

2

Hi @Florent,
Welcome to the eazyBI community! :wave:

Your calculation is missing a measure by which to count the issues and what would give it a context. From the formula, it looks you don’t need to have this calculated measure but instead you can use eazyBI predefined measure - Issues with due date. It shows all issues (both due and resolved) which have a due date specified. On the Time dimension grouped by issue due dates.(see more on the explanation of predefined measures - https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/jira-core-measures-and-dimensions#JiraCoremeasuresanddimensions-Measures).

About having measures in your report you can check my presentation Jira Admin’s Journey to eazyBI from our Community Days to learn more - Presentation slides and videos from eazyBI Remote Community Day - May 14, 2020

best,
Gerda // support@eazyBI.com

3

Thank you Gerda,

That’s indeed what I was looking for, although I have to replicate this on other custom field dates, is there a way to display the code behind core measures like this one ? There is no “show” button next to these ones.

I will check out your presentation.

Regards,

4

Hi @Florent,
If you import those date fields in data source import then you will have measures like Issues with custom date that will be linked to Time dimension by this custom field’s date. See more here - https://docs.eazybi.com/eazybijira/data-import/custom-fields#CustomFields-Measureswithcustomdatefields

best,
Gerda // support@eazyBI.com

5

Thank you,

You are right and I completely missed that. Like you said in your presentation, I tried to go into MDX straight away, missing out on the plethora of predefined measures available right under my nose.

Best regards,

1 Like
6

Welcome :slight_smile:

Btw, if you are just starting to use eazyBI I would also recommend you to check the training videos that we recently released - https://docs.eazybi.com/eazybijira/learn-more/training-videos
The videos go through report creation and show different tips & tricks that are available in eazyBI before digging into MDX.

best,
Gerda