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
Summary
Conditional Calculated FieldsContent
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 Q1 | 2017 Q4 | 2018 Q1 | Year Over Year | Year to Date |
|---|---|---|---|---|---|
| Legal | 838 | 832 | 837 | -0.2% | 0.6% |
| HR | 12 | 17 | 17 | 41.7% | 0.0% |
| GTO | 5,595 | 6,019 | 5,125 | -8.4% | -14.9% |
| Sales | 19,895 | 20,324 | 20,400 | 2.5% | 0.4% |
| Marketing | 417 | 456 | 442 | 6.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.