Forum Discussion

AllanXu's avatar
AllanXu
Helper II
6 years ago

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

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,

Need Help

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      AllanXu
      Helper II
      6 years ago

      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.