cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

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 highly recommend to start transiting 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 instructions on how to achieve this. 
- 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 reach out for more information: 
Rate this article:
Version history
Last update:
‎02-15-2024 01:54 PM
Updated by:
Contributors