1. 

   Sec, Member

   Hi together, It's a pleasure working with myDBR. Thanks for
   the great tool :-)

   I'm wondering if it's possible to add charts like bubbles or
   radar from Chart Director. Is it possible ? How can I do that ?

   Thanks
   Gerhard
2. 

   myDBR Team, Key Master

   Glad you like myDBR.

   Not all the charts available in ChartDirector are directly supported, but you can add support for extra ones using the myDBR's extension API.

   --
   myDBR Team
3. 

   Sec, Member

   where can I get more detailed information about your myDBR extension API ?
4. 

   myDBR Team, Key Master

   You can find documentation at http://mydbr.com/doc/?e_extensions.html

   Also, you can look at the extensions that ship with myDBR. You find the full source code under mydbr/extensions -directory.

   If you have any questions, just drop us a line.
   --
   myDBR Team
5. 

   myDBR Team, Key Master

   FYI,
   An example how to create both bubble and radar charts is now included in the myDBR 2.0 as an extension example. Full source code is included, so you are able to modify it as you wish.

   An example of radar chart:

   select 'dbr.echart', 'radar', 'Example radar';
   
   /* Define the colors for each radar */
   
   select 'dbr.echart.color', '0x80ff3333', '0x803333ff';
   
   select 'dbr.echart.name', 'Model Saturn', 'Model Jupiter';
   
   select Speed, Reliability, Comfort, Safety, Efficiency
   
   from mydb.radardata;
   
   

   An example of bubble chart:

   select 'dbr.echart', 'bubble', 'Bubble chart';
   
   /* Define the colors for each category */
   
   select 'dbr.echart.color', '0x80ff3333', '0x803333ff','0x80FF33ff';
   
   select x, y, z, category
   
   from mydb.bubbledata;
   
   

   --
   myDBR Team
6. 

   Sec, Member

   Thanks for the sample. It works (a little)

   I'll get this error > Notice: Undefined index: dbr.echart.color in D:\xampplite\htdocs\myDBR\user\extensions\echart\echart.php on line 140
   ... the the grid drawn.

   My table:
   field1 riskid int
   field2 probability int
   field3 impact int
   field4 weight int
   fiels5 value int

   for the bubble chart:
   X = probability
   Y = impact
   Z = weight
   category = value

   --------
   Code snippet:

   CREATE PROCEDURE


   _

   ()
   BEGIN
   -- show list
   select riskid, probability, impact, weight, value from schg_test.riskmatrix;

   -- show bubble chat
   select 'dbr.echart', 'bubble', 'Bubble chart';
   select probability, impact, weight, value from schg_test.riskmatrix;

   END;
   ---------

   The value-range is between 0 and 3

   Do you have an idea where what0s wrong ?

   Thanks
   Gerhard
7. 

   myDBR Team, Key Master

   Hi,
   you need to manually define the colors for each value. The colors are in ARGB format, so add:

   select 'dbr.echart.color', '0x80ff3333', '0x803333ff','0x80FF33ff';

   before the data query and you should be fine. We'll edit the example.
   --
   myDBR Team
8. 

   Sec, Member

   Hi again,

   I added the colors but the chart keeps still empty. The color points of each category I'll see.

   Is something else missing in my selects ?

   Here the code snipped:

   ---
   CREATE PROCEDURE


   _

   ()
   BEGIN
   /* show list */
   select riskid, probability, impact, weight, value from schg_test.riskmatrix;

   /* select chart type */
   select 'dbr.echart', 'bubble', 'Bubble chart';
   /* define colors (4) */
   select 'dbr.echart.color', '0x80ff3333', '0x803333ff','0x80FF33ff','0x80FF55ff';

   /* select data for chart */
   select probability, impact, weight, value from schg_test.riskmatrix;

   END
   ---

   Thanks, Gerhard
9. 

   myDBR Team, Key Master

   Gerhard,
   What is the content of your query?

   The columns in data query are:
   

   • x-axis value
   • y-axis value
   • bubbe size in pixels
   • category to select the color

   --
   myDBR Team
10. 

    Sec, Member

    Hi,

    I saw that the value of bubble size was only 1. I did't know about the pixes size.
    Now it's working fine !

    Thanks

    By the way: are their any options available for echart ?
    (axis decription, place of the category description, Background color,...)

    Thanks, Gerhard
11. 

    myDBR Team, Key Master

    I saw that the value of bubble size was only 1. I did't know about the pixes size.

    Determining the bubble size is not so straightforward since the axis are dynamically created. The x-axis may be in different scale (or even datatype) that the y-axis, so the bubble size has to be relative to x-axis, y-axis or as in echart, independent of the axis.

    By the way: are their any options available for echart ?
    (axis decription, place of the category description, Background color,...)

    The echart was supplied as an example of extension creation and it includes full source code. You can quite easily extend/change echart to include additional chart types / parameters.

    --
    myDBR Team

Reply

You must log in to post.