DustinSmith
Data Storage
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Highlight 1st column in Pivot using values from another column
Excellent! Thank you so much! This is what it looks like now without any manual intervention: I was working with Anton from support and we got close. That solution was highlighting all columns except the first one. I'll post that script below(while obscuring the specific locations) in case anyone has a similar use case: Script: const target = { rows: [ { dim: "[LocationStoplight.status]", members: ["GREEN"], }, ], }; function setCellBackground(metadata, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = 'green'; } widget.transformPivot(target, setCellBackground); const target2 = { rows: [ { dim: "[LocationStoplight.status]", members: ["RED"], }, ], }; function setCellBackground2(metadata, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = 'red'; } widget.transformPivot(target2, setCellBackground2); const target3 = { rows: [ { dim: "[LocationStoplight.status]", members: ["YELLOW"], }, ], }; function setCellBackground3(metadata, cell) { cell.style = cell.style || {}; cell.style.backgroundColor = 'yellow'; } widget.transformPivot(target3, setCellBackground3);2.8KViews0likes0CommentsHighlight 1st column in Pivot using values from another column
Hello, I'm using Sisense Linux and I have a pivot table that I'm using to stoplight certain locations with green, yellow, or red. My 1st column is location(like NYC), my 2nd column is text status(GREEN), and my 3rd column is number status(3). I would like to use either the 2nd or 3rd column to determine what color to highlight the 1st column. What I have: What I'd like: I know pivots are highly customizable in Linux via widget scripts, but I haven't been able to get it working. ThanksSolved2.8KViews0likes2Comments