Pixel Perfect Repeating Sections Repeating Empty data

Question & Answer
, , ,
1

Hi Team -

I’m using pixel perfect reports (paginated reports) and utilizing the repeating sections functionality to show the top 5 ranked items, where each individual section represents a rank.

The dataset is configured to have the rank (between 1-5) in each row, and I am filtering on that rank as a dimension. It is possible that the dataset will only have ranks 1 and 2 out of the total possible 5. The expected behavior would then be for the pixel perfect report to only show 2 repeating sections.

However, my report is still creating 5 repeating sections, with sections 3, 4, and 5 all showing as “No Data” in each visual. Is there any way to only show the two sections with repeating data even if the repeating section is configured to show “top 5”?

2

Hi @Justin2 and welcome to the QuickSight community!
To my understanding, there is currently not an option to not show if ‘No Data’ is returned or to setup dynamic filtering based on the number of values available. And unfortunately, the documentation provided by AWS is light when it comes to pixel-perfect reporting.

I’d be interested in seeing how the rank filter was setup though to see if I’m missing a potential work around if you’re able to share a screenshot.

Either way, I’ll go ahead and mark this as a feature request as I agree this would be a nice addition to the reporting.

Thank you