Adjust Pivot Table Width

Answered

Comments

5 comments

  • Avatar
    Yoni Lerner

    Hi Alex,

    Sisense sizes the columns for the best optimization with minimal space, allowing you to insert another widget next to it.

    In your case I understand you have "extra space" that you wish to fill up by spreading the table, this can be done using JS and inserting it into the script editor of the widget. You can get some reference in an old post in the community, since then elements were change but logic stayed the same. Link

     

    -1
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Hi Alex,

    Although currently not available in Pivot tables, you can automatically adjust the width of a Table widget.

    So if you can switch from the Pivot table widget to the Table widget with the same results, you will be able to automatically set the columns width in a Table widget. Then when stretching the widget on a dashboard level, the columns within the widget will evenly stretch as well. 


     

    0
    Comment actions Permalink
  • Avatar
    Ayanda Dube

    Hi Oxana,

     

    I have three pivot tables in a dashboard and I would like to manually set a static width of the columns on all three to be the same so that the dashboard looks presentable. Instead of a zig-zag of pivot tables.   Is there a way of doing this?

    Thanks,

    Ayanda

    1
    Comment actions Permalink
  • Avatar
    David Burke (Edited )

    @Ayanda

    I've also been looking for that to no avail. I did see this plugin which at least makes them equal widths. 

    https://support.sisense.com/hc/en-us/community/posts/115005867428-Distribute-Equally-the-Widgets-in-a-Dashboard-Row

    0
    Comment actions Permalink
  • Avatar
    David Burke

    You can also set column width to manual on Table With Aggregation, for those who need to have some of the pivot functionality and want to manually size.

    0
    Comment actions Permalink

Please sign in to leave a comment.