Counting Attributes in a Column for Yield Data
SummaryNeed help with count functionality Oracle Analytics Cloud
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|