Oracle Transactional Business Intelligence

How to do an average days to approve formula?

41
Views
1
Comments

Content

Hi all,

 

I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it was approved in so I can create a trend analysis, I am struggling to create the average formula. I need to use this formula for many other OTBI dashboards (date of submitting expenses to approval for example). Any ideas please?

 

My Excel dashboard that I use macros from OTBI for which I am trying to replicate is below, as are my subject areas.

 

Thanks

Comments

  • ABS(TimestampDiff(SQL_TSI_DAY,date field 1,date field 2)) is the calculation you should use