Align column widths across multiple Pivots in a dashboard

Comments

2 comments

  • Avatar
    Emma Stapleton

    I have found this useful in setting column widths at a widget level. Can be repeated on multiple pivot table widgets. If they are the same metrics, you may just need to set the row/category column width.

     

    widget.on("ready", function(widget, args) {

    var cat_column = "[fidx=0]";
    var metric1 = "[fidx=1]";
    var metric2 = "[fidx=2]";
    var metric3 = "[fidx=3]"; 

    //hide current column and set new width for the pivots
    $('[id="' + widget.oid+ '"]').find(cat_column).css("width", "200px");
    $('[id="' + widget.oid+ '"]').find(metric1).css("width", "100px");
    $('[id="' + widget.oid+ '"]').find(metric2).css("width", "90px");
    $('[id="' + widget.oid+ '"]').find(metric3).css("width", "105px");

    })

    1
    Comment actions Permalink
  • Avatar
    IT Department

    Does anyone know how to do this from the DASHBOARD?

    With 20+ Pivots this really is cumbersome!

    TIA

    0
    Comment actions Permalink

Please sign in to leave a comment.