Hi Community
We have an issue in downloading pivot widget to pdf.
In sisense windows environment we have Pivot widgets in these widgets some columns are hidden we made this hide in script but when we download a particular widget to pdf it is showing the hidden columns also in the pdf so any one any solution for avoiding hidden columns in pdf please let me know.....
Hi Chandra,
Can you please elaborate on the intent behind hiding the column? It will give Sisense product team more context on the need.
Thanks
Hi,
Actually we have a hierarchy like Segments ---> Channels ---> Sub Channels
As per the Segments we have Channels and Concerned sub channels according to channels should be displayed. We Have Segment Rank also According to ranking it should display channels and subchannels. So for this we Hided Segments and Segment Rank in script by making column width 0 and commenting html line in script. So when we download pdf of a particular widget in pdf we can see hidden columns also so need to avoid these in pdf. Moreover we have many columns in pivot table so please also provide a solution for making all columns visible in pdf.
Hi Chandra
The correct way to hide a column is by disabling it.
To do so, you'll have to use a code similar to this:
widget = prism.activeDashboard.widgets.$$widgets.filter(i => i.oid === '614c7929feba1f08d4e71dd4')[0]
widget.metadata.panels[1].items[0].disabled = true
widget.changesMade()
widget.redraw()
Once this is in place, the relevant column(s) will be disabled and a PDF will be generated as expected
