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

Forum Posts

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 renders?

jplefka by 7 - Data Storage
  • 1007 Views
  • 8 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 Forecasted...

oliviar_0-1660002342338.png
oliviar by 7 - Data Storage
  • 384 Views
  • 1 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
  • 351 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
  • 564 Views
  • 1 replies
  • 0 kudos

Dashboard Filter Date in Last 180 days or NULL?

I need to create a dashboard filter that will filter the Closed Date In Last 180 days OR if Closed Date is NULLWould you know how to include the OR Condition in a Dashboard Filter? I tried using the Advanced formula below and some variations of this ...

mirzay by 8 - Cloud Apps
  • 555 Views
  • 5 replies
  • 0 kudos

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
  • 411 Views
  • 1 replies
  • 0 kudos

Resolved! Display a selected filter as a text widget on dashboard

Hi,I want to display a selected item on a text filter as a simple text on dashboard. for example: I have a filter called account name and I filter it to the name 'Google', I want 'Google' to be displayed in the form of text widget on the dashboard.Th...

Priyanka by 7 - Data Storage
  • 557 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 A...

Dashboard Subscription option in Share does not exist

I am working on a new implementation of Sisense. Dashboards and reports are built using a live model. As part of testing, I notice that the dashboard share does not contain the dashboard subscription option. What settings or functions can I look at t...

mirzay by 8 - Cloud Apps
  • 205 Views
  • 0 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...

Resolved! Expand and collapse pivot table

Hi all, Running Sisense L2022.1. I'm getting a lot of requests for expanding and collapsing data within pivot tables. Is this possible?The problem with the drill-down functionality is that it also filters on the value you selected, sometimes I don't ...

ScheurK by 9 - Travel Pro
  • 689 Views
  • 2 replies
  • 0 kudos

Resolved! Schedule "Changes only" EC build

Hello, Is there a way to schedule a "Changes only" build in Sisense? As per the article below, it appears that there is no option to select what type of build I want to run. By default it runs a "Replace All" build at the scheduled time. I wish to ru...

vaibhav_j by 9 - Travel Pro
  • 825 Views
  • 3 replies
  • 0 kudos
Community Toolbox

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

Need additional support?:

Community Support Request