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

Forum Posts

Values not appearing in pivot table

Hi all, I am creating a pivot table widget in Sisense and the values are all showing up as 0. I double-checked the widget JAQL and they're all using the same table so that shouldn't be the issue. I also checked the Sisense analytics for the table and...

amelia by 10 - ETL
  • 431 Views
  • 2 replies
  • 0 kudos

Resolved! How to grant View only Access on the Elasticubes to Designers

I am trying to figure out is there a way to grant View only Access on the Elasticubes to Designers/Contributor Role so that they can view the Model while developing the reports without modifying the underlying model.I tried to set via RestAPI but I a...

Rajesh by 8 - Cloud Apps
  • 248 Views
  • 1 replies
  • 2 kudos

Resolved! How to create Custom Columns: ThisWeek, ThisWeekPrevYear?

Hi,I am trying to create two boolean Custom Columns in my DimDate table to flag data in the current week, and data in the same week, previous year. This type of flag is easy to create for a monthly resolution, but weeks are tricky because they can sp...

EricB10 by 8 - Cloud Apps
  • 597 Views
  • 4 replies
  • 0 kudos

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
  • 682 Views
  • 5 replies
  • 0 kudos

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
  • 1215 Views
  • 4 replies
  • 0 kudos

Resolved! CONDITIONAL CASE SUM

Hi Sisense Community!! Please reference the attached workbook that I drafted in Excel. I am trying to draft a daily view by week, of each employee's time worked. This screenshot shows an example of actual hours worked by day by employee. I am trying ...

cartercjb_0-1642558402277.png

Connect to PI Historian

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.

20211021_181719_sm.jpg

How to create a table with a range of dates?

Hi,I have a use case were I have this tableI want to plot in a chart in continues dates (i.e. from the minimum date of launch_time to the current date).e.g. 1/1/20 - 1/12/22 and count the number of instances that were alive in a certain date based on...

TomerA_0-1641974345286.png
TomerA by 8 - Cloud Apps
  • 699 Views
  • 3 replies
  • 0 kudos

Not connecting to Azure cloud SQL via Federator

We are using enterprise version of Sisense using another UserName , when we connect directly from Sisense source connection MsSQLserver we are able to successfully login Azure cloud SQL(this is the vendor cloud- where the Sisense IP is whitelisted in...

Dskumar87 by 7 - Data Storage
  • 432 Views
  • 1 replies
  • 0 kudos

Tips on Managing Formulas / Getting Consistent Calculations

Question for y'all: How do you maintain consistent calculations of key metrics? Custom columns in the data model won't work b/c I need aggregations that can be easily filtered (e.g. can't add activation % to my base table b/c my stakeholders want to ...

hlorosc by 9 - Travel Pro
  • 834 Views
  • 4 replies
  • 0 kudos

Analysing EC Builds

I was looking for a way to analyse EC Builds in an easy way to identify where potential bottlenecks within the buildprocess could be. I have created a python script which exports EC build logs (can only export latest build logs) to JSON and converts ...

Screenshot_40.png
HamzaJ by 10 - ETL
  • 1097 Views
  • 1 replies
  • 7 kudos