Re: [libreoffice-users] Base graphics/visualization

Thanks Wolfgang!

Dave

On Wed, Jun 25, 2014, at 07:27 AM, Wolfgang Keller wrote:
> > I have been collecting data for over a year in Calc.  I will be
> > rolling over to Base to use the data more effectively.
>
> One word of free advice: Avoid the "built in" database engine. Use an
> external client-server RDBMS. It's so much safer. The driver for
> PostgreSQL comes with LO. Embedded database files can too easily get
> corrupted. That's not necessarily a problem specific to LO and/OR
> HSQLDB. 
>
> > However, Base has some drawbacks that I need some help with.  I have
> > been using the Calc data to create graphs of some of the data.  I did
> > not see a way to do this in Base directly,
>
> You can still pull the data from the database into Calc.
>
> https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511
>
> > so my first question is what is the best way to create graphics in
> > the Base reports? 
>
> Don't know about the report builder, never used it.
>
> > I'm also aware of a data visualization program called R. I have not
> > used R, and don't know if it will integrate with Base, or replace the
> > Base report altogehter.
>
> R is a statistical analysis software, implemented as a "fork" of the
> commercial S+. It should at least integrate with LO through Python,
> since Python has an interface module RPy. Or someone may have written a
> plugin that allows to use. Oh, here it is:
>
> http://tinyurl.com/na2fatp
>
> BTW: For anything that's not directly implementable using Calc
> functions and plugins, Python is a great scripting language for
> "data crunching" anyway, so learning it can be useful. It's not just for
> reporting, and not just with LO and PostgreSQL. 
>
> Sincerely,
>
> Wolfgang
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - Accessible with your email software
                          or over the web


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted