Hello all, I have what I hope is a simple question. We have a database that can be boiled down to the image below. Each entry has a date (YYYYMM) and whatever the monthly member count is for that entry (Members). We want an average member count o...
Hello, fellow analytics enthusiasts. I have a widget script that color codes table (not pivot) cells based on their values. This code works, but only on the first page of table results. If I switch to page 2, 3, 4 and so-on of the table, the resul...
When querying an elasticube with Python I have noticed that I cannot query a newly created (and built) custom table.Let's say I create a new table in some model that t I want to export with API request, I rebuild the cube and then run the request. Bu...
Hi, I need to solve this scenario: I can calculate the current month sales, from 01/02 to 04/02, but I need to compare the same period last month, this case, 01/12 to 04/12 last year. In order to check how the value it's going. Do you know how to sol...
Hi all, as seen in the screenshot, I would like to get percentage values for each cell based on the grand total. However, when I use Contribution(), it returns the percentage relative to the total per column. I would like to get the total based on th...
Hello:Has anyone run into the error "Elasticube has no data. Please rebuild the Elasticube" on the Sisense Server Console after attempting to open a dashboard with Pivot table widgets? This is happening on only one of our elasticubes and not every ti...
Hi , Is it possible to create a clustered view for box and whisker chart? Please find the attached snap for your reference. Thanks in advance
Hello, I've been struggling to get a dashboard expression to work correctly. I have daily data for customer visits to a website. In this data, I have a column called "UserFirstLogin" which has a value of 0 or 1 and indicates whether that day is the f...
Wondering if any knows a way to use the ceiling calculation to round to the nearest 1000? I am trying to recreate this Excel calculation. =CEILING(P4,1000)-100 P4= $379,083.04 answer should be $379,900
Assume a date dimension. It contains a series of dates. The latest date available as a value is not necessarily today or yesterday as it could be mentioned in the dashboard filters. The need is for the dashboard filter is to select the latest date av...
Can you give me some tips on how to connect an elasticube to a PI Historian server? Is there an add on for PI Historian that I need? We want to combine data from an Oracle database with PI Historian data to show both in a dashboard.
I am trying to change the order of the columns. I would like the order be from the left: National, My-Group, Firm 2113, etc. Is it possible? Thanks! Kit
Hello Sisense Community! Is anyone aware of a method to dynamically round data labels so that: Any value >= 1000.00 shows two decimal points (green in the screenshot)Any value < 1000.00 shows 0 decimal points (yellow in the screenshot)
I have a BloX widget that builds a simple table of name/value pairs. The data has 16 rows and I have showCarousel set to false so all data is displayed. When the widget is rendered, only the first 10 rows of data are displayed. Using Chrome's deve...
I have a BloX widget that builds a small table of item/value pairs. I want to show the entire table so I have showCarousel set to false. The table builds fine but only the first 10 items are shown in the widget. (There are 16 total.) This page: ht...
