...
There is help at https://charteca-cdn-editor.azureedge.net/help.html#callout_data_label_format_help
Enter data into a chart
Using the Import wizard
Click on data and scroll down below the data space and you should find the import Wizard
The files are at https://www-iepm.slac.stanford.edu/pinger/covid/
- Go to https://www-iepm.slac.stanford.edu/pinger/covid/
- Choose your file (for this example let it be ipdv-deaths.csv) and click on it
- Open the file and enter Excel
- Select the heading and data and make a copy into your cut buffer (command-c on Mac).
- Open https://www.charte.ca/ in your browser and click on Create chart
- Log in (I use my Google account which saves entering a name and password)
- Click on My Charts
- Choose a chart by clicking on it
- Click on Data
- Scroll down to Import flat CSV data and click on Import
- Click on Has Headers
- Move the cursor to the white space and click on it. Paste the cut buffer into the white space and your Excel csv file should appear
- Scroll down to Next and click on it,
- Step 2: Enter Date into Category, Covid-19 deaths into x, ipdv into y, population into z, TLD into Label, Continent into Variable, Country into Variable 2.
- Click on Next. If nothing happens it probably means you have entered something incorrectly into the form.
- Step 3: Leave it alone click on Next.
- Step 4: Click on Next
- Step 5: Click on Done
- Step 2: Enter Date into Category, Covid-19 deaths into x, ipdv into y, population into z, TLD into Label, Continent into Variable, Country into Variable 2.
API
charte.ca exposes a simple API that allows users to automate the following operations:
- download/upload chart data
- publish/unpublish a chart
- export chart svg/svgz to a local file
See https://demo.charte.ca/#/integration_guide
Before learning of import wizard
...
- Clean out most of the data in the clone
- Click on Data to the left, the data for the chart will show up.
- In the data click on a grey 'Value' cell, the row will get a blue background.
- Then on a Mac I tapped the fn-delete key. Fairly frequently nothing happened. I am not sure what the magic is, maybe it's a long delay, I usually tried again on another row. Eventually a row was deleted it seemed to then work for more rows. It may be a good idea to do a Save, in case something breaks. After the save you may have to go thru the same magic again to get started on the deletions.
- As a matter of practice I deleted all rows except the first 3. This is so there is something left to display in the chart.
- I saved this partially emptied data file.
- Next I created the csv Excel file.
- I created a perl script create-covid.pl to read the PingER data for a specified PingER metric (default Inter Packet Delay Variation (ipdv)) measured from SLAC, for each country for the last 120 days (from from https://www-iepm.slac.stanford.edu/pinger/prmout/), merge it together with Covid-19 data from Johns Hopkins University (https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv) plus the Country name, TLD, population, continent and region and write it all to a csv file using the Charte.ca format.
- Enter the data into Charte.ca app
- I fed this file to Excel, verified it looked correct, made a copy in Excel
- Went to the Charte.ca Clone, deleted the remaining 3 lines. The data was now empty.data cell
- Clicked on the top left data cell (its background goes blue) and pasted it into the cell, and waited. Eventually (after a minute or two) the new data showed up as well as the motion plot.
Using the Import wizard
Click on data and scroll down below the data space and you should find the import Wizard
The files are at https://www-iepm.slac.stanford.edu/pinger/covid/
- Go to https://www-iepm.slac.stanford.edu/pinger/covid/
- Choose your file (for this example let it be ipdv-deaths.csv) and click on it
- Open the file and enter Excel
- Select the heading and data and make a copy into your cut buffer (command-c on Mac).
- Open https://www.charte.ca/ in your browser and click on Create chart
- Log in (I use my Google account which saves entering a name and password) Click on My Charts
- Choose a chart by clicking on it
- Scroll down to Import flat CSV data and click on Import
- Click on Has Headers
- Move the cursor to the white space and click on it. Paste the cut buffer into the white space and your Excel csv file should appear
- Scroll down to Next and click on it,
- Step 2: Enter Date into Category, Covid-19 deaths into x, ipdv into y, population into z, TLD into Label, Continent into Variable, Country into Variable 2.
- Click on Next. If nothing happens it probably means you have entered something incorrectly into the form.
- Step 3: Leave it alone click on Next.
- Step 4: Click on Next
- Step 5: Click on Done
- Step 2: Enter Date into Category, Covid-19 deaths into x, ipdv into y, population into z, TLD into Label, Continent into Variable, Country into Variable 2.
Configure a chart
Title / Subtitle
...