Transpose a Pivot Table Plugin

Tommy

August 17, 2016 19:38

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.

Implementation

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.
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...
Put in the following lines of code into your widget script

transposePivot(widget);

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

Comments

23 comments

Karoon October 06, 2016 13:57

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

1

Comment actions Permalink
Ahuva Shabtai October 10, 2016 19:19

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
Jim Thomas October 31, 2016 12:48

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

Thanks, Jim

3

Comment actions Permalink
Siva October 07, 2017 08:18

Hi Team,

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

Regards,
Sai Krishna.

0

Comment actions Permalink
James Monnier December 21, 2017 17:32

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

1

Comment actions Permalink
Oxana Noa Umansky December 21, 2017 17:58

Hi all,

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

0

Comment actions Permalink
Oxana Noa Umansky January 02, 2018 15:53

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
Carl Root March 26, 2018 19:25

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
Hugo Cabello May 22, 2018 15:48

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
Jessica Orlando June 05, 2018 22:20

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
Shawn Walter June 06, 2018 13:44

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
Lior Libman June 06, 2018 14:28

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
Nishad Amin July 18, 2018 18:48

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
Hugo Cabello July 31, 2018 12:45

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
David Burke August 03, 2018 13:35

+1 for adding this to Table with Aggregation.

1

Comment actions Permalink
RAD Systems August 27, 2018 19:10

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
Eric Pouliot October 16, 2018 15:54

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
M Shaw December 11, 2018 10:53

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

0

Comment actions Permalink
Oleg Fil December 17, 2018 09:18

The download link was updated with the latest version

0

Comment actions Permalink
James Monnier December 18, 2018 19:17

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
Brian Wilson December 18, 2018 19:22

Thank you James!

0

Comment actions Permalink
Oksana Partridge August 12, 2019 20:53

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
Barry Gaffey August 12, 2019 20:55 (Edited August 12, 2019 20:56)

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

Introduction

Implementation

Notes

Updates

Comments

Didn't find what you were looking for?