Count Function isn't matching expectation

[ebdevore]

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. 

[cherylcarrie · Accepted solution]

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'.