How to tell “Key Influencers” visual a column reparents count?

[AllanXu]

I have a dataset that includes summarized records. The following table shows a simplified example:

Column 1	Column 2	Number_of_rows
A	X	3
A	Y	1
B	Y	2

When I use the “Key Influencers” visual, it does not know that  “Number_of_rows” is the count of the row and it sees it as a number like age or price.

I can UN-GROUP my dataset and repeat the rows based on the count in the “Number_of_rows” field. However, that is very inefficient and substantially increases the size of dataset.

Is there any way to tell the  “Key Influencers” visual that a field indicates the count of the row sample?

Thank you,

[v-lid-msft]

Hi @AllanXu ,

Although it cannot tell it is a count, it should works fine as a general number and have same result that you un-group data and use enable-count in the Key Influencers Visual.

Could you please provide more details about your expected result based on your shared table?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllanXu]

Hi @v-lid-msft ,

Considering the eplorational nature of the influencer , I don't know what the perfect expected result could be.

However, I expect Influencer algorithm should behave diffrently when it see 70 records vs. one record with an column with the number 70 in it.