How to calculate Ageing in eazybi?

[Manoj]

Hi All, 

could you please help me to know how to find out ageing in eazybi? Please.

I have start date but there is no end date in some cases.

I have creation date, offered date and no end for few cases. 

when i measure creation date - Offered date = result whereas for no end i m facing issues. 

Please suggest. 

Thanks!

M

[Roberts Čāčus - eazyBI · Accepted solution]

Hi @Manoj 

As @Kat Jansen  already mentioned, you can try to use the DateDiffDays() function to calculate the difference in days between to dates or the date now. To use this calculation in case the end date is known, you can try to use conditions with CASE WHEN. See the example below:

CASE WHEN isEmpty([Measures].[Issue end date])
THEN
  DateDiffDays(
    [Measures].[Issue start date],
    Now()
  )
ELSE
  DateDiffDays(
    [Measures].[Issue start date],
    [Measures].[Issue end date]
  )
END

You can also have a look at the eazyBI Demo account. There are some useful report samples which you can export and import into your eazyBI - https://eazybi.com/accounts/1000/dashboards/4553-jira-issues.

Also, there is the possibility to enable the import of the issue Age interval dimension. Please have a look at how it would look like in a sample report in the eazyBI demo account - https://eazybi.com/accounts/1000/cubes/Issues/reports/50398-open-issues-by-age-interval-and-priority. And read more about it in the eazyBI documentation page - https://docs.eazybi.com/eazybijira/data-import/jira-issues-import#JiraIssuesImport-AdditionaldimensionsforusergroupsandIntervaldimensions.

Kind regards,

Roberts // eazyBI support

[Kat Jansen · Accepted solution]

You can use the DateDiff function with Now(). 

DateDiffDays(
[Measures].[Issue start date],
Now()
)

You can add whatever start date you need to. This isn't an aggregate, it works like any issue property. But you can use the aggregate functions like Sum and Average on it if that's your end goal.

I hope this helps.

-Kat Jansen