I have a dataset where a dimensional string column is frequently null. I want the top 10 of that column, without showing null. I’ve tried various prompts like “top 10 dimension except null” or “top 10 with dimension” but nothing seems to work. Any suggestions?
Hi @DanCory,
You can do this by creating a calculated field to identify the records where the dimension is null and adding a filter to your topic.
ifelse(isNull({dimension}), 'Yes', 'No')
3 Likes
Hi @DanCory, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
1 Like