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.
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:
[Measures].[Issues with due date]>0
DateDiffDays(now(), [Measures].[Issue due date])<=30
DateDiffDays(Now(), [Measures].[Issue due date])>0
In a similar manner, you can create measures for the next 60, 90, etc. days.
Gerda // support@eazyBI.com