Google Visualizations
Google Visualizations Tweet |
|
|
Categories:
Region Plugin
Create a sub-zero dahsboard with Visualizations!Look at the help text included.
19 Jan 2011: (re)New(ed) version of the OrgChart Plugin, fixed the 12 Oct 2010 bug ...again.. ;-( 18 Jan 2011 : Version 1.2 released. All data is now retrieved using Ajax callbacks. So there is no 32767 character limit anymore. Removed the Filter and Update Dynamic Actions. These are replaced by a Refresh action. 12 Oct 2010 : I changed the code for the OrgChart so it should work in pre-11g versions also (tested on XE). Presentation available on Slideshare (Click the "Other useful info" link on the right).
Special Requirements Internet access (it downloads Google stuff when running). Keywords
Google Visualizations, Google API, Google, API |
Share on Digg
Save This Page
|
|
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first. Reviews / Questions / Comments are e-mailed to the author of the Plug-in. |
Refresh chart
by raoul mangoensentono
on February 29, 2012
Hi Roel,
Is it possible to refresh only the chart when I make a choice from a select list?
I tried with a dynamic action refreshing the chart region. Yet nothing happens.
Tnx,
Raoul
Is it possible to refresh only the chart when I make a choice from a select list?
I tried with a dynamic action refreshing the chart region. Yet nothing happens.
Tnx,
Raoul
New version of OrgChart
by Roel Hartman
on February 23, 2012
Found and fixed the problem. I created a separate Plugin with just the OrgChart - just search on this site.
Answer to Wade
by Roel Hartman
on February 23, 2012
Seems either the upgrade to 4.1.1 broke the OrgChart - or Google changes something. I'll look into it.
Demo not working
by Wade
on February 23, 2012
Hi,
I have looked at the demo and it appears to not be working. I came across this because I am also using this plugin, but it doesn't seem to be working for me either. It was working yesterday morning, but then stopped in the afternoon. Is there active development on this plugin?
Thanks.
I have looked at the demo and it appears to not be working. I came across this because I am also using this plugin, but it doesn't seem to be working for me either. It was working yesterday morning, but then stopped in the afternoon. Is there active development on this plugin?
Thanks.
RE: hidden-superboss-
by Roel Hartman
on July 26, 2011
Hi Brandon,
I don't use a START WITH clause in my query, so I really don't know...
I don't use a START WITH clause in my query, so I really don't know...
hidden -superboss-
by Brandon Koop
on July 22, 2011
In the demo you hid the -superboss- (unless the president is selected). The filter I have set up to go by manager always shows the manager's parent (id only). I am using (START WITH empno = :Manager) to filter. Any ideas on getting rid of the extra box above the manager?
by David Martinez
on June 16, 2011
Thank you very much for your quick and accurate answer. Today I´m a happy man.
Best regards.
Best regards.
Answer to David
by Roel Hartman
on June 14, 2011
Google is very picky on the date format for this one. You can see the options here : http://code.google.com/intl/nl/apis/chart/interactive/docs/gallery/motionchart.html#Data_Format, but in this Plug-in only the string values are implemented (so weeks or quarters). If you set the number of columns of the Plug-in to 5 and use this as the query:
select 'producto' product,
'2008W15' week,
2 * 2 unitprice,
2 * 3 unitprice2,
2 * 4 unitprice3
from dual
It works. You'll get a more stunning result using this query (with lots more dummy data, using 4 columns):
select *
from
(
select
chr( ascii('A') + round(dbms_random.value(0,4))) category
, '2010W'||to_char(round(dbms_random.value(1,52)) ) week
, round(dbms_random.value( 1,10)) quantity
, round(dbms_random.value( 1,50)) amount
from dual
connect by rownum <=500
)
order by 1
select 'producto' product,
'2008W15' week,
2 * 2 unitprice,
2 * 3 unitprice2,
2 * 4 unitprice3
from dual
It works. You'll get a more stunning result using this query (with lots more dummy data, using 4 columns):
select *
from
(
select
chr( ascii('A') + round(dbms_random.value(0,4))) category
, '2010W'||to_char(round(dbms_random.value(1,52)) ) week
, round(dbms_random.value( 1,10)) quantity
, round(dbms_random.value( 1,50)) amount
from dual
connect by rownum <=500
)
order by 1
More info
by David Martinez
on June 10, 2011
Sorry, I was talking about TimeChart (Motion).
I would really appreciate any ideas or examples to make this great plugin run in my BI applications.
Working with Apex 4.0.2 on XE 10g.
Regards.
I would really appreciate any ideas or examples to make this great plugin run in my BI applications.
Working with Apex 4.0.2 on XE 10g.
Regards.
There should be at least three columns..
by David Martinez
on June 9, 2011
..in the data.
Sorry, but this is the message I get no matter what query I construct. I've tried many possibilities.
My last try it's been the easiest query I could make without succeess. Any ideas?
select 'producto' product,
to_char(2008) year,
2 * 2 unitprice,
2 * 3 unitprice2,
2 * 4 unitprice3
from dual
Thank you!
Sorry, but this is the message I get no matter what query I construct. I've tried many possibilities.
My last try it's been the easiest query I could make without succeess. Any ideas?
select 'producto' product,
to_char(2008) year,
2 * 2 unitprice,
2 * 3 unitprice2,
2 * 4 unitprice3
from dual
Thank you!
| Powered by Sigsiu.NET |  |