To print string/text
Hello,
Can someone help me to understand how can we print string/text in Sisense? Which command can we use? How to use it?
Forum Discussion
Hari,
Seems like the widget script it the best approach, but I think you noted in the script you created for me that it doesn't work on numbers from the values panel. I think that is what MadhuraK needs.
MadhuraK - if you change Hari's script slightly to this:
//Replace cell values with another value in a specific column
//Works on numbers from VALUES Panel. Does not work values from ROWS panel.
widget.transformPivot(
{
type: ['value']
},
function setCellBackground(metadata, cell) {
columnIndex = 2 // SET COLUMN INDEX TO CORRECT COLUMN. NOTE: INDEXES START WITH 0
if(metadata.colIndex == columnIndex)
{
cell.style = cell.style || {};
if(cell.content < '0.3') // REPLACEMENT LOGIC STARTS HERE
cell.content = 'Low'
else if(cell.content < '0.5')
cell.content = 'Med'
}
}
);
This will work if you only need to replace the value in a single column in Pivot2.
- Jim
Hello Hari and Jim,
Thank you for the response. I tried the widget script and could print desired string.
However I could not download the report in excel/pdf format. Is there any way to download the report?
