Convert [Measures].[Issue Time to first response Elapsed hours] to date

#1

Hi guys,
I am using the measure [Issue Time to first response Elapsed hours] to return the date of the first response. What I get is something like this:
2019-02-07T08:59:59+0000,Completed,Not breached,0.99

Is it possible to convert this into a readable date like “Feb 07 2019”?

Thanks in advance!

0 Likes

#2

eazyBI does not import a date when any SLA was completed. Issue properties of any SLA elapsed hours contain this date for each completed cycle. This property shows details of any completed cycle including date and time of it as well.

You can try using Regular expression to retrieve the date part of it. Here is a formula example to retrieve the date and time of this property and transform it to date:

DateParse(Replace(ExtractString([Measures].[Issue Time to first response Elapsed hours], '(\d{4}-\d{2}-\d{2})T\d{2}:\d{2}:\d{2}'),"T"," "))

Daina / support@eazybi.com

0 Likes