Datasource: csv

With the local or external csv datasource, you can extract data from a comma separated file.
Attention: a numeric value is expected in the last column. If not available, add a "1"

Usecase

• any public data

Conditions

• File/url needs to be accessible by Nextcloud
• Realtime or dataload

Usage

1. select report
2. select csv datasource
3. maintain parameters
4. testrun until the required numbers arrive

Input Parameter:

• URL or internal file link
• selected columns (numbers for columns or strings for constants)
• leading rows to ignore, e.g. in case of headers

Example 1:

Population data from github

• URL: https://raw.githubusercontent.com/Rello/analytics/master/sample_data/sample1.csv

Example 2:

add a constant column at the front of the data

• selected columns: Income,1,2,4