Have this one →
Can u advise me on how to overcome the issue?
In Progress - Issue created Date.
Ey!
DateDiffDays returns the amount of days between these 2 dates.
1st param is the oldest date and the 2nd param is the last date.
So, in your example will give you negative numbers.
And the format you have is because you are expecting a date, that is why you receive that string.
I would suggest you updating the formula like:
DateDiffDays(
[Measures].[Issue created date],
[Measures].[In Progress]
)
And formatting like a Number → Decimal
Finally, I suppose that your “In Progress” formula gives you the first time when the issue was moved into “In Progress” status as a Date or Timestamp
Hello @Nacho your suggestion actually worked. I do have values now. Regarding your last statement, the In Progress formula fetch the date the ticket moved to the specific status. One of the requirements is to calculate (per issue) this day interval.
Really thank you!
Appreciate!
Hello @Nacho it worked as a charm. Need to have at the end the total number of tickets.
And since there are filters at the top, i guess this totals is a dynamic field.
And do not realy know how to make it happen.
Thanks a lot!
Hi @Giorgos,
You might add the totals to the report. Please read more about that here - Create reports.
If you need to see the total number of issues - you might add a measure like “Issues created” or a “dummy” measure returning 1 to the report.
Then, the Total might calculate the totals and also the number of displayed rows.
Regards,
Oskars / support@eazyBI.com