Hiding Sections on a Paginated Report

Question & Answer
, , ,
1

I have a paginated report, basically and invoice with 2 sections. The first one will always have data but the second may not have data. In the dataset there is a field called type that distinguishes the data for each section, e.g. section one is filtered by type=A and section two is filtered by type=B. The problem is if there is no data returned for section 2 there is a message, No data - there was not data found for the visual. I do calculated field coalasce(sumIf({unit_cost}, {type}=B), 0) so it will be 0 if there is no data. I would like to be able to hide the section if that value = 0

2

Hey @Alan_J_Lowenstein

To my knowledge and from the documentation you can’t hide sections conditionally based on the values in a visual.

I can mark this as a feature request for the QuickSight team.

3

Thanks Duncan. I was hoping there was some creative way to set a parameter based on a field in the dataset using dynamic parameter setting.. But I’m either unfamiliar with using the feature or I’m doing it wrong. e.g. If I could set the parameter based on the type in the dataset.

4

Hey @Alan_J_Lowenstein

I can mark this as a feature request for the QuickSight team!