Forum Discussion

Silutions's avatar
Silutions
ETL
12-27-2021
Solved

Center Pivot2 (Linux)

Just migrated from Windows to Linux.  Looking for a responsive Pivot2 script with will center the widget in it's container in place of the the standard left justify.  See below for example: We ha...
Linux
  • harikm007's avatar
    harikm007
    12-28-2021

    Hi Silutions ,

    Try this dashboard script. This script is adjusting the margin based on pivot container. So we don't need to adjust it manually. 

    dashboard.on('widgetready', function (se, ev) {
	
	//widgetid of pivot
	widgetid = '54cs60a78t22f4682g4555e2'
	
	if(ev.widget.oid == widgetid)
	{
		var pivotWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container .multi-grid .pivot-scroller .table-grid', element).width())/2
		$('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).css('margin-left', 'calc(50% - ' + pivotWidth + 'px)')
	}
});

     

  • harikm007's avatar
    harikm007
    12-29-2021

    Silutions 

    Added a condition to check if width of pivot is greater than its container

     

    dashboard.on('widgetready', function (se, ev) {
	
	//widgetid of pivot
	widgetid = '61cb60a88c22f3002f4929e6'
	
	if(ev.widget.oid == widgetid)
	{
		var pivotWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container .multi-grid .pivot-scroller .table-grid', element).width())
        var containerWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).width())
       	
		if(pivotWidth < containerWidth)
        	$('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).css('margin-left', 'calc(50% - ' + (pivotWidth/2) + 'px)')
	}
});

     

  • harikm007's avatar
    harikm007
    02-10-2022

    Silutions ,

    Hope this dashboard script works for you:

    dashboard.on('widgetready', function (se, ev) {

	//widgetid of pivot
	widgetid = '61cb60a88c22f3002f4929e6'
	
	if(ev.widget.oid == widgetid && $('.u-r').length == 0)
	{
		var pivotWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container .multi-grid .pivot-scroller .table-grid', element).width())
        var containerWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).width())
		
		if(pivotWidth < containerWidth && pivotWidth > 0 && containerWidth > 0)
        	$('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).css('margin-left', 'calc(50% - ' + (pivotWidth/2) + 'px)')
	}
});

    -Hari

harikm007's avatar
harikm007
Data Warehouse
12-29-2021

Silutions 

Added a condition to check if width of pivot is greater than its container

 

dashboard.on('widgetready', function (se, ev) {
	
	//widgetid of pivot
	widgetid = '61cb60a88c22f3002f4929e6'
	
	if(ev.widget.oid == widgetid)
	{
		var pivotWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container .multi-grid .pivot-scroller .table-grid', element).width())
        var containerWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).width())
       	
		if(pivotWidth < containerWidth)
        	$('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).css('margin-left', 'calc(50% - ' + (pivotWidth/2) + 'px)')
	}
});

 

Silutions's avatar
Silutions
ETL
02-04-2022

Hari,

Script works great on the dashboard, but is causing issues on PDF export.  The pivots on the PDF are shifting to the right so far that most of them are cut off.  I know that PDF export is  no fun, but wondering if you have solution for this issue?  Even ignoring the script on export will work for us.

Thanks and regards, Jim

  • harikm007's avatar
    harikm007
    Data Warehouse
    02-04-2022

    Silutions ,

    Please try this script. It will not work when exporting the dashboard to pdf.

    dashboard.on('widgetready', function (se, ev) {

	//widgetid of pivot
	widgetid = '61cb60a88c22f3002f4929e6'
	
	if(ev.widget.oid == widgetid && $('.u-r').length == 0)
	{
		var pivotWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container .multi-grid .pivot-scroller .table-grid', element).width())
        var containerWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).width())
       	
		if(pivotWidth < containerWidth)
        	$('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).css('margin-left', 'calc(50% - ' + (pivotWidth/2) + 'px)')
	}
});

    -Hari

    • Silutions's avatar
      Silutions
      ETL
      02-04-2022

      Hari,

      Tested, but it is not working for me.  It doesn't center the pivot for me so I wasn't able to test the export.  I did change the widget oid to match my widget, but no joy.  What else could I be doing wrong?  FYI:  we are on L2022.1.

      Regards, Jim

      • harikm007's avatar
        harikm007
        Data Warehouse
        02-04-2022

        Silutions ,

        You added it as dashboard script, right? And are you getting any error in browser console?

        I tested it on L2021.3 and its working (widget is aligned center in dashboard but not in pdf) May be latest version doesn't support this script.

        -Hari

    • Silutions's avatar
      Silutions
      ETL
      02-10-2022

      Hari - when an end user exits the pivot widget expand screen the pivot often slides off to the right of the container and the user only sees approx. half of the widget.  If they refresh the browser, the script fires and the widget is centered.  Is there a different call other than dashboard.on('widgetready', function (se, ev) that would run the script when that 'edit' menu is closed as well as dashboard load so the entire widget is visible without a screen refresh?

      Thanks and regards, Jim

      • harikm007's avatar
        harikm007
        Data Warehouse
        02-10-2022

        Silutions ,

        Hope this dashboard script works for you:

        dashboard.on('widgetready', function (se, ev) {

	//widgetid of pivot
	widgetid = '61cb60a88c22f3002f4929e6'
	
	if(ev.widget.oid == widgetid && $('.u-r').length == 0)
	{
		var pivotWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container .multi-grid .pivot-scroller .table-grid', element).width())
        var containerWidth = parseFloat($('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).width())
		
		if(pivotWidth < containerWidth && pivotWidth > 0 && containerWidth > 0)
        	$('[widgetid=' + widgetid + '] pivot2 .pivot-container', element).css('margin-left', 'calc(50% - ' + (pivotWidth/2) + 'px)')
	}
});

        -Hari