Transpose a Pivot Table Plugin

Comments

21 comments

  • Avatar
    Karoon

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

  • 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,

  • Avatar
    Jim Thomas

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

    Thanks, Jim

  • Avatar
    Sai Krishna

    Hi Team,

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

    Regards,
    Sai Krishna.

  • Avatar
    James Monnier

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

  • Avatar
    Oxana Noa Umansky

    Hi all,

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

  • 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
     
     
  • 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.

  • 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

  • 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!

  • 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.

  • 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 

  • 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,

     

  • 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

  • Avatar
    David Burke

    +1 for adding this to Table with Aggregation. 

  • 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!

  • 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!

  • Avatar
    M Shaw

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

  • Avatar
    Oleg Fil

    The download link was updated with the latest version

  • 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)

  • Avatar
    Brian Wilson

    Thank you James!

Please sign in to leave a comment.