Skip to main content

ADF 11g : How to create a climate Graph with ADF DVT

While preparing my trip to ODTUG KScope I needed to know whether or not I have to take shorts with me. I looked up the average temperature in San Antonio for June and July, and I it was clear. Shorts are needed..... I struck me that wherever I looked, all the climate data was displayed in the same kind of graph.  Climate Graphs as shown in the picture below ussually contain information about temparature and precipitation, Maximum, Minimum and Average temperature per month as well as precipitation per month.

I wondered if it is possible to create such a graph with ADF Data Visualization Tools. In this post I'll show you how to create such a climate graph.

It looks quit obvious. Create a graph with 3 line sections and one bar section, a combination of several types. The DVT component set contains a component. This is the one to go for. You can even pick a Dual Y axis in order to show a temperature axis and precipitation axis

When you use this component you will find out that simply dragging and dropping, and setting the datapoints will not do the trick for you.

Because when you run the graph you will not get the desired result.

JDeveloper configures one type per datapoint, so you get an Area-, Line- and Bar graph all in one

There is need for some extra configuration.I need to tell what kind of markerType will be used by each series. First I set a default Marker type for the Lines. That will be applied to all series that do not have their own markertype defined. Next I set Bar as the marker type for the precipitation points.

  <dvt:seriesSet defaultMarkerType="MT_CURVE_LINE">
   <dvt:series markerType="MT_BAR" index="0" assignedToY2="true"/>
   <dvt:series index="1" assignedToY2="false"/>
   <dvt:series index="2" assignedToY2="false"/>

Finally I make sure that the Y axes do not autoscale, and have predefined MIN and MAX values.

<dvt:y1Axis axisMaxValue="120" axisMinValue="0" axisMaxAutoScaled="false"/> 
 <dvt:y2Axis axisMaxValue="10" axisMinValue="0" axisMaxAutoScaled="false"/> 

After these minor changes, I get exactly what I expected to see. At home it is chilly..............

............................................ while in San Antonio it is hot.


Chris Muir said…
You convinced me.

I've been eering about taking shorts to KScope but if somebody is serious enough to use DVT graphs to show how hot it gets, shorts it is ;-)
Anonymous said…

The post is interesting, thanks for the great post.
I want to generate this Dual Y axis bar and line through coding. I can able to generate bar but not lines through coding.
Can u pls let me know what parameters i need to add to listObject for getting both Bar and Line.


Popular posts from this blog

ADF 12.1.3 : Implementing Default Table Filter Values

In one of my projects I ran into a requirement where the end user needs to be presented with default values in the table filters. This sounds like it is a common requirement, which is easy to implement. However it proved to be not so common, as it is not in the documentation nor are there any Blogpost to be found that talk about this feature. In this blogpost I describe how to implement this.

The Use Case Explained
Users of the application would typically enter today's date in a table filter in order to get all data that is valid for today. They do this each and every time. In order to facilitate them I want to have the table filter pre-filled with today's date (at the moment of writing July 31st 2015).

So whenever the page is displayed, it should display 'today' in the table filter and execute the query accordingly. The problem is to get the value in the filter without the user typing it. Lets first take a look at how the ADF Search and Filters are implemented by the f…

ADF 11g Quicky 3 : Adding Error, Info and Warning messages

How can we add a message programatically ? Last week I got this question for the second time in a months time. I decided to write a short blogpost on how this works.

Adding messages is very easy, you just need to know how it works.
You can add a message to your faces context by creating a new FacesMessage. Set the severity (ERROR, WARNING, INFO or FATAL ), set the message text, and if nessecary a message detail. The fragment below shows the code for an ERROR message.

1: public void setMessagesErr(ActionEvent actionEvent) {
2: String msg = "This is a message";
3: AdfFacesContext adfFacesContext = null;
4: adfFacesContext = AdfFacesContext.getCurrentInstance();
5: FacesContext ctx = FacesContext.getCurrentInstance();
6: FacesMessage fm =
7: new FacesMessage(FacesMessage.SEVERITY_ERROR, msg, "");
8: ctx.addMessage(null, fm);
9: }

I created a simple page with a couple of buttons to show the result of setting the message. When the butto…

How to: Adding Speech to Oracle Digital Assistant; Talk to me Goose

At Oracle Code One in October, and also on DOAG in Nurnberg Germany in November I presented on how to go beyond your regular chatbot. This presentation contained a part on exposing your Oracle Digital Assistant over Alexa and also a part on face recognition. I finally found the time to blog about it. In this blogpost I will share details of the Alexa implementation in this solution.
Typically there are 3 area's of interest which I will explain. Webhook Code to enable communication between Alexa and Oracle Digital AssistantAlexaDigital Assistant (DA) Explaining the Webhook Code The overall setup contains of Alexa, a NodeJS webhook and an Oracle Digital Assistant.
The webhook code will be responsible for receiving and transforming the JSON payload from the Alexa request. The transformed will be sent to a webhook configured on Oracle DA. The DA will send its response back to the webhook, which will transform into a format that can be used by an Alexa device. To code exposes two REST …