Questions tagged [sisense]

Sisense is a business intelligence product that enables non-technical users to join and analyze large data sets from multiple sources, and also create visualizations, like dashboards and reports

32 questions
2
votes
2 answers

How to calculate running sum for each group in MySQL

Straightforward summation I can do with sum() function. But I've a different situation here. I've a table Student with only 2 fields. For instance just assume that there is only 1 student in the entire class: CREATE TABLE student (`dateOfExam`…
Tanzeel
  • 4,174
  • 13
  • 57
  • 110
1
vote
2 answers

Possibility of Migration from Sisense to Microsoft Power BI

We are using Sisense for our reporting tool. We have too many clients using Sisense. This clients have a lot many dashboard , widget. Sisense store data in mongo db. I don't have an idea about Microsoft power BI. Is there any possibility to build…
Mr. K.D.
  • 31
  • 3
1
vote
0 answers

How to export Angular page into PDF

I'm using Angular 6. I found one question here but it doesn't have an accepted answer. Also I tried some code and PDF export is happening. But my problem is that one specific graph is not exported. Screenshot from Angular app: But when I export…
Tanzeel
  • 4,174
  • 13
  • 57
  • 110
1
vote
0 answers

How do I call l two javascript functions concurrently to perform an operation on the same data column?

Java script newbie here. I have this Sisense function called 'handler' that will make all values in a column a hyper link: widget.transformPivot({ type: ['member'], rows: [ { title: 'Product User', } ], },…
Kierk
  • 476
  • 6
  • 23
1
vote
1 answer

How to keep a js script in local project structure and use it [Angular]

I need help. I'm working on an Angular project. I'm making some API calls (GET/PUT) to a remote server. To save time and prformance of my application I thought let's keep it in my local itself. So, I downloaded the JS file and kept it in assets…
Tanzeel
  • 4,174
  • 13
  • 57
  • 110
1
vote
1 answer

How to use sisense custom plugins

I've downloaded and installed Sisense V 8.0.1.10112 on my local machine. I wanted to learn the Plugin mechanism of Sisense. I downloaded HelloWorldWidgetfrom the list and extracted the contents to C:\Program…
Tanzeel
  • 4,174
  • 13
  • 57
  • 110
1
vote
1 answer

How to create a re-usable plugin using ReactJS

I'm working on a Business Intelligence tool, Sisense. It lacks some of the features like Date picker or Calendar. Is it possible that I create a plugin using ReactJS and somehow integrate it to the Sisense. Well, I'll take care of the integration…
Tanzeel
  • 4,174
  • 13
  • 57
  • 110
1
vote
1 answer

How to querying on build sisense elastic cube?

I am new in Sisense tool. I have created elastic cube in Sisense and built this cube successfully. Now the elastic cube result does not match the source database result. So is there any way to execute a query on Sisense built elastic cube to…
NP007
  • 659
  • 8
  • 21
0
votes
0 answers

How to get organizationId to sisense I am using auth0 with SAML 2?

I was trying to integrate auth0 with Sisense using SAML 2. I added the two screens while login so that user will first enter the organization name and then user credentials and password. Now is the issue is I am not able to get the organization name…
0
votes
0 answers

How to Share JavaScript Across Sisense Dashboards

I'm updating some of the dashboard and widget scripts in a Sisense application. There is a bunch of repeated code I'd like to abstract into some common functions to use on multiple dashboards. What's the best way to share JavaScript across multiple…
jbyrd
  • 5,287
  • 7
  • 52
  • 86
0
votes
1 answer

How would I calculate the quotient of 'churn' with the previous month's 'active'?

Trying to get the churn rate, obviously. Getting the quotient within each month would be easy but incorrect. Frankly, I'm totally lost on this one. Would it make more sense to reorganize the output first?
0
votes
1 answer

Is there a way to subtract a number whenever a value is between two other values on SQL

I'm working on a custom column on SQL. We want to see the average datediff but we need to exclude the weekend. In my opinion, subtracting 2 from any value between 7 and 13, subtracting 4 from 14 and 20 etc would be the best way of doing this. Is…
HHobbs
  • 1
0
votes
0 answers

How to start with Power BI. Using Sisense as of now

May be this is stupid question. I am using Sisense for the analytics. Back end is SQL Server. Now we are thinking to move to Power BI. When I search for Power BI I see different versions. 1) desktop power bi 2) azure power bi. Does both are same ? I…
Mr. K.D.
  • 31
  • 3
0
votes
1 answer

Custom Sisense Bar Chart using Blox Progress Bar not working

I want a Progress Bar that will display my current sales in comparison to the target. I found a similar tutorial and followed it exactly This is the tutorial I followed…
Coder1990
  • 89
  • 8
0
votes
0 answers

How to take a value from one column, and have it expanded with it's own details in the following row in SQL?

I have the following result set after pulling the details for car prices from a car prices table: Car ID Price Price adjusted by adjustment amount 1234 $100 5678 -$50 0000 $650 5678 $349 How do I write a SQL function, so that if…
1
2 3