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

Forum Posts

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
cartercjb by 9 - Travel Pro
  • 144 Views
  • 8 replies
  • 0 kudos

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
  • 175 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
  • 191 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 8 - Cloud Apps
  • 271 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 9 - Travel Pro
  • 535 Views
  • 1 replies
  • 7 kudos

Resolved! Benchmarking in Sisense

What is the best approach in Sisense for sharing benchmarking information while maintaining customer confidentiality? When I was a Sisense customer a key differentiator for us was showing our customers how their performance metrics compared to others...

Silutions by 9 - Travel Pro
  • 650 Views
  • 6 replies
  • 2 kudos

Resolved! Live Data Model Performance

What is the best way to improve performance of live data models where granular data nodes are required and contain millions of records?