Hi! I have a pivot table and would like to grey out some of the rows. These rows are for future weeks, or dates that are larger than the current week. I would rather grey out those rows instead of removing them, does anyone know how to do this? Thank...
I have been searching the web for a couple of days with no success. I need a code example using Blox dropdown to select dashboards. I have 10 regional locations, each will have a set of dashboards. I am able to create and use 10 buttons on a dashboar...
Hi, I have two tabbers for two different teams for eg: Sales and Marketing to view their respective metrics on their respective tabbers. I also have a filter name called 'Manager' to filter those who head each of these team. I want to default one man...
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 fin...
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...
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 way t...
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?
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...
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...
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...
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 ...
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...
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...
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...
