Update and add new Highcharts modules for use in Sisense plugins
Update and add new Highcharts modules for use in Sisense plugins The JavaScript library framework Highcharts is natively included in Sisense and is utilized in many native Sisense widgets as well as in numerous Sisense plugins. Although Sisense typically does not alter the Sisense Highcharts library version with every release, the versions of Highcharts included in Sisense may change when upgrading to a new major version release. Highcharts can load additional chart types and other types of functionality via JS module files that contain code-adding features such as additional chart types, which can be used within plugins along with additional code to create additional widget types. If a plugin utilizes a Highcharts module, you can source the module directly in the "plugin.json" file's source parameter, as shown in this example: "source": [ "HighchartModule.js", ], To determine the current Highcharts version being used in your Sisense version, you can use the "Highcharts" command in the web console while viewing any page on your Sisense server. After identifying the current Highcharts version, you can find the corresponding module hosted on the Highcharts code hosting website using the following URL format: https://code.highcharts.com/${Highcharts_Version}/modules/${module_name}.js For example: https://code.highcharts.com/6.0.4/modules/heatmap.js You can save this module and upload it to the plugin folder or replace the older module JS file simply by copying and pasting the code directly. Be sure to update the "plugin.json" file to point to the new module file if the file name has changed or if this is the first time the module is included. Simply sourcing the module file in the "plugin.json" file is sufficient to load the module into Highcharts; no further code is required to load the module.1.3KViews2likes2CommentsEmpty filter at initial load in Linux version?
Has anyone discovered a way to make a single select text filter load "empty" by default? This used to be possible in the Windows version, but now that we have migrated to Linux, we have lost that ability. Use case...we have created dashboards that are deployed and used by different clients (in this case, we display academic data, so our clients filter their dashboards by "Term"). However, our clients all name their terms differently...so we can't set a default value. In Windows you could remove the default value in the .dash file, and then the filter would load empty, therefore making the client choose a value to display data. In Linux, that now causes the dashboard to load ALL Term values....even on a single select filter. This can be an overwhelming amount of data, and cause timeouts. Has anyone solved this type of issue in the Linux versions? Thanks for any pointers.2KViews2likes2CommentsScheduled Build Not Building Table Changes
I have a scheduled build for my Elasticube each morning. The build behavior setting is set to "Replace All" on every table. When I make a change to a table the changes are not being built, new data is being imported but my new columns or where clause changes are not being applied. Also the table still has the triangle play button at the top left of the circle signaling that changes have been made. If I manually build with Replace All or Changes Only then the changes will be applied but I would like for the changes to be made each night when the Elasticube is pulling new data.Solved2.3KViews1like3CommentsHow to allow users to download a table with 300+ columns
I have been given a SQL query that has a column for each day of the year, and about 50 rows with different business metrics. I have also been told that I need to host this query in Sisense for users to download the data. Given the restrictions on table widgets, how should I best go about serving up this data? Currently, I have the query stored in an Elasticube as a table query. Our Sisense subscription also includes the Report Manager add-on. Thanks in advance for any help!Solved2.4KViews1like2Commentsunexpected N\A from PERCENTILE function
We sometimes received N\A results from a PERCENTILE calculation, even though with the same dataset we will get results from other statistical functions like AVG or MEDIAN. I'm wondering if this has to do with a minimum number of values requires to calculate PERCENTILE? Is this defined anywhere? I don't see it in the online function reference. Is there some other common cause for getting an N\A result for PERCENTILE?1.7KViews1like2Comments