Single value data is a single numeric value read from a single Google Sheet cell. If we do not enable historic data changes tracking, the following visualisation types are possible for the single value data type:
- Number with delta - you can specify time frame for delta calculation
- Number or Gauge with target value - you can set target value in widget panel
You can select historic data tracking. If this feature is enabled, Octoboard will start tracking data changes and building timeline graphs automatically. The following visualisation types will become available in that case:
- Line graph
- Bar graph
- Area graph
Once you have selected Single Value data, you can pick 1 value cell from the Google Sheets document to read data from. Make sure you select Data Sheet to read data from and define data cell either using your our or by typing cell reference in the edit box provided ("A1", "B4" etc).
You can select hourly or daily frequency of data updates. It will define how often Octoboard will try to connect to your document and re-read data value for dashboard display.