ContributionsMost RecentNewest TopicsMost LikesSolutionsWrapping text in pdf export of pivot Hello Community, i am looking for a solution of wrapping text in pivot pdf export. By using the below code i am able to wrap text in dashboard but not in pdf. this.afterResultLoaded = function (args) { $('table', args.element).css('table-layout', ''); } If any solution for this to wrap text in pdf please provide.. Re: problem in downloading pivot widget in to pdf 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. Can we change color of Pivot1 cell values Hello, I could not find any solution for changing the color of pivot1 cell value in a particular column based on some threshold value tried with some sample scripts but did not get it can you please help me out in this. Color should be applied only to value not the cell. Re: Tabber Formatting Hi Rahul, Try this once.. widget.on('render',function(w, e) { e.prefixText = ''; e.suffixText = ''; e.selectedColor = '#86b817'; /*The color of the chosen title*/ e.fontColor = '#cccccc'; /*The color of the unchosen titles*/ e.elementWidth = '103%'; e.descColor = '#a5a5a5'; e.parentMarginLeft = '-15px'; e.height = 32; /* affects the tabber widget default high*/ }); widget.tabs = [ { title: "Column Chart", displayWidgetIds : ["55797a9459ef031011000032"], hideWidgetIds : ["557d408a4630ccdc11000019"] }, { title: "Table", displayWidgetIds : ["557d408a4630ccdc11000019"], hideWidgetIds : ["55797a9459ef031011000032"] } ]; problem in downloading pivot widget in to pdf 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..... Issue In Sorting X-axis Labels Hi Sisense Community.. I am having an issue in arranging the x-axis labels in Heat Map. In this first we have chosen scatter chart and then converted in to heat map using the below code widget.on('beforeviewloaded',function(se,ev){ ev.options.chart.type='heatmap' }) For this we have tried with some scripts in order to sort X-axis values but no change .Can anyone help in this? Issue in Flattening JSON objects in Jira We actually have to flatten the column which has JSON kind of representing data in the sisense elastic cube which was imported from Jira data source through JDBC connector. For this we have tried the JSON_Value() to split JSON consisting column to flatten the data, but it is giving an error like JSON_Value(string,string) is not supported. We tried this using link https://support.sisense.com/kb/en/article/flattening-json-objects-in-sql-server#:~:text=Question%3A%20In%20instances%20where%20tables,these%20objects%20into%20individual%20fields Do we have any solution for this before or after getting the data in to the cube, if so, how? Is there any function like JSON_Value() that supports for Jira Data