Troubleshooting the issue with incorrect Pivot Layout for Expand Pivot On Dashboard PDF
Summary: vg30 provides a guide to help customers properly extend multiple pivot widgets for the Expand Pivot On Dashboard PDF feature. The guidance focuses on addressing issues with broken widget layouts when multiple Pivot Tables are involved. They advise ensuring each widget is on a separate row, checking the preview on the dashboard for correct rendering, and enabling Auto-Height on each Pivot widget. Additional related resources are mentioned for further assistance.
The reason we have created this guide would be to increase the awareness of our customers on how to properly extend multiple pivot widgets for Expand Pivot On Dashboard PDF to ensure you are doing it properly to avoid potential issues with use cases when you have a couple of Pivot Tables on the same dashboard and some Pivots are extended as expected and some have broken layout.
Let’s take as a use case the example of the Sisense dashboard with 4 different Pivot Tables, example below:
As the output you would receive a PDF with a broken widget layout and Expand Pivot logic would work:
For Expand Pivot On Dashboard PDF to render each Pivot Table properly, we need to ensure the dashboard has each Pivot widget on a separate row, example below:
Additionally, we need to ensure at the Preview Of PDF on the dashboard, each Pivot widget has it is own picture, for example:
Additionally, in case you are still experiencing the issue with Layout, ensure that on each Pivot widget, you have enabled Auto-Height, example below: