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 for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

BIP Report: How to auto scale a graph in percent to 100

in Reporting and Analytics for HCM 1 comment

Hi everyone,

I would like to ask if anyone has a similar report where you were able to plot column values as percentages and scale the graph to display 100%.
Columns:
- Rating
- Employee


Sample values are:

Expected Results

Rating 3: 37.25%
Rating 4: 1.96%
Rating 5: 9.8%
No Rating: 50.98%

Values show like this

Image B

It only adds two ending zeroes upon selecting Chart Value Format = 'Percent'. Total values still don't equate to 100% even without those zeroes.

Image C

If I set the maximum value of the chart to 100, the values within the chart still don't scale evenly.

I've already added the percentage calculations within the SQL data set, but it leads to performance drop and time out error. I'd like to utilize just one data set where it display the actual counts in graph and also display the percentage in graph.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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