Handling Errors in Unique Value Computation in Amazon QuickSight

Question & Answer
,
1

I’m experiencing an issue when using unique value computation in QuickSight.
When the number of unique values reaches or exceeds 1,000, an error appears:
“There were too many distinct categories found to be correctly computed.”

I tried applying a workaround shown in the attached image, but the error still occurs.

Do you have any tips or recommended ways to handle this issue?

Thanks for your help!

image
image1363×484 11.6 KB

2

Hello @olddog

I’m surprised there’s a limit on that and its that low. I would suggest pre-calculating this and then bringing it into the insight visual.

Here’s an example I made: Insight limitation workaround