Pivot2: "Transpose a Pivot Table Plugin" re-implemented

Follow

Ravid Paldi

October 04, 2020 11:02

* * This post is a re-implementation of the old pivot1 plugin that can be found in this link * * 

Introduction

This plugin allows users to set the measures as rows and slice them by different dimensions such as different date resolutions.

Implementation steps

In order to implement The Transpose Pivot Plugin, please follow the listed steps below:

STEP 1 - ADD THE PLUGIN

Download the latest version of the plugin from this link and extract the enclosed folder into the plugins folder:

/opt/sisense/storage/plugins/

STEP 2 -  CREATE A PIVOT TABLE

STEP 3 -  COPY THE FOLLOWING SCRIPT AND PASTE IT INTO THE PIVOT'S SCRIPT

var transposePivot = true;

STEP 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.
• Sorting and column resizing is disabled.
• You can’t have measures that are toggled off in this widget.
• Please note that due to the new structure of the pivot2, we highlt recommend to start transtioing out of using this customization as it is expected to be not very stable. For other alternatives, checkout the "Other Alternatives" section below.

Other Alternatives

- You can get to a similar result using BloX. Follow the below post for isntractions on how to achieve this. 

Transposed Pivot Table With BloX

- We have developed a FinancialTable widget which is a designated table widget that let's add measurements as rows out of the box. 

Feel free to reachout for more information: 

inquiries@paldi.solutions

0

• 

  Sean Yuan December 07, 2020 20:19

  This doesn't seem to be working for me on Windows 8.2.3.10108

  Any idea if any modifications are needed for this to work?

  0

  Comment actions Permalink
• 

  Ravid Paldi December 16, 2020 09:00

  Hi Sean, 

  Re-writing our email correspondance here so the community could benefit as well: 

   

  There are two types of native Pivot Tables that Sisense offers:

  Pivot1

  - Available only on the windows distributions

  - This is the "old" pivot widget that existed the longest

  Pivot2

  - Available only on the Linux distributions (at list at the moment) 

  - Visually, it almost completely identical to the old pivot1 widget but under the hood it's html and code are fairly different

   

  The plugin that we have developed in this post is suitable only for the Pivot2 widget -> the linux distributions. The Pivot1 has its own transpose plugin but I'm not sure if it is stable in Sisense latest. 

   

  In general, I wouldn't go with the Pivoting approach as it is a very not a stable solution with many limitations, one of them is that it breaks the PDF Exprot.

   

  You have two stable alternatives that I would reccomend: 

  1) Try the Transposed Pivot Table with BloX instead. Requires more configuration work but it'll be stable and officially supported by Sisense at no additional cost.

  2) Try out our own home grown premium Pivot widget called ExpandablePivot that will be launched to the marketplace very soon. 

  

  It is packed with lots of handy features and also solve the transpose use case

   

  Feel free toreach out directly in case you are intrested in learning more. 

   

  Cheers,

  Ravid

   

  ravid@paldi.solutions

  Paldi Solutions - Sisense Partner - Gold Certified

   

  0

  Comment actions Permalink

Please sign in to leave a comment.