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

Forum Posts

Preserving YTD after date filter applied

Hi, We are facing this. We have a pivot table with shows the total amount of a metric and the running sum form the begining of the year (YTD). This is working fine: Then, we want to apply a filter based on the date column, to show just a couple of mo...

jirazazabal_0-1675083680442.png jirazazabal_1-1675083814038.png

Resolved! Font color change

Hi team, I want to change the text styling of the widget in bar and scatter chart.I am using the below script. It works fine for me however, I am unable to change the color of the font here.Script: widget.on('ready', function(se, ev){ _.each($("text"...

zohebakber_0-1674633330575.png

Pivot table with Customer input

Hi Team, I am looking to create a pivot where where I would like to have input from the user in one of the fields as a feedback form.Please see the screenshot attached.Here, I want to take the input in the last columns in the screenshot below. Any he...

zohebakber_0-1674544165627.png

Resolved! Script to hide specific values from chart

I have a line chart with two metrics. I want to show the value of the first metric and hide the value of the second metric by default. Can someone help with a script to achieve this?

BIQ by 8 - Cloud Apps
  • 1114 Views
  • 1 replies
  • 0 kudos

Button to refresh widget connected to Live Cube

Is there a script I can apply to widgets to that will create a widget specific refresh button? Context: I have a dashboard with a lot of widgets connected to a live cube. I'd like users to be able to make edits to the source, return to the dashboard ...

BIQ by 8 - Cloud Apps
  • 1380 Views
  • 3 replies
  • 0 kudos

Complete List of All Folders in Sisense

Is there a way to get a full list of folders? I am are using the /folders API, but this only pulls information for folders that I own. I do have admin access to our Sisense instance and am looking to be able to retrieve the folder IDs and folder name...

jmn3 by 9 - Travel Pro
  • 786 Views
  • 1 replies
  • 0 kudos

Pivot Table Export Format Help

Is there a script or way to change the Format of Columns when exporting a pivot table? I'm exporting data using the Excel File option, and many of the columns I have formatted to Numbers, are being exported as TEXT when excel opens.

Force Pivot Table Rows/Columns to Show When No Data Present

I'm working on a custom pivot table implementation that has rules for coloring to recreate the concept of a risk matrix. Here's the code: widget.on('domready', function(sender, ev) { var widgetId = 'widget[widgetid*=' + sender.oid + ']'; //console.lo...

sneak_0-1674151062009.png sneak_1-1674151163706.png sneak_2-1674151428739.png
sneak by 9 - Travel Pro
  • 787 Views
  • 1 replies
  • 0 kudos

Ability to add Time Frames to filter list

It would be great to be able to customize the default list of time frames in the filter options. For example Prior 12 months Current month + prior 12 months It is true that these can be created as custom filters and even starred, but users tend to lo...

Show Starred Filter name in filter

When using a starred filter the filter shows "Filtered with custom filter". I would like it to show the custom name that was given to the starred filter. That is much more descriptive and helpful to the end users. Current the filter has a name

DrewGillow_0-1674141016048.png DrewGillow_1-1674141077309.png

Issues with Incremental Build on JDBC table

Hi all, CONTEXT ------------------We use GenericJDBC connector with custom queries to fetch data from our mongodb data source on Sisense. Our data model is similar to a star schema with one DIM table and several aggregated fact tables. Till date we h...

suchitsanghvi_0-1673628166004.png suchitsanghvi_1-1673628175008.png

Resolved! Dynamically Change Month order on X-Axis

Hello, The end-user has requested the following, but I am having trouble adjusting the x-axis appropriately. I have a line graph showing activity over the "Trailing 12 Months" (TTM). It is currently January, so this chart is correct. However next mon...