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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Conditional Calculated Fields

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment


Conditional Calculated Fields



I come from a Tableau background and am new to Oracle DV and I'm finding it difficult to create calculated fields the way I'm used to. I am trying to create a chart like this:

Headcount by Dept
2017 Q12017 Q42018 Q1Year Over YearYear to Date

I can get the counts for 2017 Q1, 2017 Q4 and 2018 Q1. However, I cannot calculate the Year Over Year or the Year to Date correctly. I have tried breaking the YoY into 3 calculations, one for 2017 Q1, one for 2018 Q1 and then the difference. I cannot get the correct counts for 2017 Q1 and 2018 Q1 that will match what is already in the chart. I am using the Quarter Name [Date], Active Headcount [Number] fields. I have a person number available, but could only use that if I ensure I'm counting only the active employees.

Howdy, Stranger!

Log In

To view full details, sign in.


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