Counting Attributes in a Column for Yield Data

DiDio

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	2323	2123	1234	2314
Reject	234	222	323	232
Total Record Count	2557	2345	1557	2546
Yield	90.84%

2 questions.

1. How do I make a calculation work in Oracle Analytics Cloud to support my request? The Column I has 2 data attributes (Accept and Reject)

2. How do I then apply the yield percentage to a bar chart? Would this be Y2 data based off the custom calculation. See attached picture

 

Any help is super appreciated!!!

Version

Oracle Analytics Cloud Latest Version

Neeti Choksi-Oracle

You can use CASE statement or FILTER function to calculate the yield value. For example,

100*(CASE <Accept/Reject column name> WHEN 'Accept' THEN <Count Column Name> ELSE 0 END)/<Count Column Name>

OR

100*(FILTER <Count Column Name> USING <Accept/Reject column name> = 'Accept')/<Count Column Name>