How to create gauge graphs that group issues based on their due_date

Questions & Answers
1

Hi
I am new with easyBi, and I need to create gauge graphs to group issues with due_date within the next 30 days, 60 days, 90 days, and so forth.

Can you guide me on how to implement that?

I created a user-defined calculated member DateDiffDays(Now(),[Measures].[Issue due date]) to calculate how many days are left from now to the due_date, but I don’t know how should I proceed from there.
Right now I have one graph for each issue but that is not what I want.

Thanks in advance.

2

Hi @Victor
If you want to create a measure that counts how many issues have a due date in the next 30, 60, and 90 days, you need to use descendants() in your formula and create one measure for each interval.
The due date in 30 days would be like this:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues with due date]>0
    AND
    DateDiffDays(now(), [Measures].[Issue due date])<=30
    AND
    DateDiffDays(Now(), [Measures].[Issue due date])>0
  )
)

In a similar manner, you can create measures for the next 60, 90, etc. days.

Also, you can explore custom JavaScript calculated field as an interval dimension, see an example here: JavaScript calculated custom fields

best,
Gerda // support@eazyBI.com