Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bullet graph or chart
Hello,
I was searching for a bullet graph in OBIEE 11.1.1.7 but I've seen nothing like this in the graph types nor in this forum.
Until I realized after many tweaks of an horizontal graph that I could use properties of this graph type to achieve like a bullet graph.
You build an horizontal graph with one mesure then go to "Edit graph properties" > "Scale" tab > "Scale Markers" properties > I personnaly added one marker with a marker of type "Range:" with a "Low" = 0 and for "High" I selected my column of last year mesure and choosed a color. I added another marker with a marker of type "Line:" with a width = 4px and for "Position" I selected my column of budget mesure and choosed another color.
I attached a preview of what it looks like.
I hope it could help someone else.
Comments
-
Looked at SampleApp already?
http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
0 -
No not yet. Thanks for the information I will download it and check it, I will surely find something interesting in it.
0 -
I guess I saw example of something really close to the one you did, so definitely a resource to have available to take ideas (or just copy the code directly )
0 -
From memory the SampleApp implements this : https://bl.ocks.org/mbostock/4061961
I prototyped a version of that here but the business here weren't that keen on it (actually some were very keen and some were not at all). I'm still a big fan of the chart and the amount of information it can contain in one line though.
I like what you've done with standard functionality though Patrick
0 -
Yes that's the one they use.
@Patrick Gendron Sorry I hadn't actually realized you weren't asking for help. Good solution. It's so simple and obvious once you've done it. :-)
0
