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:
Enter data into a chart
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.
- 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
Animation
Direction Backward
Axis
Selection Slider
Labels
Bottom axis label format{value}
XY Options
Xaxis
Log
Scroll down and set
min bubble radius 5
max bubble radius 20
use Gradient Gradient