Application Express :: Getting Chart With 4 Lines And 2 Y Axis?

Apr 25, 2013

i need a chart with 4 lines and 2 y axis. 2 lines on the first y axis, 2 lines on the other y axis.First i tried to create 4 series and "multiple y axis", then i get the first line at one y axis, and all the other lines at the second y axis.

After that i have seen that it is possible to return more than one value within one series, so i create 2 series with 2 values each - i thought that then i will get the first 2 values at one y axis and the other 2 lines of the second serie at the second y axis... but sadly it is not like i expected - i get the same result as with 4 series.is it really necessary to create a custom xml for that?

here is my example: [URL] as you can see the blue and the red line are on different axis.the query of one serie looks like that (it gives the values of a day and the day before), the queries are ok.

select null link, to_char(a.ts,'DD.MM HH24:MI') label, sum(a.kw*100/12) over (
partition by trunc(a.ts) order by a.ts rows between
unbounded preceding and current row
) "KWh",
sum(b.kw*100/12) over (
partition by trunc(b.ts) order by b.ts rows between

[code]....

View 0 Replies


ADVERTISEMENT

Application Express :: Chart With Multiple Y-axis?

Mar 28, 2013

I am using the build-in flash Apex chart which I understand to be a subset of the Anychart.

I have the following problem, I have two series, which I am displaying in a 3D Bar Chart on a horizontal view with two Y-Axis. This works well, the problem is that each Y -Axis has a different scale. I am not setting the min or max value range for either of the y-axis as I do not know what this value range may be at the time of rendering the chart to the application user.

So as it turns out, the left y-axis has a value range from zero to 100 and the right y-axis has a value range from zero to 50 and the application users are finding this difficult and confusing as they are only looking at the bars represented in the chart and assuming that as the two bars, i.e. one form each series look similar in size, they have the same value and this can not be further from the true, as one y-axis is showing a value range twice as big as the other y-axis.

So my question is how do you customise the chart so that the value range on both y-axis is the same. i.e., the largest of the two?

View 7 Replies View Related

Application Express :: How To Order  X-axis In Multiple Series Chart

Aug 17, 2012

I am using apex 4.1, i created a chart with 4 series in each series i am calculating sum of the no.of students joining in different classes of a institute for every year.

example my table is like this
date_of_join     class    student_id
'07/22/2012'      8       1
'07/22/2011'      8       2
'07/22/2009'      8       3
'07/22/2012'      7       4
'07/22/2010'      7       5
'07/22/2011'      6       6i wrote query like
series1

select null as link,UNISTR('�0A0') || to_char(date_of_join,'YYYY'),count(student_id) "class 8" from stdent_record where class=8 group by to_char(date_of_join,'YYYY') order by to_char(date_of_join,'YYYY')

series2

select null as link,UNISTR('�0A0') || to_char(date_of_join,'YYYY'),count(student_id) "class 7" from stdent_record where class=8 group by to_char(date_of_join,'YYYY') order by to_char(date_of_join,'YYYY')but what happened is the x-axis is coming in order like

2009  2011 2012 2010because the series1 no student is joined in 2010 so its taking the series1 order but i need the years in normal order.

View 3 Replies View Related

Application Express :: Chart With Vertical Y-axis Title Having Horizontal Letters?

Oct 24, 2012

I've edited the XML on the Chart Attributes page but I don't find atrtributes to rotate the y-axis title (<text>TITLE</text>) nor the letters themselves in the title. What I'd like is something very close to

T
I
T
L
E

But what I get is a horizontal title rotated -90 degrees. I've looked at lots of Anychart documentation but don't find anything that seems to fit with the XML already given on the Chart Attributes page. I've seen the "rotate" attribute but I don't know where it would go and even then, I'm sure it only rotates the title as a unit and not the individual letters.

View 0 Replies View Related

Application Express :: Tooltip For Pie Chart?

Oct 26, 2013

I have a 2D pie chart. The chart takes the column names as label and shows the results(3)  like passed--4, failed--3, on hold ---6.  Now I want to have tooltip  , if I point on passed--4, it should show  "number of students passed  last year"similarlyIf I point on failed--3, it should show  "number of students failed  last year"

View 1 Replies View Related

Application Express :: How To Create 3D Column Chart

Sep 6, 2013

MONTHSTAT_NAMEPERCENTAGE_OF_TOTALApr-08USER_TIME35.43Apr-08SYS_TIME3.74Apr-08BUSY_TIME38.33Sep-13USER_TIME42.92Sep-13BUSY_TIME45.54Apr-08IOWAIT_TIME20.12Aug-13SYS_TIME2.43Aug-13IOWAIT_TIME0.04Aug-13BUSY_TIME45.05Aug-13USER_TIME42.59Sep-13SYS_TIME2.52Sep-13IOWAIT_TIME0.04select null, month, stat_name, Percentage_of_Total from oshistory

I want to create 3d column chart for above chart.

View 3 Replies View Related

Application Express :: Random Order By In A Pie Chart

Jun 13, 2013

We have a pie chart which has select like   

select null, '0-10' Days , count(*) from tableunionselect null, '11-20' Days, count(*) from tableunionselect null, '21-30' Days, count(*) from tableunionselect null, '>30' Days, count(*) from table   

The 3d pie chart was showing the slices is the correct order 0-10, 11-20, 21-30, >30 but now shows it in random order. how to get the order by working. I suspect since the Days column in the select is a Character column this issue is occurring, however, with the restrictions in the number of select items we can have in the Apex charts, was wondering how do you get the order by working?

View 2 Replies View Related

Application Express :: 4.2 - Where Is Flash Chart Region Source

Sep 4, 2012

I just noticed on apex.oracle.com (4.2) that I couldn't find the region source for flash charts. I expected to find it under the Region Definition tab.

Has this moved or will it be included in a later release?

View 12 Replies View Related

Application Express :: Email 4.2 Chart As Inline Image

Aug 20, 2013

I have created a few flash charts using APEX4.2.  Is there a way for the user to view the chart and then email it as an inline image to someone? I know that the user can save the chart as PDF file, then send it as an attachment via Outlook ( or similar system), but can I integrate these manual steps to one ( template), similar to the IR report's download feature ? 

View 0 Replies View Related

Application Express :: Gantt Chart With Null Dates

Mar 28, 2013

APEX 4.0.2 Project Gantt Chart - Error Code: 2002 Message: Empty input

I found the actual dates are mandatory, while the chart tolerates missing planned dates - which is a complete reversal of what actual project data would have.baseline project gantt with parent-child relationship

What I found though is if some planned dates are missing, the generated XML seems to default with data from previous rows.my red lines indicate missing from/to dates (actual data also shown underneath chart) URL.....

NAME    TASK_ID   ACTUAL_START  ACTUAL_END  PROGRESS  DUE_START     DUE_END
line 1  1810794   07/MAR/2013   11/MAR/2013   100     26/MAR/2013   27/MAR/2013 00:00:00
line 2  1810780   12/MAR/2013   16/MAR/2013   100     23/MAR/2013   27/MAR/2013 00:00:00
line 3  1810779   17/MAR/2013   20/MAR/2013          
line 4  1810773   21/MAR/2013   21/MAR/2013   50      24/MAR/2013  
[code].....

View 0 Replies View Related

Application Express :: Possible Passing A Value To Two Different Pages When Click A Chart?

Sep 17, 2013

My application build in Apex 4.1, Oracle 11gr2In my application, there are three pages:

Page1 (Dashboard): contains 6 different chart
page60: Generate a chart based on  a value passed from page1
Page14: Generate a report based on a the value passed from Page1 and Page60

I want to pass value "3"  to page item P60_KPI_NO and P14_KPI_NO when click on first chart  I want to pass value "4"  to page item P60_KPI_NO and P14_KPI_NO when click on second chart.

View 0 Replies View Related

Application Express :: 4.2 / Gantt Chart Shows Only 15 Rows

Nov 24, 2012

why a Gantt chart would show only the first 15 rows of the query?! I validated id to be unique , parent_id properly pointing to the parent. When I artifically create another level, the chart still subborny shows only 15 rows. The actual query returns 1590 rows.

View 1 Replies View Related

Application Express :: Drag N Drop Graph In Gantt Chart?

Aug 26, 2013

I'm gonna create a Gantt chart on Oracle APEX and want to re-size, move the graph into other line..how to control the graph itself (just like javascript, ajax and anychart API...) URL.....

View 0 Replies View Related

Application Express :: Chart Axes Labels Under The Tick Marks

Mar 14, 2013

I'm trying to create a histogram based on time range using a bar chart. I made the query correctly and the bar chart displays the histogram.

However I want to make the axes labels on the x-axis go under the tick marks of the axis. Right now they are under the corresponding bar. This doesn't convey the notion of a range. For e.g. if I have 23 observations between 10 and 20 seconds, I need to show 10 on the left of the bar and 20 on the right. In other words the bar is between two tick marks. I want to show 10 under the left tick mark and 20 under the right tick mark.

How do I do this? I tried using the attributes of the label tag under x_axis in the chart xml, but couldn't get it to work.

View 1 Replies View Related

Application Express :: How To Display 4.2 Chart Region Title Dynamically

Aug 21, 2013

i I am using APEX4.2 and created

(1) a drop down list item called P38_DESK which contains a list of desks such as A, B, C

(2) a Chart region with region title: Chart Mvt by &P38_DESK.

(3) a dynamic action to "refresh" the Chart region if the value of P38_DESK is changed. 

I can see that everytime the desk is changed from the drop down list, the chart section/region gets refreshed accordingly but NOT the Chart's region title.

It only showed the first value I chose. e.g. Chart Mvt by A So in APEX4.2, how can the CHART's region title be changed dynamically ( without submitting the entire page ) to reflect the value from the drop down list P38_DESK ? 

View 7 Replies View Related

Application Express :: Flash Chart Show Incorrect Data

Jun 3, 2013

The following query is used to generate a flash chart:

select null link
'Available' as "Available",
to_number(max_licenses - consumed_licenses)
from software_detail
where capture_date = trim(GET_CAPTURE_DATE)
and software_product = :p1
and software version = :p2
[code].....

But the 2d doughnut flash chart shows:

Available = 39
Consumed = 1

How is this possible?

Oracle 11.2.0.3 RAC on Windows 2008 R2
APEX 4.2.1.00.0 with Apex Listener 2.0 on Apache Tomcat 6.

View 4 Replies View Related

Application Express :: Customize Tooltip In Flash Chart / Graph

Dec 4, 2012

Is there any way I could customize tooltip (when you go over the bar in the report, small box with the value appears).I would like to display different values there.

View 0 Replies View Related

Application Express :: Losing Chart Settings When Switching To Custom XML

Feb 20, 2013

I have an application which contains a chart of type Dial.In order to set the major interval dynamically I have switched to using custom xml and replaced the #SCALE_DATA# with:

<scale minimum='&P2_CHART_MIN.' maximum='&P2_CHART_MAX.' major_interval='&P2_CHART1_INTERVAL.'/>

However, I would also like to label the value with a Units Label (e.g. '%'). I was previously doing this using the Value: Postfix setting under Axes Settings, but after switching to Custom Settings removes this box and I no longer get the units displayed.

Is there some xml I can add which will set and display the units.I am using Application Express 4.0.2.00.09

View 0 Replies View Related

Application Express :: Flash Chart In 3.1 - How Many Labels Can Be Get Horizontally (Limitations)

Jun 22, 2012

I am trying to do a Flash Chart in APEX 3.1. Is there a limitation on how many labels I can get horizontally. No matter what I do the number of labels I get horizontally is 15. We are trying to show the amount of days in a month.... Can I do that? If so how?

View 5 Replies View Related

Application Express :: How To Refer Image From Table In Organization Chart

Mar 30, 2013

I am using org chart plugin to show the employee hierarchy, the plug-in is downloaded from

[URL]........

Current i uploaded the employee photo's in images under shared components -> files and referring in my query like below its working fine, but My question is how to refer employee photo's from table.

SELECT   TO_CHAR (emp.empno) AS primary_key,
TO_CHAR (emp.mgr) AS parent_key,
emp.ename
|| '<div>
<img width="100px" src="wwv_flow_file_mgr.get_file?p_security_group_id='
|| :WORKSPACE_ID
[code]...........        

View 1 Replies View Related

Application Express :: CHART SERIES - Show That If Value One Of Sources Had Fallen?

May 30, 2013

issue with my apex line chart. The scenario is as follows: have a table called revenue. revenues per year are saved in it. and revenues are generated from three sources which are also saved in the same table. I have made a line chart on it. works well.

Now I have to show that if the value of one of the sources had fallen, how must have it affected the total. I made a number field that takes an estimated change value, and build my sql query with it. it works but the problem is that it changes the non-affected source too. it must change the value of the affected source only and hence the total value.

bold or I will put it this way, how can I write a select statement for a chart series so that one of the rows value does not change and the other two change.

View 2 Replies View Related

Application Express :: How To Generate Chart Using Numerical Values Of String Column

Jul 27, 2012

We have generated a fancy custom interactive report, in which the columns of string type, but can hold string, numeric or date values. However the type of values are uniform for a particular column. The end users wants to use the numerical values for generating charts, but, being a string column (though the data is numeric), it throws an error and they could not generate the chart. Is there any way to make use of this string column type numerical data for generating chart?

The current version of apex is 4.1.

View 4 Replies View Related

Application Express :: Conditionally Display Html5 / Flash Chart Regions Depending On Browser Compatibility?

Nov 12, 2012

APEX 4.2 Theme 25 Oracle DB 11gr2 - I need to conditionally display Html5/Flash chart regions depending on browser compatibility, how to achieve this.

View 8 Replies View Related

Application Express :: Separate Link For Each Series On Multiple Series Bar Chart From One Query

May 13, 2013

I have a query that selects multiple series for a bar chart (I have defined only one chart series, and have 3 columns selected to represent 3 series). The series display on Bar Chart is fine. Now I want to create a separate link target depending on which series is clicked on the chart. I am not able to do this.

View 1 Replies View Related

Reports & Discoverer :: Graph - Repeating Frame (Change Dynamically Y And X Axis Title)

May 23, 2012

I'm presently creating a Graph on a repeating frame.

I made a query with a group that pointing to the repeating frame.

The problem : I want to change dynamically the Y and X axis Title.

The graph accept user parameter inside the XML file. But how to make it dynamically based on SQL query?

I try with formula, but can't make it work with a group. I have to put the formula at Report Level, but to make it dynamically for each group i have to make it work at the group Level.

View 1 Replies View Related

SQL & PL/SQL :: Get More Lines Into One Line?

Jul 31, 2012

how to get more lines into one line per customer.

For instance:

CREATE TABLE XXX_MAPE_CC
(
accounting_month_key number,
customer_key VARCHAR2(18 BYTE),
total_amount VARCHAR2(29 BYTE)
)
insert into XXX_MAPE_CC
values (201205, 313774201, '15,03')

[code]...

And I would like get every total_amount to individual columns by accounting_month_key

--------------------------------------------------------------------------
customer_key month_201205 month_201206 month_201207
----------------------------------------------------------------------------
313774201 15,03 10,03 13,10
----------------------------------------------------------------------------

View 3 Replies View Related

Remove All Of Indentations From Lines

May 16, 2007

In Oracle XE when I run PL/SQL in the SQL Commands window I will sometimes get a "Not found" error. It further reads, "The requested URL /apex/wwv_ flow.show was not found on this server". I found that if I remove all of the indentations from the lines of the PL/SQL code everything will work fine. Talk about a screwy problem. So, if you have that problem just take all of your PL/SQL code and slam it up against the left margin.

View 1 Replies View Related

SQL & PL/SQL :: Query Against EBS Order Lines And Headers

Sep 6, 2012

I want added one new column in the below report which will shows only the items purchased on Cash basis but when i am running the query the column not showing any data.

The query is :

Select DISTINCT ou.name||' Spare Parts' ORG, oh.order_number, trx.trx_number, trx.trx_date, p.party_name CUSTOMER, l.ordered_item,
/* ( Select Distinct it.description From MTL_SYSTEM_ITEMS_B it Where it.inventory_item_ID = l.inventory_item_id and it.organization_id = o.organization_id) Item_Desc, */
l.ordered_quantity, l.line_number,
l.inventory_item_id, l.unit_list_price , ----
a.account_number CST_NO ,
oh.Attribute1 MODEL , oh.Attribute2 SERL_NO, oh.attribute3 PAYM_MODE ,
u.user_name Prep_By, oh.CUST_PO_NUMBER PO_NUM,
[code]......

View 1 Replies View Related

SQL & PL/SQL :: If Exist / Then Display As Lines As String Between /

Oct 12, 2010

I got some records in the table between the sign / Some of these records are separated by / And I would like to get something like:

If exist / inside the string then display as lines as string between /

For instance:

select handset_brand, handset_model
from the_table;
display : handset_brand: Siemens
handset_model: A35 / A36 / A40 / B35N

I need to get 4 lines:

handset_brand: Siemens
handset_model: A35
handset_brand: Siemens
handset_model: A36
handset_brand: Siemens
handset_model: A40
handset_brand: Siemens
handset_model: B35N

View 31 Replies View Related

SQL & PL/SQL :: Email And Display Data In Lines

Jun 6, 2012

formatting the mail message sent using utl_mail, i have created one table and it has around 17 rows inside as sample and it may increase as well, my present email format is in single line..find below the code i have written along with test case, you may substitute your emailid for test, especially my main focus is on the column mrk , where all the mrk are comming in one line but i want to be arranged in a line not more thant 10 rows, if it exceeds it should go to next line.

CREATE TABLE FAB_LOG ( MRK VARCHAR2(30))
INSERT ALL
INTO FAB_LOG VALUES ('1018017M-6001')
INTO FAB_LOG VALUES ('1018017M-6002')
INTO FAB_LOG VALUES ('1018017M-6003')
INTO FAB_LOG VALUES ('1018017M-6004')
INTO FAB_LOG VALUES ('1018017M-6005')
INTO FAB_LOG VALUES ('1018017M-6006')
[code]....

View 39 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved