OTBI: Need to display ratio between 2 analysis in a dashboard page. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

OTBI: Need to display ratio between 2 analysis in a dashboard page.

edited Jul 3, 2018 8:17PM in Reporting and Analytics for HCM 2 comments

Summary

OTBI: Need to display ratio between 2 analysis in a dashboard page.

Content

Hi,

 

We have analysis 1: All Employees Head Count

Analysis 2: HR Employees Head Count

We need to get ratio between both as: Total Employees Head Count / HR  Employees Head Count 

This ratio also need to be displayed on the same Dashboard page.

For Example: If I put a Performance Tile to HR Employees Head Count and the count is 4.

Similarly, I put a performance tile for All Employees Head Count and the count is 16.

The ratio 16 / 4 = 4 Should be displayed on a 3rd performance tile.

How can I acheive this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!