Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 186 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Help with a formula to capture # of career site postings

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
Comments
-
Hi Maria,
I think Pivot report can work for you. You can use Req ID for count under these columns there.
Thanks,
Sachin
0