Newest TopicsMost ViewedNo Replies YetNo Solutions YetSolutionsTagged:TagFreezing header row in pivot table Hello, I've researched the past discussions for this question and did see that the advised solution was to disable the pivot table's Auto Height setting and adjust the height of the widget until a s...Dashboard breaking when using Shared Formulas Hi, our team enabled shared formulas in DEV and PROD. We create the dashboards in DEV and migrated to PROD. When migrating the PROD we are getting this error. If I edit the widget and go the 'values...Modeling patterns There are a couple of dimensional modeling patterns that you see out there, that I'm wondering if Sisense supports correctly. 1. Snowflaking - (I don't mean Snowflake the database) - having rollup, ...How to apply filters to customized drop-down list? Hi, I've built a drop-down list with customized values; please see below: "type": "Input.ChoiceSet", "id": "data.filters[0].filterJaql.members[0]", "class": "", "value": "", "displayType": ...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. 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. ...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 Communi...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 m...Need advice on a project Hello, I'm a french student in computer science in my 4th year and i'm in an internship with a company since 2 weeks. My job here is to be a data analyste and i'm struggling on my first project. T...Correlation Matrix in Web-Based Sisense Fusion? Hi everyone, I'm trying to generate a correlation matrix in web-based Sisense Fusion. This is possible in Excel, in Python, etc. but I cannot yet figure it out in Fusion. I'm attaching an exampl...Notebooks R Code ERROR: Failed to parse run metadata json with error: Unexpected token '<', "<?xml v Hello, I'm getting this error when trying to run basic R code in Notebooks and cannot figure out how to fix it or why it is even occurring. Any thoughts would be greatly appreciated! ERROR: Failed...is there any way to embed ecube manager to show ER diagram in webpage? We are planning to integrate the Sisense ecube manager (especially the screen which shows entity relations of ecube) inside a webpage. Is there any possibility of that? we do not see any API doing th...How can I publish changes to a dashboard without resetting all users' saved default filters? I'm currently onboarding new sets of users to use (as viewers) a set of dashboards in a "beta" program. I'm frequently making updates to the various dashboards and republishing them so my users can v...JTD on Pivot with multiple Facts I am trying to use Jump-To Dashboard plugin for a Pivot table that I have created. My pivot table consists of 3 Rows, 4 Facts and 1 Column (Screenshot Below) : Using the JavaScript for Jump ...Silent Build Problems Data model is scheduled to build daily. However, without indicating an error, it fails to do so. Manual build works and updates data as it should. Please review with me. Conditional color formatting at row level Hi all, I would like to color the rows of pivot table in a gradient manner, based on the min value and max value of each row. By default, the conditional color formatting in sisense works at a colum...Creating a Calendar Analytic with Time using BLOX Hello, I am working on creating a schedule analytic in Sisense and will be mainly using Pivot Tables to do so. Aside from some additional row data added later, the screenshot below shows the informa...Count Unique Reference number based on Monthly data / date created and resolved date Hi! I'm hoping someone would be able to assist me. I'm trying to create a formula that will calculate the number of unique reference numbers I have on a monthly basis. The conditions should be: For...Blox Template Hello I have got a requirement for the following 1. Get an user input as a keyword(which is a word of the complete dimension) 2. Add a search button 3. The user input should be able to filter the ...Sisense pivot table conditional font color format Hi All, Does anyone know of any script so that if the cell value is negative (<0), the font color in Sisense pivot table in all fields changes to red (#ff0000) but all other value formatting (such a...
