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

Forum Posts

Resolved! Un-weighting an average value

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

pcolson_0-1644269338393.png
pcolson by 8 - Cloud Apps
  • 534 Views
  • 5 replies
  • 0 kudos

Resolved! Conditional Color Coding of Table Cells

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

DanB by 7 - Data Storage
  • 458 Views
  • 2 replies
  • 0 kudos

Resolved! Linux pivot2 - how to replace null with '-'

In Windows, with pivot1, we were using the following script to replace null values with a dash (-). We've moved to Linux and are aware the script will not work. What script should we use to accomplish the same replacement? Old script: widget.on('read...

cglowe by 8 - Cloud Apps
  • 358 Views
  • 2 replies
  • 0 kudos

Resolved! Calculate value from same period last month

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

Resolved! Contribution function returning wrong values

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

amelia by 9 - Travel Pro
  • 542 Views
  • 2 replies
  • 0 kudos

Resolved! Elasticube update when querying an elasticube with Python

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

Laris_Fdz by 8 - Cloud Apps
  • 354 Views
  • 2 replies
  • 0 kudos

Elasticube has no data. Please rebuild the Elasticube

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

Using answer to a calculation within another calculation

Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up. This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total numbe...

CLewis_0-1643412425107.png CLewis_1-1643413787436.png
CLewis by 8 - Cloud Apps
  • 925 Views
  • 4 replies
  • 0 kudos

Resolved! Lines on scatter chart

This seems like a very trivial question, but I couldn't seem to find an answer. If I have a scatter chart, I would also like to show the calculated average of the x- and y-axis spanning across the chart. For example if the average of the points on th...

taek_onvi by 7 - Data Storage
  • 794 Views
  • 6 replies
  • 0 kudos

Choose the latest date available in a dashboard filter

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

analytik by 7 - Data Storage
  • 413 Views
  • 1 replies
  • 0 kudos

Issue In Sorting X-axis Labels

Hi Sisense Community.. I am having an issue in arranging the x-axis labels in Heat Map. In this first we have chosen scatter chart and then converted in to heat map using the below code widget.on('beforeviewloaded',function(se,ev){ev.options.chart.ty...

Heatmap.png
Chandra by 8 - Cloud Apps
  • 337 Views
  • 1 replies
  • 0 kudos

Resolved! Dashboard expression for 2 events happening in time period

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

mattmca by 8 - Cloud Apps
  • 581 Views
  • 4 replies
  • 0 kudos

Resolved! Ceiling Calculation

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

CLewis by 8 - Cloud Apps
  • 402 Views
  • 2 replies
  • 0 kudos
Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!