Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Quarter Over Quarter difference / percentage of difference in ODV?
Summary
Quarter Over Quarter difference / percentage of difference in ODV?
Content
Ho can I show Quarter Over Quarter difference / percentage of difference in ODV?..
70
| Region | Q1FY17 | Q2FY17 | Q o Q |
|---|---|---|---|
| APAC | 100 | 80 | 20 |
| EMEA | 250 | 170 | 80 |
Answers
-
if You are interested specifically in those two quarters you could "fix" them and then write the formulas.
You could create 3 new fields like
E.g.
"QTY Q1" As "FILTER( Quantity USING Quarter = 'Q1FY17')"
"QTY Q2" As "FILTER( Quantity USING Quarter = 'Q2FY17')"
"Q on Q" As "QTY Q2"-"QTY Q1"
0 -
Can we use Presentation variable kind of thing in ODV, where we can capture the Filter values from the user and change the quarters to display accordingly?
If yes, how please..
0 -
There are no Presentation/Session Variables in DVD at the moment.
0 -
If you got the answer to your question you can maybe close the thread? It will help others with same/similar questions, right now it's still This question is Not Answered.
0