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

Forum Posts

Report Manager - Custom Templates

The premium Report Manager plug-in has very limited documentation on using Templates. There is a "out-of-the-box look and feel feature" mentioned. Q1) Is this the API Report Manager Template? Q2) Report Manager allows multiple templates to be created...

mirzay by 8 - Cloud Apps
  • 1483 Views
  • 2 replies
  • 0 kudos

Conditional Tooltip based on Date granularity

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 granularity s...

nikitabansal_0-1660733489348.png

Resolved! Grouping Data Into Ranges - Front End

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...

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...

Graying out rows in Pivot Table

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...

amelia by 10 - ETL
  • 771 Views
  • 1 replies
  • 0 kudos

Tabber selected filters

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...

Priyanka by 7 - Data Storage
  • 1500 Views
  • 4 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 fin...

CDavidOrr by 9 - Travel Pro
  • 2382 Views
  • 4 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 way t...

Priyanka by 7 - Data Storage
  • 1423 Views
  • 1 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 renders?

jplefka by 7 - Data Storage
  • 2482 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
  • 886 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
  • 958 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
  • 1479 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
  • 1482 Views
  • 5 replies
  • 0 kudos