Graph CSV Data with Range Selector v1.0.0
Published by Widget Studio on April 13, 2019Updated on April 10, 2020
Tags: Analysis,Charting,Data Presentation
Download Send To Carafe
Created By: C. Lind
Version: 1.0.0
Windows Tested: Yes
Offline Compatible: No
Description:
Getting the Data
This widget is set up to graph CSV data, which is fairly easy to generate with a FileMaker script (beware of null values, though).
The first row of the CSV is the labels, the first column being the x-axis data. The new line separator is \n
This widget will graph error bars, or min/avg/max by separating this column of data with semicolons like this:
	YYYY-MM-DD,min;avg;max,min;avg;max\n
or with real values:
	2019-03-18,0;1;2,15;16;17\n
Note that the new line character (\n) is instead of a carriage return.
Date Format
Since this library will parse the CSV data, dates should not be surrounded by quotes. Valid date formats are YYYY-MM-DD and YYYY/MM/DD. The dates can also be followed by a space and a time.
Version: 1.0.0
Windows Tested: Yes
Offline Compatible: No
Description:
Getting the Data
This widget is set up to graph CSV data, which is fairly easy to generate with a FileMaker script (beware of null values, though).
The first row of the CSV is the labels, the first column being the x-axis data. The new line separator is \n
This widget will graph error bars, or min/avg/max by separating this column of data with semicolons like this:
	YYYY-MM-DD,min;avg;max,min;avg;max\n
or with real values:
	2019-03-18,0;1;2,15;16;17\n
Note that the new line character (\n) is instead of a carriage return.
Date Format
Since this library will parse the CSV data, dates should not be surrounded by quotes. Valid date formats are YYYY-MM-DD and YYYY/MM/DD. The dates can also be followed by a space and a time.
This widget will graph CSV data. It includes a range selector/slider to drill down into the data. The axes smoothly resize as you zoom in/out. This is accomplished with the Dygraphs javascript library.
Configuration
| Name | Description | Type |
|---|---|---|
| data | Ok, so that looks like a lot of gibberish. This is simply CSV data with the new line indicator \n First row is the labels. Data columns are in this format: Min;Avg;Max Dates can be either YYYYMMDD or YYYY/MM/DD | text |
0 Comments