Reorder pivot columns by viewers
Need
A common requirement for self service BI is to enable the viewers to save their own report. This can be achievable in Sisense if you are a designer of a dashboard.
However, when you are a viewer, you cannot even re-order the pivot columns as you please.
Challenge
The default behaviour of the viewer is only to interact with the filters and view the numbers. No layout changes are allowed for a viewer.
Solution
We can change the default behaviour of the viewer and allow him to re-order the rows, values & columns.
Using the API of custom roles we can achieve that.
Solution:
Go to Admin ==> REST API ==> 0.9
PUT /roles/{idOrName}/manifest/{path} API
Fill in the following parameters:
idOrName: consumer
path: /widgets.items
manifest:
{
"reorder": true
}
"reorder": true
}

Execute the API and that's it!

Note: the re-order option is enabled for all widget types (not just pivots), however, pivots are the main use case for this need.
Updated 02-23-2024
intapiuser
Admin
Joined December 15, 2022