Skip to main content

Transpose a Pivot Table Plugin

Permanently deleted user

Download: Transpose A Pivot Table 

Introduction

Out of the box, Sisense does not allow users to structure a pivot table so the metrics are listed vertically on the left side, with the groupings listed across the top. This is commonly used in financial reports.

This plugin will allow users to get this layout.

Results.JPG

 

Implementation

  1. Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, please create it.
  2. Open the script editor for the widget you'd like to modify. We have documentation on how to edit a widget's script here:https://www.sisense.com/documentation/extending-dashboard-functiona...
  3. Put in the following lines of code into your widget script
transposePivot(widget);

 script.JPG

4. Click save, and refresh the widget.

 

Notes

  • This widget only supports using one grouping in the rows, and nothing in the columns. You will be alerted if you violate these restrictions.
  • I'd suggest using the "Alternating Columns" and "Columns Headers" options in the design section of the widget

 

Updates

  • October 18 2017 - support conditional coloring 
  • January 16 2019 - support for Sisense 7.2, support for column resizing, bugfixes

 

9

Comments

37 comments

Date Votes
  • Karoon

    Is this going to be a native feature? Seems quite useable...

    3
  • Ahuva Shabtai

    Hi,

    I am using this feature, and a client of mine has found 'sort arrows' at the end of the row, and also on the columns, which are confusing. I wonder if they could be removed.

    Please let me know if this update is made.

    Thanks,

    1
  • Jim Thomas

    Need this same functionality on the Table and Aggregated Table widget.  Any chance this is a simple update?  

    Thanks, Jim

    3
  • Siva

    Hi Team,

    As mentioned by Jim, we are also looking for similar functionality in Aggregated table widget.

    Regards,
    Sai Krishna.

    0
  • James Monnier

    Any chance we can get an update on whether or not this will be native in Sisense? 

    2
  • Oxana Noa Umansky

    Hi all,

    Let me touch base with the product team on that and I'll get back to you.

    0
  • Oxana Noa Umansky

    Hi James,

    The Product team is working on a project of re-writing the Pivot component. The transpose capability will be added to the Pivot backlog and will be eventually addressed in the change. 
     
    I recommend following the Product Updates segment in the community to make sure you get an email notification on future version releases. 
    Thanks,
    Oxana
     
     
    0
  • Carl Root

    When creating PDF pages in Sisense, this plugin is causing the page to become unresponsive. Wondering if anyone else has experienced this type of issue.

    1
  • Hugo Cabello

    Hi, 

    Is there any way to change the font-weight, font-type of a particular row (or multiple rows) when using the transposepivot functionality ? I tried to uses some script found for pivot tables but they do not seem to work when using the transpose pivot function.

    Thanks,

    Hugo

    0
  • Jessica Orlando

    Is anyone else having trouble with this in 7.1? We had it implemented in a previous version and now when I go to edit the widget, it freezes my computer and I need to exit the dashboard.

     

    Thanks!

    2
  • Shawn Walter

    Works great but get your pivot table like you want it first.  then add the script. 

    If you need to edit, comment out the transposePivot line, save script, then refresh widget, then edit then put the script back in.

    0
  • Lior Libman

    I can't find a way to make it work.
    Should the grouped variable be in the rows section?
    Where should I add the scores given to the grouped variable?

    Working on 7.1
    Thanks 

    0
  • Nishad Amin

    Has anyone tried to use the JumpToDashboard  plugin with the Transpose option?

    Currently, it doesn't seem like its supported. Wondering if anyone has a workaround. On 7.0 currently.

    Thank you,

     

    0
  • Hugo Cabello

    Hi,

    It seems that the transpose pivot is causing the download to pdf to fail on Version: 7.1.3.10025. I have the following error when trying to download the PDF: This shouldn't hav happened. Please ask your administrator for assistance. error initializing widget extension - Error: Cant' find variable: transposePivot at createWidgetExtension.

     

    Thanks,

    Hugo

    2
  • David Burke

    +1 for adding this to Table with Aggregation. 

    1
  • RAD Systems

    Howdy,

    This plugin works great for our requirement - thanks!

    Only issue I have is that the values render left-aligned as opposed to right-aligned.  Any quick advice on how to update the script to ensure right-alignment of the values?  (Brand new to Sisense.)

    Thanks!

    1
  • Eric Pouliot

    Hi,

    In 7.1, when attempting to export the transposed widget to Excel (XLSX) or PDF, the results are not transposed. Would love to see a fix for this.

    Thanks!

    1
  • M Shaw

    This seems to have broken in version 7.2.1.13003 does anyone have a fix?

    0
  • Oleg Fil

    The download link was updated with the latest version

    0
  • James Monnier

    Note: You will now need to use the following in your Jscript 

     

    prism.transposePivot(widget);

     

    This was changed with this new version (as per the readme file)

    0
  • Brian Wilson

    Thank you James!

    0
  • Oksana Partridge

    I do not see a horizontal scroll bar in the edge but I do see it in chrome but the last row CV is moving along with the scroll bar. Can it be fixed? I can send a cube and a chart if needed. Thansk

     

    0
  • Barry Gaffey
    • Edited

    @Oksana

    Microsoft Edge is not supported by Sisense
    https://documentation.sisense.com/latest/getting-started/minimum-requirements.htm#gsc.tab=0

    0
  • Duessa Holscher

    Running into issues with this plug in when downloading to PDF, it does not maintain the transpose.  Any suggestions?  Is this still on the roadmap to add to the native pivot functionality? 

    1
  • Jessica Orlando

    Did the plugin update with the 8.1.1 release?

    3
  • Danilo Soto

    This plugis is not working on sisense 8.1, any news? 

    8
  • David Oyler

    We have the same issue in 8.1.1

    4
  • James Monnier

    Same: Could someone help update this for the latest version of Sisense. 

    This is one of many issues we are having with 8.1 on up.

    Thanks,

    Jim

    3
  • Alan Trapanese

    I suppose it's due to the new version of angular introduced with Sisense 8.1.1:

    From the release notes: "Sisense has been upgraded to Angular 1.7.8"

    To solve the issue, I just changed the lint 38 of the wrapperService.js file from:

        var serviceModel = module.app._invokeQueue

    to

        var serviceModel = module.ngModule._invokeQueue

     

    0
  • Dustin Sandell

    Thanks for this!

    Anyone know if there's a way to make widget height adjustment work with it?

    Seems to keep resizing to the pre-transpose height for me.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post