Auto Insights’ Different Data Types Explained

Last modified: March 30, 2022

Auto Insights' best insights come from time-series data. This article will help you understand the features of time series data, and identify if your dataset is good for Auto Insights. If you're looking to quickly validate if your dataset is Auto Insights ready, please refer to our checklist here.

Data Types

Date: Time series data typically has one or more date fields. Auto Insights needs at least one date field, to assist in the identification of patterns, trends and seasonality over time. Auto Insights' insights depend on the period your data spans, for example:

  • Anomaly detection: 7 months of data or more

  • Seasonality analysis: 24 months of data or more 

The preferred date format is YYYY-MM-DD. 

Measure: Your data should have at least one measure. A measure is a number or value that can be summed or averaged. Examples of measures include total value of sales, quantity ordered, spend and more.

If your measures have any special characters ($, %, #, &, etc.), thousands of separators or currency indicators (e.g. AUD, USD, NZD etc.), these should be removed from your data before uploading. If you would still like to see the currency indicator in Auto Insights, create a new column for these values.

Segment: In order to upload your data to Auto Insights, the data should have at least one segment, but the more the better! Segments are the qualitative fields of your data, for example, office locations, departments, product types, job ranks and more. 

Make sure your segments use user-friendly language and natural language terms.

example

For each segment identified, Auto Insights will also perform a distinct count. For example, with 'Department' set as a segment, it will calculate the number of departments and automatically provide additional calculations on Average sales by Department.

When you upload data, Auto Insights will automatically detect the format of each of your columns. You have the option to change this selection during the upload process. See the Related articles for more information on uploading your data.

Related articles
Data upload checklist
How do I upload data?
How do I connect to a database?
How do I connect to a .csv file?

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.