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

Conditional Calculated Fields

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

Summary

Conditional Calculated Fields

Content

Hi,

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
Legal838832837-0.2%0.6%
HR12171741.7%0.0%
GTO5,5956,0195,125-8.4%-14.9%
Sales19,89520,32420,4002.5%0.4%
Marketing4174564426.0%-3.1%

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.

Register

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