Transpose a Pivot Table Plugin

Comments

23 comments

  • Avatar
    Karoon

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

    1
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    Jim Thomas

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

    Thanks, Jim

    3
    Comment actions Permalink
  • Avatar
    Siva

    Hi Team,

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

    Regards,
    Sai Krishna.

    0
    Comment actions Permalink
  • Avatar
    James Monnier

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

    1
    Comment actions Permalink
  • Avatar
    Oxana Noa Umansky

    Hi all,

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

    0
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    David Burke

    +1 for adding this to Table with Aggregation. 

    1
    Comment actions Permalink
  • Avatar
    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!

    0
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    M Shaw

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

    0
    Comment actions Permalink
  • Avatar
    Oleg Fil

    The download link was updated with the latest version

    0
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Thank you James!

    0
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink
  • Avatar
    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
    Comment actions Permalink

Please sign in to leave a comment.