Build Analytics

custom queries in widgets
I have a very simple ask. When I go into widgets I am able to click on the three dots and hit Analyze SQL Query but I don't see a way to edit it. I would like to be able to edit the query, is there a...
mbussey
04-11-2024
Customer Service Analytics
1.3KViews
0likes
2Comments
Export PivotTable to image crops the bottom row
See the bit in the red rectangle: Sisense version L2023.11.0.387 We have "Full-Size Widget to Image Download" turned on. My guess is it's a bug in the export procedure. Can anyone confirm? Any...
Tim
04-04-2024
Dashboards & Reporting
1.9KViews
0likes
6Comments
Hide First Column in Table and/or Pivot when exporting to Excel or CSV
Requirement: Append table to website so that user can view and download to csv. Export should be in pivot table format. Export should contain data on individual lines and not grouped. Steps to ac...
lhasz
04-03-2024
Dashboards & Reporting
1.5KViews
0likes
4Comments
Data model
I'm unable to see my data models suddenly; they have disappeared. However, the dashboard built with those data models is still visible.
Solved
Krish2456
04-03-2024
AI & Machine Learning
Blox
Dashboards & Reporting
Data Models
2.5KViews
2likes
3Comments
Filter remains in jumping to dashboard even when it has been deleted
Hi friends, I have the following issue. When I jump to dashboard, two filters remain: one of date and another one categorical to filter the last day of the month. I deleted both on the original dash...
Solved
dani314
03-28-2024
Dashboards & Reporting
2KViews
0likes
4Comments
Share Dashboard folder public
Hello experts, In Sisense, assets are private by default. example if you organize your dashboard in a folder, it requires you to share that report individually for each user or group I wonder if th...
ramansingh89
03-28-2024
973Views
0likes
2Comments
Can use use Switchable Dimensions for Line and Area Charts
I am trying to use switchable dimensions pluggin in Sisense for a line chart and area chart using a date dimensional table where my dates are in numerical values for conventionality. I am trying to u...
Solved
Astroraf
03-27-2024
Dashboards & Reporting
Data Models
Information Technology Analytics
Infusion Apps
1.7KViews
0likes
3Comments
Formula to display null values
I have a widget that I would like to replace all null values with values of "0". I am trying to use the following formula: "CASE WHEN ISNULL (PASTYEAR(SUM([Total TotalSales]))) THEN 0 ELSE (PASTYEAR(...
Jack_Machesky
03-25-2024
2.2KViews
1like
7Comments
Return members from dashboard script
My goal is to have a dashboard filter be dynamically hidden based on number of values in an elasticube table that a user has access to. Specifically, if [Tenant].[Tenant Name] returns more than on...
cglowe
03-22-2024
Dashboards & Reporting
1.3KViews
0likes
2Comments
Creating A Burndown Chart In Sisense
Hi all, I want to create a burndown chart with my planned and actual hours for a project across time. I'm unsure what functions would be best to use here - has anyone created one in Sisense befo...
maddymorningsta
03-22-2024
Dashboards & Reporting
849Views
1like
1Comment
Show Title(dimension) with mode price in Pivot table values
Hi Team, I have a table where I am showing Mode Price of the products. I want to show a title of the product along with the mode price. However, this is not able to achieve. I have retailer in the...
zohebakber
03-21-2024
Dashboards & Reporting
1.5KViews
0likes
4Comments
Enhancing Analytical Capabilities
Hello Sisense community, I am interested in learning more about advanced analytics techniques with in Sisense. So How can we leverage predictive analytics and machine learning to enhance our insigh...
AnilAhir
03-21-2024
AI & Machine Learning
1.6KViews
0likes
4Comments
Using RSUM results in BE#208517 Internal Analytical Engine Error: Error while parsing view
Hi all, I'm using RSUM in multiple dashboards/widgets, and recently, these widgets all broke. I'm getting the error found in the title, with a "Formulas used in this widget are not supported in t...
Solved
turtleData123
03-20-2024
Dashboards & Reporting
2.2KViews
0likes
5Comments
Pivot Widget - Maximum Number of Values
Hello community, We came across this post from the old community : https://community-old.sisense.com/hc/en-us/community/posts/115000896608-Table-Widget-Maximum-Number-of-Columns We have tested this...
Solved
MikeGre
03-20-2024
Dashboards & Reporting
2.3KViews
0likes
5Comments
Can I set the default for rows to page to be 75 not 25?
In viewing widgets, there are 3 options to control number of rows displayed per page. they are 25, 50 and 75. What controls the default to 25? I'd like to default to 75 rows per page but I am not sur...
Solved
BeckyCrittenden
03-19-2024
Dashboards & Reporting
1.6KViews
0likes
2Comments
Jump to dashboard - respect drill-downs
I have a PivotTable show $ and Country. It has JTD set up. The user right-clicks on the Country "USA" to drill-down on it into Months. Then they click on "January" to see detailed information about ...
Tim
03-19-2024
Dashboards & Reporting
1.1KViews
0likes
3Comments
script scatter map hover show more than top 10
When hovering over a data point in a scatter map, is there a way to view more results than the current max of 10 ("showing first 10 results")? Perhaps there's a script I could use?
Solved
danblack
03-18-2024
Dashboards & Reporting
1.1KViews
1like
1Comment
Horizontal Contribution
Hi Sisense Devs, I'm using a Pivot Table Visual in which Im using employee_name as my rows, phone state as columns (With over 15 categories), phone state duration as values, I converted the values t...
Solved
ErickRuiz7
03-18-2024
Customer Service Analytics
Dashboards & Reporting
1.5KViews
0likes
2Comments
Multiple Dropdown filter using BloX
Hi, I'm trying to create a multiple dropdown filters, but can't figure what I'm doing wrong to make the filters work. Any assistance will be much appreciated. my Script { "type": "AdaptiveCard",...
nkanda
03-15-2024
Blox
1.5KViews
0likes
1Comment
Change Subtotals position to the top
Hi Team, I want to show the subtotals at the top rather than at the bottom of each group. Can somebody help in this regard Thanks
zohebakber
03-15-2024
Dashboards & Reporting
988Views
0likes
1Comment

Forum Widgets

custom queries in widgets

Export PivotTable to image crops the bottom row

Hide First Column in Table and/or Pivot when exporting to Excel or CSV

Data model

Filter remains in jumping to dashboard even when it has been deleted

Share Dashboard folder public

Can use use Switchable Dimensions for Line and Area Charts

Formula to display null values

Return members from dashboard script

Creating A Burndown Chart In Sisense

Show Title(dimension) with mode price in Pivot table values

Enhancing Analytical Capabilities

Using RSUM results in BE#208517 Internal Analytical Engine Error: Error while parsing view

Pivot Widget - Maximum Number of Values

Can I set the default for rows to page to be 75 not 25?

Jump to dashboard - respect drill-downs

script scatter map hover show more than top 10

Horizontal Contribution

Multiple Dropdown filter using BloX

Change Subtotals position to the top

About Build Analytics

Sisense

Support

Resources