Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

How to create a new column with percentiles?

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 ...

percentiles.jpg
leo82 by 9 - Travel Pro
  • 1824 Views
  • 1 replies
  • 0 kudos

Live Model slow despite filtering

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...

Tim by 11 - Data Pipeline
  • 963 Views
  • 0 replies
  • 1 kudos

Re-Order Pivot table Items

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 

Juandres_0-1684409056397.png
Juandres by 8 - Cloud Apps
  • 990 Views
  • 0 replies
  • 0 kudos

Rank based on each month

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....

tsaho8_0-1684222544910.png
tsaho8 by 9 - Travel Pro
  • 2606 Views
  • 4 replies
  • 0 kudos

Table Join

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...

Displaying Opening Balance for Date Range in Pivot Table

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...

Laflet by 9 - Travel Pro
  • 780 Views
  • 0 replies
  • 0 kudos

Resolved! Removing 1st and 2nd Row on CSV

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?

galos11 by 7 - Data Storage
  • 1727 Views
  • 1 replies
  • 0 kudos

Accessing custom columns/tables from Notebooks

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...

prakashp by 8 - Cloud Apps
  • 1281 Views
  • 1 replies
  • 0 kudos

Changing variable names in hierarchies

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...

Anonymous by Not applicable
  • 2565 Views
  • 2 replies
  • 0 kudos

Wrong range in dynamic buckets

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 ...

nikitabansal_0-1662039982058.png

Importing data models from dev to prod not working

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...

alice_gu_0-1680200360038.png alice_gu_2-1680200684184.png

Export from Linux into Windows

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...

Tim by 11 - Data Pipeline
  • 827 Views
  • 0 replies
  • 0 kudos

Selecting Hierarchies for Drilling

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, ...

KHConsult by 8 - Cloud Apps
  • 1236 Views
  • 0 replies
  • 0 kudos