Build Analytics

Forum Widgets

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.4KViews
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
2KViews
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
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
1KViews
0likes
2Comments
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.3KViews
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
864Views
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.7KViews
0likes
4Comments
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.2KViews
0likes
3Comments
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.6KViews
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
1KViews
0likes
1Comment
Sum based on OR condition
Hi. I'm trying do a simple sum based on OR condition of 2 column of a table. For now I just want to display a number (that later I will use for a more complex widget) by summing the elements of the ...
vatojavier
03-14-2024
dashboards & reporting
1.8KViews
1like
4Comments
Amend a Granularity button to filter as well
Good day all, Can someone please assist me with creating a custom action, I have tried everything but I cannot get it to work I have these date granularity buttons, But I need the button to affect...
Juandres
03-13-2024
Blox
1.2KViews
0likes
1Comment
Dashboard Filters
I am creating a dashboard , in the filters i have put the time field , and i want to see my table at quarter level , but , the filter is taking quarter1 from jan to march , But i want to customize th...
harish
03-12-2024
dashboards & reporting
902Views
0likes
1Comment
First occurrence of a field
Hello. I work with healthcare dashboards. For the data elements that have one-to-many relationships, is there a script for a widget, so that the table within the widget only selects the first field o...
pcho
03-11-2024
dashboards & reporting
1.2KViews
0likes
4Comments
Pivot Table Custom Sort
I have a pivot table that lists member names, as well as sales totals. Can I customize the sorting of the table in some way that has the members with the highest overall sales shown in order? The sal...
Jack_Machesky
03-11-2024
dashboards & reporting
1.3KViews
0likes
1Comment
Time periods by specific day of month (e.g. first Friday, Second Wednesday)
Like many businesses we bill clients monthly. We bill 25% of our clients split up between the first, second, third, and fourth Friday of the month. I could see a similar use case for periodic custom...
DrewGillow
03-08-2024
data models
1.1KViews
0likes
2Comments
Consolidating filters
I have a dashboard that has 3 filters that all need to be used to show statistics for the same company. What is the best way to consolidate these filters into one so that the user only needs to enter...
Jack_Machesky
03-08-2024
1.3KViews
0likes
3Comments
Date Filters - List
I have a dashboard that looks at diversity and demographic information for my company, and a key piece of its functionality is the ability to select a specific month/year so our users can view inform...
donnyduwitt
03-06-2024
dashboards & reporting
Human Resources Analytics
2.4KViews
0likes
4Comments

About Build Analytics

885 PostsCreated: 5 years agoLatest Activity: 01-09-2022