Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
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.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |