Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Removing widgets from PDF export

Hello!I'm looking for a way (most likely a plugin) to allow Dashboard users (not owners, viewers or designers) to have more editing capabilities when extracting a report as a PDF. Some of our users woudl like to have control over which widget is disp...

Geo Map GL Widget Plugin

Hi Sisense Community. I have used the Geo Map GL plugin to create a map that shows the sales amount per state in only the US and Canada. However, when I hover over the map, there is no value label. I can't find much documentation on Geo Map GL online...

amelia by 10 - ETL
  • 3623 Views
  • 2 replies
  • 0 kudos

Calling a BloX action on Widget or Dashboard Load

I have a BloX action that triggers a change of filter to the latest date available.  The Blox widget itself is loading the date that it needs to use.   Is there a way I can execute this BloX Widgets Action when the widget or dashbaord loads or render...

jplefka by 7 - Data Storage
  • 3797 Views
  • 8 replies
  • 0 kudos

Resolved! Date filter not working when specifying Months

I have a widget that is filtered by a date field.  When I set this filter, using "Calendar", it works fine.  When I set the filter using "Time Frame" and selecting any option under Years, it works fine.  Selecting any option under Quarters, it works ...

CDavidOrr by 9 - Travel Pro
  • 3613 Views
  • 4 replies
  • 0 kudos

Allowing only specific columns in pivot to drill down

I have a pivot table with 9 columns and I have added a jump-to-dashboard to this pivot table, but I want only 3 out of those 9 columns to be enabled for drilling into that JTD and not all the 9 columns.Also, is it possible to connect different JTDs t...

Priyanka by 7 - Data Storage
  • 1611 Views
  • 1 replies
  • 0 kudos

How to limit the values showed without altering values?

Hi, We have some scenarios when we need to calculate some metrics based on all the history. For example, contribution and more. We need to include several data to get the right value. But, for example, if we have an history of 5 years, we need to per...

Resolved! Exclude specific filters on JTD script not working

Hi,I'm trying to use this script to disable a filter on jump-to-dashboard, but its not working. prism.jumpToDashboard(widget, { excludeFilterDims   : "[country.Country],[brand.Brand]"})   I'm using L2022.6.0 version. Please suggest what's the right w...

Priyanka by 7 - Data Storage
  • 2130 Views
  • 1 replies
  • 0 kudos

Apply a Formula to Select Rows in a Pivot Table

I have a pivot table and I'm pretty happy with how it looks. However, I want to adjust the formula in two of the columns, if possible.The pivot table looks like this: There is a formula in 2 of the value columns: LTD Remaining to Goal, and Forecaste...

oliviar_0-1660002342338.png
oliviar by 7 - Data Storage
  • 1321 Views
  • 1 replies
  • 0 kudos

Resolved! Do not display zero value rows in Pivot table

Hi,I have two 'value' columns in pivot table that have both zero and non-zero values in them. But there are also some rows with zero values in both the columns. I cant really use the column1>0 filter, this would eliminate rows where there could be no...

Priyanka by 7 - Data Storage
  • 2211 Views
  • 1 replies
  • 0 kudos

Links in Pivot Table

Hello, I am trying to create a column that links to our gift pages on our crm. The problem is when it goes to the url, it has the donor data at the top from the last viewed donor, instead of the donor data of the gift. Our solution is first to open t...

LAG/LEAD in Sisense Data Modeling

Hello all, I want to know whether there's a possible alternate for Lag and Lead functions in Sisense. I want to design a table where the row values are to be calculated based on the previous row values. The example of the model I want create is attac...

adityak by 7 - Data Storage
  • 1512 Views
  • 1 replies
  • 0 kudos

Resolved! Share of wallet

Hello I am new to sisense and trying to achieve a very simple view  My dashboard is being filtered for a selected brand (user can change this)  I would like to see the % contribution of this brand across it's category for example How much % sales did...

Community Content Spotlight

Content you missed that you never planned on reading

Updated: Feb 13th
  1. Blog: TreviPay’s Best Practice Journey
  2. KB Doc: Plugin – RemoveImageDownload – Removing Items From Sisense Menus
  3. Sisense Academy: Welcome to Sisense
  4. Sisense Docs: Explanations: Identify Reasons for Changes in Your Data
Check out our Software Developer Communities!