Dataset filter in Q Topic

Question & Answer
,
1

I am having a dataset in SPICE having 4 years of data. I created topic based on that. Topic Indexing failed. I suspect it is because of large data.
We have add filter option in Topic. I added filter on time field to consider only 2 year of data.
Will this impact Index creation i.e. will index be created now for 2 year of data or still 4 year of data.

If 4 year, then what option I have to restrict index creation to 2 year. The dataset is used in dashboard also, so I don’t want to limit in dataset.

2

Hello @Saurabh

Greetings of the day!!

Adding filters in the topic to limit data will indeed impact index creation, as Q creates a topic index only for the data that meets your filter criteria.

This means the index will be created only for the 2 years of data you’ve specified in your filter, not the entire 4 years.

Related links:
[1] How long it takes to index the dataset in topics?
[2] How to improve QuickSight Q topic indexing time