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
Best practice to display a wide data range on a non-table view.
Hi,
Currently, we are on 11.1.1.7.0.
I have developed a stacked vertical bar chart to display data by hour and various zones. The data range is wide (0.01 .. 500) and because of this, lower end stacks are not visible at all. I have tried zoom in along with scaling based on data, dynamic scaling and also specific scaling. There is no effect; the lower end stacks are still invisible at the highest zoom in. At times, horizontal stack bar seemed to have worked but that's too much work for the end user to go on zooming in and in. I have set canvas width to 1580 px and height to 480 px - that's the maximum I can set them to.
What could be the best approach for this scenario? Or, is there any system-wide parameter that can display the tiniest section on a chart?
Thank you.
Regards,
Manoj.
Answers
-
Maybe you need to split your chart into two that display the top half and the other chart that displays the bottom half, sort by rank and then filter ?
Richard Chan
Neodata Australia
0 -
Thanks Richard. I was also thinking something similar - 20/80 rule.
0 -
Logarithmic scale ;-)
0 -
Hi Christian,
Thank you for your reply. I referred to http://yangiiiyang.blogspot.co.uk/2012/05/chart-is-worth-thousand-words-only-when.html to understand the logarithmic scaling. As per an example given, I changed my graph to line. This shows me a continuous line if there is any non-null value thereby indicating the user to zoom in if needed. Seems to be better than the bar graphs.
Thank you.
Regards,
Manoj.
Edit: The line graph and logarithmic scaling combination seems to be more appropriate.
0
