In Sisense, I'm looking for a way to create a new column in a table, with percentile values of a different column.I am open to design suggestions/approach. What the best way to accomplish this.Such that: 1. Have a filter created on percentile values ...
SUMMARY:My Live Model is slow. Source data is big, but a dashboard filter picks just one item, so I think it can be fast. This feels like a common use case for a Live Model.DETAIL:My dashboard is based on a live model that queries SQL Server. The use...
Hi, I have a pivot table where there are various areas listed 1-15 but it will order it by the first number in the series ie. 1, 10, 11, 2 , 3Is there a way around this so it will read 1, 2 , 3... 10 , 11
Hi @Angelina_QBeeQ ,I want to set the rank independently for each month based on measure.Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date])As per below sc, rank shd be 1,2,3....for Mar and similarly 1,2,3...for Feb and so on....
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...
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 accountWe have a Elastic cube (EC) model that is built from Snowflake data...
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...
hello I am using dynamic buckets to show number of customers in each spend range for the selected time period, I am using the dynamic bucket plugin. My issue is the highest bucket range i.e. 800 is wrong as the maximum spend I have in my view is 741 ...
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...
Hi Team, How to create below landing page in Sisense and provide jump to dashboard action in each section(IVR,VG...etc).
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, ...
