Quick Sight Control does not show all values of dataset

Hello All,

I have got 1 issue for one of my state control. I have state control which is linked to a custom query dataset with 81 distinct values . But in Control I am seeing only 18 values.

Hi @Rohit_Nikam ,
seems strange, I’ve tested it with 99 distinct values and seems to work.

Can you please share some more info?

E.g., how is the Control configured?

Or, do you have any other type of filters activated on the same sheet or Cross-Sheet?
image

Can you please check these two? :slight_smile:

Andrea

Hi @andreab ,

This issue occurs when I am taking fact table field in control . There are more than 10000 rows in that dataset . But In this table there are only distinct 81 rows for that field

Hi @Rohit_Nikam,

I hope this message finds you well! Just checking in as I noticed you have not received a response in a while. Were you able to find a solution to your question since or are you still facing that specific issue? If we do not hear back in the next 3 business days, I will close this topic.

Hi @Rohit_Nikam,

Since we have not heard back, I will close this topic. However, if you have any additional questions, please feel free to create a new post in the community and link this discussion for relevant information if needed.

Thanks!