Note: You will need to use user data or download mySidewalk system data, reformat it, and upload it into our system to create this chart.
Step 1
Collect your data or download data from the mySidewalk data library.
Step 2
Reformat the data into this two-variable time series template with your updated dates, labels, values, and lat and long, and then download the spreadsheet as a CSV.
The label column is where you put the name for each variable and what will appear in the legend.
The lat and long values don’t need to be precise because they will not appear in this time series chart.
Be sure to update the correct dates to match your data.
Step 3
Open mySidewalk
On the left hand side, click upload data
Click Upload Geography (because the lat/long is in your data file)
Click Choose File
Select your downloaded CSV
Click Open
Step 4 (**Important**)
After the data successfully uploads, click on the file name.
Under Alias, type the y-axis label next to the date. See below highlighted in yellow:
Step 5
Use the navigation in the upper left corner to return to the report/dashboard you will use to insert the time series chart.
Step 6
Insert time series
Select Your Data
Click on your newly updated data file from the list of uploads
You will get a time series chart with one line:
Step 7
Click Manage Geographies on the right-hand side (your variables are acting as geographies for this chart)
Click “Show as List”
Select Variable 2 Name so both variables have red X’s next to them
Click Finish Editing
Now you should have two variables in your chart using one geography
