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...
Hello, I am very new to sisense and have a typical requirement so I am using blox buttons to change the granularity in a widget In the same widget I would like to show comparisons in tooltip for last month, last quarter depending on the granularit...
I have a set of data that gives out a Numerical Number for MAX(Score). I want to count the number of each record that falls into a set of ranges. 100-96, 95-90, 89-85, 84-80, 79-75 and <75 My case statement is starting like this: Case When (max([Scor...
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...
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...
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...
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 ...
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, 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 w...
Hi All,I have the following use case:I want to visualize the overall stock level of 2 different products over time. The source for the stock levels is a FACT table containing the log data of the stock movements. The FACT table is connected to a date ...
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...
Problem: One of our teams uses Sunday as the calendar week start day, which is different than our other teams that use Monday as the week start day. I have created a special column in a date dimensional table where the date reflects Sunday and am us...
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...
