Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Help with a formula to capture # of career site postings

41
Views
1
Comments
Maria Lieberman
Maria Lieberman Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Summary

Help with a formula to capture # of career site postings

Content

Hello - I'm trying to create a few formulas to determine the following - 

How many requisitions have been posted to our Internal Careers Site only and External Careers Site only even if they were posted historically and not actively posted today.

Here is 1 formula that I'm working with - 

count(case when "Requisition Posting"."Is Posted Internally" ='Yes' and "Requisition Posting"."Is Posted Externally"='No' then "Requisition Identification"."Req. Identifier" end)

Then I would also like to count how many requisitions were posted to both Careers Sites.

So, ideally I would like 3 columns of data.  Any help would be greatly appreciated!

Thanks!

Regards,

Maria

 

 

 

 

Tagged:

Comments

  • Sachin Sirohi
    Sachin Sirohi Rank 2 - Community Beginner

    Hi Maria,

    I think Pivot report can work for you. You can use Req ID for count under these columns there.

    Thanks,

    Sachin