Forum Discussion
Key Influencers Not Enough Data
I am trying to identify key influencers on one-year retention explained by membership in a special population and first-generation college student. All three variables are in the same table and yes/no categorical variables. The message is "Retained One Year does not have enough data to run the analysis." These are the counts for this variable and the two comparisons with filters applied.
Seems like that would be enough data. Please also know I am not a programmer. What am I missing?
Hi LMACAT ,
It seems that you are getting an error message that says “Retained One Year does not have enough data to run the analysis.” This error message usually occurs when the Retained One Year has too few distinct values or too few records for each value. The key influencers visual requires at least 10 records for each value of the target variable to perform the analysis.
I think you can check the data quality and completeness of your table. Make sure there are no missing or incorrect values for Retained One Year, Special Population, and First Generation columns. You can also Increase the number of records in your table by adding more data from other sources or aggregating data at a higher level.
Reduce the number of variables in your analysis by removing some of the less relevant or less influential ones. Change the target variable from Retained One Year to another variable that has more distinct values or more records for each value. For example, you can use Retention Rate or Retention Score as the target variable instead of Retained One Year.
If you want to learn more, I think you can read this document for helps: Key influencers visualizations tutorial - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi LMACAT ,
It seems that you are getting an error message that says “Retained One Year does not have enough data to run the analysis.” This error message usually occurs when the Retained One Year has too few distinct values or too few records for each value. The key influencers visual requires at least 10 records for each value of the target variable to perform the analysis.
I think you can check the data quality and completeness of your table. Make sure there are no missing or incorrect values for Retained One Year, Special Population, and First Generation columns. You can also Increase the number of records in your table by adding more data from other sources or aggregating data at a higher level.
Reduce the number of variables in your analysis by removing some of the less relevant or less influential ones. Change the target variable from Retained One Year to another variable that has more distinct values or more records for each value. For example, you can use Retention Rate or Retention Score as the target variable instead of Retained One Year.
If you want to learn more, I think you can read this document for helps: Key influencers visualizations tutorial - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Yilong and thanks for the reply. I did look again at my data table and found some extra records with null values that I removed. That resolved the error message. The model still did not identify Special Population or First Generation as key influencers. In the absence of any error messages, I will take that at face value to mean they are not particularly influential.
