Manual Data

Manual data sources let you import data by uploading a CSV file or pasting values into a text area.

Adding Manual Data

1. Click Add Source on your dashboard page.
2. Select Manual Data.
3. Fill in the form:
   • Name - a label for this metric (e.g. "Monthly Revenue").
   • Unit - the unit of measurement (e.g. "USD", "%", "users").
   • Data - provide your data using one of the methods below.
4. Click Add Source to create it.

CSV Format

Your data should have two columns: a date and a numeric value. One entry per line, separated by a comma:

2024-01-01,1200
2024-02-01,1450
2024-03-01,1380
2024-04-01,1520

With Headers

If your CSV includes headers, TotalKPI will try to auto-detect the source name and unit from the header row:

date,Revenue (USD)
2024-01-01,1200
2024-02-01,1450
2024-03-01,1380

Wide / Transposed Format

TotalKPI also supports a transposed CSV format where dates are column headers:

metric,2024-01,2024-02,2024-03
Revenue,1200,1450,1380

File Upload

You can drag and drop a .csv file onto the upload area, or click it to browse for a file. The file's contents will be loaded into the data text area where you can review and adjust them before creating the source.

Currency and Number Parsing

Values that include currency symbols (e.g. $1,234.56) or percentage signs (e.g. 98.5%) are automatically parsed. Commas in numbers are handled correctly.