Using Chart.ca

Getting started

• Go to https://www.charte.ca/
• Click on Create Chart
• Login: I used my Google account just clicked on the G, chose my Google account and it entered the App.
• First time it will probably create a chart for you of the form: 

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

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

It is probably a good idea to make a Clone of the chart it created for you.  This may take a while (like  minutes)

Once this is done you can start to enter the data into the clone. 

In my case I laboriously deleted the contents of the clone line by line.

• 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 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.
    

Configure a chart

Title / Subtitle

Title

Line 1 Daily PingER metric versus Covad-19  Cases by Country

Categories

Category Selector

Selector Type Slider

Axis

Labels

Bottom axis label format{value}

Legend

Make visible by clicking on Show (important for Grouped motion charts)

XY Options

Xaxis

Log

Scroll down and set

min bubble radius 5

max bubble radius 20

use Gradient Gradient

Chart Properties

You can edit the file name

Publishing a chart

After saving the chart you can Publish the chart by clicking on Publish:

Scroll down and you will see the URL for the motion chart in this case https://charteca.blob.core.windows.net/pubs/3Z3qcBXqCT9B3WHz