Item Age by status in Scatter

We have three ‘In Progress’ statuses in our workflow of In Progress, Blocked, In Review. I want to show a scatter plot where a dot represents each item and it’s current age (no. of days since first going in progress). My data looks like so:

I want to get it to look like this chart - how would I do that?


In eazyBI, the scatter chart is intended for the use between two numeric values. Therefore, the closest workaround for your case is to translate the Issue status into numbers and then switch the report to the scatter chart:

I tried the following custom measure for that:

CASE [Status].[Status].getMemberNameByKey(
  [Issue].CurrentHierarchyMember.get('Status ID')
WHEN "In Progress" THEN 2

I used the following formula for the issue age calculation:

  [Measures].[Issue created date],

Now I can have the report with two numeric values and switch it to the scatter view:

I can adjust the X-axis with the proper min, max, and step value and include the legend in the X-axis title:

Please, find a similar example in our Demo account:

Janis, eazyBI support

1 Like

Thank you for your help :slight_smile: