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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Counting Attributes in a Column for Yield Data

Accepted answer
8
Views
1
Comments
edited Aug 19, 2021 7:47PM in Oracle Analytics 1 comment

Summary

Need help with count functionality Oracle Analytics Cloud

Content

I am trying to ultimately get yield percentages on a bar chart but for now i'm trying to figure out if i can create a calculation that will give me the pass yield percentage broken down monthly.

I have data that looks like the below.

Normally in excel I would just use a countif function and count the amount of records that meet "accept" then count the amount of records that meet "reject".

Then simple math # Accept / Total Record Count * 100% to get my percentage yield

  March 2021 April 2021 May 2021 June 2021
Accept
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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