Powerful data analysis.
Beautiful reports.

Join thousands of users who build beautiful data slideshows
for their customers and colleagues.

Sign up for FREE

Category: big data

New feature: Connect Jolicharts to Google Sheets

Google Drive and Jolicharts Connection

We are happy to announce today that it is now possible to create datasource from Google Spreadsheets.

When creating a new datasource, you’ll now see the “Google Spreadsheet” option appear. All you need is to connect to your Google account, and select the spreadsheet where the data is located.

Google Spreadsheet as Datasource

Creating charts and dashboard in the clouds has never been easier!

New feature: ‘Mandatory’ filters so your mid to big data dashboards become readable

Have you already been bothered by dashboards that display all data, one the same page, at the same time, making charts perfectly unreadable? That’s a rhetorical question…

When you’re dealing with such a huge amount of data, it is sometimes a good idea to display selected data.

You can select such data using the new feature on Jolicharts named Mandatory filter. Mandatory_Button_World_TourismNow, when someone opens your dashboard, the first item of a list will always be selected as default, keeping data visualization clean and clear for the user.

See for instance the dashboard made of Energy Star data, where AAEON data is selected by default in the brand filter.

Create real time dashboards with datasources and data fragments

Before you start uploading data, you must understand what lies behind the words datasource and data fragment and how you can take advantage of these concepts to create real-time dashboards.

A datasource defines the structure of the data you’ll store (e.g. column names, column data types). A datasource may contain one or several data fragments.

A data fragment contains the data itself.
For example, every time you upload a file to a datasource, a new data fragment is generated.All data fragments belonging to the same datasource must have the same column structure.

To sum it up:  a datasource is made of several data fragments having the same commun column structure.

Now, let’s move on to listing how you can use data fragments to create real-time dashboards:

  1. Create your dashboard
  2. Set up your datasources (the structure of the data that you want to import into Jolicharts)
  3. Design charts and data visualizations on your dashboard.
  4. Set up the Jolicharts API to update your data (the API will can send JSON data fragments to a given dashboard).
To update your dashboard in real-time you can create a new data fragment on Jolicharts every time your own application generates new data.
More about Jolicharts’ API : The API DocumentationAPI Playground