Forum Discussion
Explore the impact of change
Hi Team
I'm trying to run the new Explore the impact of change Template from Viva and this is the error I'm getting " This attribute has to many values. The report support about 100 values from an attribute"
All our attributes have more than 10000 values and we are interested to see the change and explorer this template but now we have a limitation.
I believe you are in direct contact with the product team for a follow up discussion. I am posting Amit's answer here in case other companies run into this issue.
Answer
Would it be possible for you to define a filter condition so that the cardinality (i.e. unique values) of the attribute is at 150 values or less. For example, we recently conducted an ONA analysis at Microsoft where we specified a filter condition to analyze a specific Division at Microsoft rather than looking at the whole of Microsoft. By specifying the filter, the cardinality of the attribute(s) was within the cardinality thresholds.
Also please note, trying to examine an attribute with a very high cardinality will result in a "hairball" which will be difficult to draw insights from. Therefore, the recommendation is to specify a filter condition to bring the cardinality which the 150 limit.
1 Reply
- Jake_Caddes
Microsoft
I believe you are in direct contact with the product team for a follow up discussion. I am posting Amit's answer here in case other companies run into this issue.
Answer
Would it be possible for you to define a filter condition so that the cardinality (i.e. unique values) of the attribute is at 150 values or less. For example, we recently conducted an ONA analysis at Microsoft where we specified a filter condition to analyze a specific Division at Microsoft rather than looking at the whole of Microsoft. By specifying the filter, the cardinality of the attribute(s) was within the cardinality thresholds.
Also please note, trying to examine an attribute with a very high cardinality will result in a "hairball" which will be difficult to draw insights from. Therefore, the recommendation is to specify a filter condition to bring the cardinality which the 150 limit.