I'm having an issue joining two tables an suspect it's due to the integer value within the tables. In SQL, I'd join like this:SELECT top 1000 * FROM tblOrderRouteStops R WITH(NOLOCK)INNER JOIN tblOrderRouteStopsParcelAssigned PA WITH(NOLOCK)ON R.PKID...
Hi @Angelina_QBeeQ ,I want to set color(red & green) of Rank cell based on Overall Vol measure.if Overall Vol>2000 then Rank cell will be Red else Green.Logic of Overall Vol is Count(call)
Hey everyone, I’ve got a table with an opening balance that shows the date and total quantity on that date. There’s another table I’m working with that has transaction details and their values (transaction date and quantity). What I want to do is dis...
Have a csv file that is being created out of a platform that adds a date created on the first row, blank 2nd, then the header, and data. Is there a way to remove the first 2 rows easily?
Would like to see the ability in the elasticube (or somewhere else) the ability to set default formatting for measures. For example, you know that field A is a field containing a monetary value. You set the default number of decimal places, symbol an...
I'm looking for ways to access custom columns/tables that are created within Elastic cube data models, from `Notebook` feature within Sisense. Context: We have a Sisense cloud account We have a Elastic cube (EC) model that is built from Snowflake dat...
Hi all, I am trying to export a data model (.smodel) from development server (Version: L2023.3.0.188) and import it to production server (Version: L2023.2.0.152). However, I was not able to successfully import the data model, specifically, the data m...
Hi Team, How to create below landing page in Sisense and provide jump to dashboard action in each section(IVR,VG...etc).
Hi, I am trying to change the names of the variables in a hierarchy. I can change the name of the actual hierarchy but I can't figure out how change the variable (column) names. I could do this very simply on previous versions of Sisense but it doesn...
We want to develop on Sisense Linux, but continue to support Sisense Windows. Is there a tool/feature to export a cube/dashboard from Linux and then convert it to Windows-Sisense-compatible JSON? I know some features aren't available in Windows, so i...
I am setting up hierarchies for the drill hierarchy feature in Sisense. Out of the box, I see that the user can right click and select a field to drill into. It shows every table and column that is available in the Data Model. To limit the options, I...
I have unused cubes. I want to remove them to save disk space. But I'll later want them and their dependent dashboards again. And I might want to keep things like schedules, hierarchies, sharing, etc. So, I want to "unbuild" them - delete all the dat...
Hi Sisense Community, I am attempting to create a column chart that shows the count of users that have logged into our product in a given month, and then along side that, show the amount of users that logged in for the first time that month. For exam...
I see how the core Sisense application can handle different languages or handle localization for number and date formats. How do i provide language localization of the schema (table and field labels)? How do I provide language localization of the wid...
Hi team! I'm looking for information about Sisense limitations, like the maximum number of ElastiCubes, tables per cube/instance, columns in a table, dashboards, etc. I've been trying to find such information in the documentation but with no luck. Is...
