Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
⬇️ Download using the attachment below ⬇️ 
A common requirement when performing grouping and aggregate operations, is to include all dimension values in the group irrespective of the contextual filters applied on the transaction table.
e.g. For a given QTR show me a list of Customers and Total Sales - Including those Customers who have not made any purchases in the QTR.
Installation and Setup
Download the file from the link. UnZip it and place the OJ folder within the plugins folder of the file management UI. 
 Admin > System Management > File Management  > plugins
You should now see the Include All Dimensions option in the widget properties menu for supported widgets.
Note: It is recommended that you refresh the dashboard after enabling the plugin on any widget.
Technical Details and Limitations
  • Works on Sisense Linux 8.2.4.x  onwards. Sisense Windows Not Supported.
  • Works on Pivot / Column / Line Chart widget types only.
  • Works with widgets based on both Live and Elasticube data models.
  • Supports data security.
  • Not conducive for pivots with more than 50,000 rows returned.
  • Sort on measure option not  supported.
  • Subtotal and Grand Totals supported for summation rollups only.
  • The plugin will respect any filter directly applied to the table of the Group field(s).
  • You may see the infamous yellow triangle after applying the plugin. - Refresh the dashboard to address this issue.
  • For pivots returning a large number of records, you may see blank results followed by a widget refresh. This is due to the asynchronous nature of JAQL queries executing under the hood.
  • If your widget has multi-level grouping with dimensions linked across a fact table. e.g. Customer > Orders >  Sales Rep.  Then the pivot will not display all the mathematical combinations but rather all combinations of Sales Rep and Customer in the Orders table. 
8 - Cloud Apps
8 - Cloud Apps

Hey @intapiuser , thanks for the plugin; it helped my team a lot.

I did a small change to allow it to work on Bar Charts too. Don't you have a github repo for it?


Version history
Last update:
‎12-27-2023 10:39 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: