Forum Discussion

rahuldhomane's avatar
rahuldhomane
ETL
09-08-2022
Solved

Pivot chart script not working

Hi , I am trying to manipulate the pivot chart font size, color and other aesthetic elements using one the script I found on the community posts. However, the script is not working as I am also try...
dashboards & reporting
  • harikm007's avatar
    harikm007
    09-21-2022

    Hi rahuldhomane ,

    Try this script to change font color:

    widget.on('ready', function(ev){
	$(".table-grid__row .table-grid__cell--data", element).each(function(){
		if($(this).text() =='✔')
			$(this).css('color', 'green')
		else
			$(this).css('color', 'red')
	
	})
})

    -Hari

     

rahuldhomane's avatar
rahuldhomane
ETL
09-09-2022

Hi harikm007 ,

Can you please suggest a solution on this query?

Best,

Rahul

harikm007's avatar
harikm007
Data Warehouse
09-12-2022

Hi rahuldhomane ,

I think you are using Pivot2 and script to change style is for Pivot.

Try below script:

const myTarget = {
type: ['value'],
values: [
{
title:[ 'Value1'] // put here desired column
}
]
};


widget.transformPivot(myTarget, function(metadata, cell) {
	
	if (cell.value <= 10) {
		cell.content = "✔";
		cell.style.color = 'green'
	}
	else {
		cell.content = "✖";
		cell.style.color = 'red'
	}
	
	cell.style.fontWeight = 'bold'
	cell.style.textAlign = 'center'
	cell.style.fontSize = '25px'
});

-Hari

  • rahuldhomane's avatar
    rahuldhomane
    ETL
    09-13-2022

    Thanks harikm007 , I am still facing 2 issues with the script:

    1) The red and green color of the ticks and the crosses does not get reflected on refreshing the page, I have to go into the edit mode every time and then only the colors get applied

    2)The script to change the font color, style is still not working for me. Please let me know if you have any other script that works for pivot 2.0.

    Thanks for the help!

    • rahuldhomane's avatar
      rahuldhomane
      ETL
      09-20-2022

      Hi harikm007 ,

      Did you get a chance to look into this request?

      Thanks,

      Rahul

      • harikm007's avatar
        harikm007
        Data Warehouse
        09-21-2022

        Hi rahuldhomane ,

        Try this script to change font color:

        widget.on('ready', function(ev){
	$(".table-grid__row .table-grid__cell--data", element).each(function(){
		if($(this).text() =='✔')
			$(this).css('color', 'green')
		else
			$(this).css('color', 'red')
	
	})
})

        -Hari