We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Counting Attributes in a Column for Yield Data

Accepted answer
5
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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