Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 57 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 53 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
How to do an average days to approve formula?
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
Tagged:
0
Comments
-
ABS(TimestampDiff(SQL_TSI_DAY,date field 1,date field 2)) is the calculation you should use
0