Stack Overflow
Stack Overflow

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
0
votes
1 answer

Sisense, display number of days in date filter

Have a date filter on the dashboard that allows for a custom date range: Dashboard Date Filter How can I add a the number of days in the filter to a formula? Just trying to show the number of days in column of a pivot table. In this example the…
kjohnson
  • 1
  • 1
0
votes
2 answers

How can I sort a table by two columns in sisense?

I use Sisense Version: 20.21.6.10054 on Windows. I need to sort a table widget in sisense by two columns, first by name, and second by number of behavior that person demonstrates. The result should look like this: id first_name last_name …
Nadzeya
  • 1
  • 1
  • 3
0
votes
1 answer

Can you overlay an image with text using BLOX in Sisense

I want to create a BLOX widget to be used as a banner at the top of my dashboards. The body of the widget contains an image. I want to place some text over that image but I am not finding a way to do that. I can create a second item in the body…
David O.
  • 31
  • 3
0
votes
2 answers

Sisense continuous timeline until today(without value from data)

is there a possiblity to create continuous timeline until today, even if today has no values? I see in documentation we can fill missing gaps,…
bennes
  • 71
  • 1
  • 3
  • 10
0
votes
1 answer

Gantt Chart in SiSense

I am little surprised there is no Gantt Chart available in SiSense (off the shelf). I understand there is a plugin available, but we were not able to integrate that. I believe it has something to do with the version / OS. We are currently on SiSense…
Vignesh Iyer
  • 1
0
votes
1 answer

Application fails when free memory is low but available memory is high

I am building data models via an app called Sisense on Linux. Lately the process fails with an out of memory error. Running free -h I see that that the failure occurs when free memory is low, but before it actually reaches zero and even though…
Kierk
  • 476
  • 6
  • 23
0
votes
1 answer

filling missing rows with currency

I have the following table (with different currencies): date currency ex_rate 30/11/2020 00.00 USD 0.8347245409015025 27/11/2020 00.00 USD 0.8387854386847845 26/11/2020 00.00 USD 0.84033613445378152 As you can see, there is some…
enriqueqs
  • 59
  • 5
0
votes
1 answer

Replacing Sisense Smart Label Widget With Blox Widgets

I am trying to learn Sisense Blox. I watched the videos and looked at the docs but am still unclear how to replace a specific Smart Label Widget with Blox. Below is the widget and config. Is there a Blox Template that I could use to recreate this…
Kierk
  • 476
  • 6
  • 23
0
votes
0 answers

Calculating Count For Difficult Pivot Table With Merged Lines in Sisense

I want to calculate count of ORDER_DISP_NO for each DISPLAY_SKU like count(ORDER_DISP_NO) group by DISPLAY_SKU. For example it should be 6 for first row and 2 for third row. Please see screenshot Looks like I cannot use DupCount() in this case but…
Eugene
  • 27
  • 5
0
votes
2 answers

Visualizing headcount data over a particular time period

I have a data visualization question that I would like to get some input on. I'm currently using python pandas to clean up a data set then subsequently uploading it in SISENSE for use. What I am trying to do is visualize active jobs grouped by…
Ellaine
  • 43
  • 5
0
votes
1 answer

Sisense - How To Customize UI

I'm a total Sisense noob, but am being tasked with customizing the look and feel of the Sisense app. Out of the box, it looks similar to: For starters, I need to customize the header and left nav (highlighted in the screenshot above). I've read…
jbyrd
  • 5,287
  • 7
  • 52
  • 86
0
votes
1 answer

Filtering pivot table in Sisense with negation

I'm trying to implement a simple filter in Sisense, but I can't figure it out. My data is stored in a PostgresQL DB. A minimal example looks something like this: CREATE TABLE fact_table ( first_name text, salary integer ); INSERT INTO…
ahanf
  • 59
  • 1
  • 7
0
votes
1 answer

get CTR or clicks/Impressions via sisense from google analytics

I have CTR, clicks in the Google analytics. I want to get these data via sisense. According to the instruction https://documentation.sisense.com/7-1/managing-data/connectors/google-analytics.htm#gsc.tab=0 I use elastiCube manager to create an…
Eugene
  • 27
  • 5
0
votes
3 answers

What is the reason behind a Full outer Join resulting in more rows than either parent data set?

I'm working with two sets of data that I am trying to combine via a Join command (not a Union). I don't think I understand the basics of joining. I used a Full Outer Join as follows: Select Table1.col1, Table1.col2, …
K.Doe
  • 39
  • 1
  • 9
0
votes
1 answer

How Do I Create a New Column From a Column Newly Added by a Join?

Using a left join, I have brought together data from two tables. From the data I brought in, I also created a new column using a logic statement (the AOIMonth column). The question I have is, how do I create another column using another logic…
user12815408
  • 15
  • 3
1
2
3