Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

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

Count Function isn't matching expectation

ebdevore
5 - Atom

Hi! 

 

I am trying to ensure that my Auto Insights mission is working as intended. I'm struggling with manipulating the count function to count Local.Concepts as I want it to.

I have attached two pictures to assist. I am trying to get my mission to show that Revenues appears 4 times in the three year period as a Local.Concept.

I can see that when I manipulate a pivot table in excel but I can't seem to get my autoinsights executive mission to do that. The excel is the dataset source of the mission. 

1 REPLY 1
cherylcarrie
Alteryx
Alteryx

hi @ebdevore , 

When selecting 'Number of Concept.Local-name' what Auto Insights does is to count the number of distinct values in that column.

Instead what you should select as a Measure would be typically be the Number of transaction ID or in your case 'Number of fact.value'.