Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to make a conditional calculation

Summary
How to make a conditional calculation
Content
Hi all,
I'm trying to figure out how to make a conditional count.
I have a column where the cells are filled whit "YES" or "NO" and I want to count how many "YES" I have in the whole column.
Thank you in advance for your help.
Answers
-
I have done what you suggest like this:
However it is not counting only the 'Yes' this calculation is counting all registers.
0 -
Create a new column with a CASE WHEN statement.
Example:
CASE WHEN column1 = 'Yes' THEN 1 ELSE 0 END
Then make the default aggregation on that field a sum or count
0 -
I'm sharing the one that finally worked after a lot of attempts.
0