I am providing the correct input, but the API is not functioning as expected for me.
I'm encountering an issue despite inputting the correct data; the Speakatoo API is not operating as anticipated for me.
Forum Posts
Column Chart - Reorder X-Axis
When creating a column chart you'd sometimes want to reorder the category fields Apply the following widget script: widget.on('processresult', function(widget,result) { // Wanted Order let order = ['New','Used','Refurbished','Unspecified'] // For ...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Line chart - Custom sort break by values
Hi Team,Can anyone help me share the script to custom sort the break by values in the line chart.I tried the same approach for the line chart as for pivot rows:https://community.sisense.com/t5/knowledge/pivot2-table-row-custom-sort/ta-p/9096#:~:text=...
Hide column in pivot table
HI ,Need help to hide a column in pivot table .In the attached image i am trying to hide column ID.
Visual datamodel for end-users and data dictionary
Hi,As an OEM we give our customers the possibility to use designer-accounts to create their own reports. The difficulty we have been struggling with is how to simply explain our complex datamodel. We have been working on a solution that we want to sh...
How to get list of dashboards and custom table(s) that are used in each dashboard?
I have figured out how to get list of custom tables in Sisense by connecting to MongoDB server and prismWebDB database. But then I run into some issues and would like to get guidance from the Community:I get list of custom tables from DatasetTables t...
Resolved! Seeking Advice: Importing Data from Elasticube to Pandas DataFrame in Sisense Jupyter Notebook
I'm looking for help with using Sisense and Jupyter Notebook. Here's what I need to do:Load CSV data into a Sisense Elasticube table (Table A). (this I know how to do)Transfer data from Table A into a pandas dataframe for processing. How?I found a re...
Pivot table grand total aggregation not working in line chart
Hi Team,I have calculated the manufacture share on pivot table at two levels ( Retailer and Category) using the formula:dupcount([custom manufacturer_sort])/(dupcount([custom manufacturer_sort]),all([custom manufacturer_sort]))Now, the default grand ...
Landing Page for Choosing the dashboards
Hi, I am trying to create a landing page using Blox, where it should allow users to click a button and it shows the list of dashboard under that category. I could not find any resources where this is achieved. It would be great If I can get some lead...
Resolved! BloX Title Style Missing from PDF Report
When I create a PDF Report of my dashboard, I have noticed that the title styling for all of my BloX widgets disappears. Here's the relevant snippet from my BloX Editor: "titleStyle": [ { "display": "true", "backgro...
Line Polar Chart (Line) : Set 0 as Min value
For a Polar Chart of type "Line" the UI will not allow the value of 0 as the minimum (it resets it to the minimum value from the data provided).The other polar types - column and area allow this.Is there a way to change this via script?
Error: "Live models can have only one dataset"
I clicked "Duplicate As Live". I got an error "Live models can have only one dataset".I made sure I only have one dataset (see left side of picture below). So why am I getting the error?I did refresh schema on all tables, and made sure they all point...
Get ElastiCubes Metadata: list of Elasticubes, tables and columns Data Model
Hi, We often need to have the metadata report about all Elasticubes and their contents. To cover this gap, we have developed an ElastiCube that is based on the REST API v2.0, which creates a data model for this purpose: There is a custom code algori...
Resolved! Newer version of Highchart?
There are features in the more current versions of Highchart that I want to be able to use. It looks like our server is on Highcharts v6.0.4. Does Sisense intend to move to a more modern version? Or is this something that we can upgrade ourselves?
Resolved! Dynamic Value-Names in Pivot Table
Hi folks, I am trying to name the "value" columns in a pivot table in a dynamic way.I have a table that compares the last month data, with the data the month before. Right now, on the 6th of November, i would compare "October MRR" with the "September...
