Find the set of values

Question & Answer
, , ,
1

Hello.

I really need you help to highlight the set of unique values from exact field. But Ive faced with QuickSight limitation in custom filet list (actually I have the list with more than 500000 values)
image

Could you provide another solution to the problem please?

Thank you.

2

instead of using order_id, do you have any criteria or indicator in the data source to filter the list?
you can create a calculated field as an indicator (e.g. Y or N) in the dataset or analysis and use a ifElse condition to define of the value of the calculated field. then use this calculated filed to filter the data

3

Hi @weird_guy,
Another thing you could consider is to create a parameter for Order ID and then add a control for it.

  • If you use the ‘dropdown’ option, since your list has so many values, it will just provide you with a text box (which you can input the exact field you’d like).
  • If you need to setup a filter regarding that order ID. You can then link your filter to your parameter so that it will filter to your exact field you’ve set in the control.

Let us know if you have any additional questions!

4

Hi @weird_guy,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

Hi @weird_guy,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information if needed.

Thank you!