Create a Manual Data Source

Manual Data Source

When working with raw data, this is the data source you need. It has the most flexibility allowing you to capture all your data in a data set.

Tip
If you're looking to track performance indicators with targets and actuals, use the Measure data source instead.

Navigate to Analytics -> Data Sources.
Click on New Data Source button.
Select Manual Type.
Name your data source by replacing the 'Untitled Data Source' with your data source name, this will make it easier for you to find it later. Tab or click anywhere outside the box to save your changes.

The first column with a data type of Text(255) is added by default. To add additional columns, click on Add Column.

A bottom panel opens when adding a column or clicking on the column name. This panel holds the column properties where you can set the column name, data type, and the ability to protect the column. The latter can be useful when you need to set a target column.

Data Type	Description
Text (255)	A plain text field that accepts alphanumeric value up to 255 characters.
Long Text	Use these fields when you have multiple lines of text. It carries a 2048 character limit.
Number	Use these fields to enter numerical values with formatting, decimals, rounding, a thousand separator, suffix (e.g. add percentage %), and prefix (e.g. add $) configuration.
Picklist	Use these fields to enable users in selecting one value from a set of pre-configured choices in a drop-down list. This is useful to prevent spelling errors and ensure accurate data entry. For example: permit types, school, branch or housing locations, etc. See below for an example picklist.
Date	Use this field to enter a date or date-time data. This field brings up a calendar where the user can choose a date, or they can enter a date value as long as it conforms to the data format selected.
Time	Use this field to enter time data in 12 or 24 hour format.
Duration	Use this field to enter time duration in HH:MM:SS (hours, minutes, seconds).
Formula	Use this field to evaluate given expressions using the columns and display the results. Learn more about Formulas in this article.
Indicator	Used for displaying status with icons and/or text based on an evaluated set of conditions.

Example Picklist Setup: