We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Auto Insights Discussions

Find answers, ask questions, and share expertise about Alteryx Auto Insights
Get started with

Alteryx Auto Insights

Lesson 1

Introduction to Alteryx Auto Insights

Lesson 2

Understanding Data with Alteryx Auto Insights

SOLVED

I have blanks in my dataset, can I still load it into Auto Insights?

cherylcarrie
Alteryx
Alteryx

Solution:

 

Yes you can! Though it's good to note the behaviour of the tool when you are in this situation as there are times blanks in datasets are expected, and sometimes, blanks in dataset may not be relevant to a specific analysis.

 

Date columns

For date columns with blanks, If that date column is the default date, Auto Insights will not pick up the row with blank dates in it for any of its analysis.

 

Measure columns

For measure columns with blanks, Auto insights will treat that as 0 and aggregate the column accordingly. When calculating Averages, there is the option to 'Include blanks' if you wish to keep those specific rows in your analysis. This check box is displayed at the bottom left of the Measure picker in the Query Bar (found in Mission/Search) and is only available when Averages are selected. By default, this checkbox is unchecked.

cherylcarrie_0-1664364818519.png

 

Segment columns

For segment columns with blanks, Auto Insights will group the analysis as 'Unlabelled' as a default and will not be shown as part of the key call outs in 'What Caused This' even though it might be the largest change. Instead Auto Insights will call out the next largest contributor in that segment that contributed to the change as the key driver.

 

This prevents datasets with columns that are expected to have blanks in them to have misguided insights. E.g. Service Ticket dataset with 'Assigned Owner' column having blanks is expected if it's a newly created ticket that has not been triaged yet and should not be called out as a main contributor for the largest increase, instead the next largest is of significance.

cherylcarrie_1-1664365131412.png

When you add a segment with blanks into the 'breakdown' dropdown in the Query bar (found in Missions/Search), Auto Insights will generate an Unknown Values story and calculate the significance of the blanks in your analysis. In this screenshot it has highlighted that the breakdown analysis identified has 14.7% blanks, giving the user the ability to make a judgement call if the generated insights are suitable.

cherylcarrie_2-1664365363097.png

 

2 REPLIES 2
amelia_alteryx
Alteryx
Alteryx

Looking for the answer? Look up! 👆 The solution is in the post

Scraven
6 - Meteoroid

yes you should be able to, may want to just use a data cleansing tool though.