Automatically update data on chart

Daniel
Offline
Administrator

09 Jan 2019 13:43 #6650 by Daniel

Replied by Daniel on topic Automatically update data on chart

If you get the data in supported formats, yes you can do that.

Thanks
Daniel

Please Log in to join the conversation.

COBUS Marketing
Offline
New Member

09 Jan 2019 13:17 #6648 by COBUS Marketing

Replied by COBUS Marketing on topic Automatically update data on chart

Okay, thanks for the information. Only I get so no database connection to Google Anlaytics. Then I have to generate that somehow different.

Can I create an API interface that gets the data from another external tool?
There would even be a data connection available.

Please Log in to join the conversation.

Daniel
Offline
Administrator

09 Jan 2019 13:10 #6646 by Daniel

Replied by Daniel on topic Automatically update data on chart

The option is there in the formatting section, But It's available only if the data is being fetched from the Database.

Thanks
Daniel

Please Log in to join the conversation.

Jürgen Török
Offline
New Member

08 Jan 2019 08:59 #6642 by Jürgen Török

Replied by Jürgen Török on topic Automatically update data on chart

Daniel wrote: Hi,
You can either use Dynamic CSV or Database option to display the live data. And to make it auto refresh the data, there is an option in Formatting section for "Show Live Chart". It can be used for the purpose.

Hi, i would like to use the Live Chart feature as well, but I can't find it in the formating section (see attachement) I use vChart 2.9.21
Thanks in advance

Please Log in to join the conversation.

Marc Diez
Topic Author
Offline
New Member

11 Dec 2018 15:05 #6577 by Marc Diez

Replied by Marc Diez on topic Automatically update data on chart

Ok, I'll keep on building the website and, as the project nears its completion (I have just started working on it), I'll get back to you to see how can we disable cache for vChart.

Thanks for your help.

Please Log in to join the conversation.

Daniel
Offline
Administrator

11 Dec 2018 15:00 #6576 by Daniel

Replied by Daniel on topic Automatically update data on chart

Yes, the cache prevents update data to show up on the website.

Thanks
Daniel

Please Log in to join the conversation.

Marc Diez
Topic Author
Offline
New Member

11 Dec 2018 09:44 #6575 by Marc Diez

Replied by Marc Diez on topic Automatically update data on chart

Thanks Daniel! I didn't notice the "Show Live Chart" option, but it seems I won't need it.

I've been testing the remote Database option and it seems to update the data each time I reload the website, which is the option I need for my client.

I have a doubt, though: will the server cache or Joomla's cache prevent data from showing updated charts on the website?

Please Log in to join the conversation.

Daniel
Offline
Administrator

11 Dec 2018 09:27 #6574 by Daniel

Replied by Daniel on topic Automatically update data on chart

Hi,
You can either use Dynamic CSV or Database option to display the live data. And to make it auto refresh the data, there is an option in Formatting section for "Show Live Chart". It can be used for the purpose.

Thanks
Daniel

Please Log in to join the conversation.

Marc Diez
Topic Author
Offline
New Member

11 Dec 2018 07:02 #6572 by Marc Diez

Automatically update data on chart was created by Marc Diez

Hi' I'm creating a series of combo and pie charts, with data that is updated monthly.

How can I build the charts so they update automatically each month?
Can I do this via CSV files on a ftp server?

I've checked your Live chart (auto refresh) demo but it doesn't explain how to create it.

Thx!

Please Log in to join the conversation.