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
