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=...
HI ,Need help to hide a column in pivot table .In the attached image i am trying to hide column ID.
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...
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...
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...
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 ...
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...
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...
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?
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...
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...
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?
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...
Good morning, I'm starting to use Shared Formulas on Sisense and I would like to know how we do the release of them for another environment. This is my situation: 1. I have a dashboard in DEV, where I created the shared formulas and used them in some...
I'm getting an odd bug in Fusion Pivot tables where columns will not sort (except first column which /can/ sort). The first column (a list of the names of various schools) will sort just fine ASC and DESC. For any other column sorting has no effect....
