This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Question: The error message that im experiencing is coming from the Postgres . Solution: To resolve the issue please try adding the Additional parameter: NoResetOnClose=true to all DB connections to the read replica databases you use.
Q. What is the difference between a JWT token and an API token ?A JWT - JSON Web Token is used to SSO into the Sisense web portal to establish a cookie based web session. An API token is used to make calls to the Sisense REST API for administrative a...
Question: I have used Sisense.JS to embed multiple widgets into a web page.However, none of the Legends are displaying, rendering the widgets useless.Is it possible to pull through the legend?Answer:Widgets rendered using Sisense.JS follow the same b...
Question:We are using SisenseJS to embed widgets into a React app. I am looking for a way identify the widget to render without using its id or title. This is so when the product team changes the dashboard/widget/title to show, we don't have to upda...
NY Times Top Stories OverviewThe New York Times provides an API to retrieve a list of Top Stories and associated images by section (such Home, World, National, Politics, etc.).Sisense provides the New York Times connector as a standalone connector th...
Introduction The present post explains how to connect to twitter using their API to download the list of followers of a twitter account. The solution is based on a script in nodejs that uses this npm module and mongodb. This solution is based on the...
Connecting Sisense to Local SQL Server in Sisense version 7.4.4 and newer Open SQL server and initially connect using windows Authentication.Go to Security > Logins, right click and Create new user as seen in example below.3. Next go to “User Mapping...
Sisense JS Plug N Play - Embed In Minutes! A simple and easy jump start solution for embedding Sisense using Sisense.js on your website! SisenseJSPlugNPlayV1 DEPENDENCIES: JQuerySisenseJsPlugNPlay.jsSisense deployment with open CORSCookie from sisen...
Question: How can I update an embedded widget using a JAQL query and post to /jaql using sisenseJS?Answer:JAQL is just the syntax for querying data - it is not inherently bound to any specific widget or dashboard, which in turn means that executing a...
The above error may occur as a result of a timeout on the SQL server. This is more likely to happen when one or more of the following conditions apply:The MySQL server is at a remote location (possibly with poor network connectivity)Heavy network tra...
Analytical Need You want to display a chart/table with the Top X and Bottom X, all in the same widget Modeling Challenge Sisense allows setting ranking filters based on a measure, but this is only for Top OR Bottom. Solution Widget Filter: ...
IntroductionThere is no OOTB option to roll up a date by the day of the week.Use this simple trick to achieve this with a simple custom field which will display and sort as a calendar day without any additional script.InstructionsCreate an expressio...
IntroductionQuick functions are a great way to perform comparative analysis based on time periods. However there is no easy way to do a comparison to date. e.g. YTD vs YTD Last Year. e.g. If today is Sep 27, 2018 then we want to compare Jan 01 - Sep...
IntroductionUsing line markers can be a great way to compare data whether it be over time or across a category. However, creating a marker requires using the Javascript API to hide the line. The steps below outline how to remove the line from a serie...
Question: I am looking for a way to hide the latitude/longitude from the tool-tip in a scatter map. It appears by default and I searched through other posts but couldn't find anything. I still want the tool tip to appear, just remove the lat/long. ...
IntroductionThe purpose of this article is to show you how to use a bar chart as an indicator to provide an overview and allow you to make selections.Bar charts are normally used to provide quantitative visualizations across wide sets of data. Howeve...
The purpose of this post is to provide the instructions to use a bar or column chart to create a widget where you can compare a value such as revenue to multiple goal levels. In order to do this I had to add a slight modification in the Elasticube. T...
Purpose: To create a product aggregation in Sisense (multiplies all values together, similar to the way a sum function adds all values together). Situation: A financial use case has a table with relative daily gains/losses for certain securities (...
ARIMA Model ForecastingARIMA Model Forecasting Mean and Upper 95% LimitOVERVIEWIn this article, we tackle how to produce a robust forecast by using the Sisense and R integration.UNDERSTANDING THE NUANCE OF RFor forecasting functionality, we must cons...
Challenge When you set the Carousel to false the widget will stack new items vertically. When we want the widget to populate itself horizontally we can use this code to change the display to inline-block instead of block. Solution In the widget edit...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
