General OBIEE

Get Involved. Join the Conversation.

Topic

    Doron de Jong
    How to do an average days to approve formula?
    Topic posted February 19, 2018 by Doron de JongRed Ribbon: 250+ Points, tagged Analyses, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, SQL 
    39 Views
    Title:
    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

    Document:
    Doc2.docx (644KB)