Sisense Help and How-To Forum

How to display current date in the header of the dash board using Blox code ? any help

Hi All ,Kindly help me to display current date on the dash board which is used in BLOX code, below is the screen shot of the my requirement.

Sisense is Getting a Customer Newsletter! We want your input!

Hello, fellow community members! I am so excited to share that Sisense is releasing a monthly Customer Newsletter! We want this newsletter to serve our customers and provide you all with what you need to be successful. So, with that... we would love ...

Column freezing for a table

Hello Everyone,We are trying to enable a feature where we can freeze the first column and on its reference, scroll down the others.Is there any JAQL script to perform this action or any other method to do so.Thanks.

Resolved! Tenants migration

I'm a new user using the Sisense platform as a Developer.I'm planning to create two tenants for two apps (second app will be ready in the future) in one server, however, before implementing tenants, I need to know if it is possible to migrate users...

Resolved! Applying a filter on a dashboard with two data sources

I have a dashboard that uses a Live model and Elasticbube mode and both use the same dim tables. One being dim_date and the other being dim_endpoint. If I want to apply a filter from these dim tables to be applied across the whole dashboard knowing t...

Resolved! Add Comments to Blox

This may be a stupid question, but how to I add comments to the Blox editor? // and /* */ both seem to work as I edit the script. However, after hitting "Apply" and returning to the editor my comments disappear. Some of our scripts get really long an...

Resolved! Change Widget Description

Apologies if I've missed it, but has anyone written js for changing the Description section of a widget? It's the same section of a widget where the edit pencil appears. I would like to change the font color, size, ...

Resolved! Embed image stored locally to blox

Hi, does anyone know how to add an image that is stored locally using blox? We found this article to embed image stored in google drive, but we want to do this with an image stored locally. https://community.sisense.com/t5/knowledge/how-to-embed-an-i...

Resolved! Limit Dashboard Sharing to a Group

Is there a way out of the box to limit users to sharing within their own group? For example:Group A has User 1 (designer), User 2 (viewer), and User 3 (viewer)Group B has User 4 (viewer)User 1 can create a dashboard and share it, however in the share...

Resolved! Date and Time Functions

Hello, is it possible to add the Add features to sisense cloud-hosted environment Formula Editor? We don't have any of these functions available inside of the Formula Editor.ADDYEARS(datetime, number)ADDQUARTERS(datetime, number)ADDMONTHS(datetime, n...

Resolved! Widget Data Not Included in Downloaded CSV After Calculation (Table Widget)

Hey all,I'm using a script to calculate a total value, and inserting said value, into a table widget. It sums up the quantity column, and presents that sum in the last cell of the column. This displays information correctly, and works as a widget. Ho...

Calculating average units for two years

Hello. I am trying to calculate the average of my 2022 and 2023 unit totals. This metric is calculated by doing a DUPCOUNT([AccountId]) in my widget. Yes, I am using the dupcount on purpose. I tried making a custom column to calculate the totals for ...

Seeking Recommendations: Sisense Hands-On Training for ETL Workflow and Dashboard Creation

Hello everyone,Hope you are doing well.I have reviewed the content available on Sisense Academy, and it appears to be good and informative. However, I am currently seeking hands-on training materials for ETL workflow, Elasticube modelling, and dashbo...

Resolved! Excluding from an existing Dashboard filter using BLOX

Hello,I had an earlier challenge which was solved by Daniel (@rapidbisupport). Thank you!Now, I'm hoping to take this one step further. After the Dashboard filter has been created, I'd like to create another BLOX button to remove specific filter entr...

Resolved! Widget Display Not Updating On Dashboard Filter Change

Hi all,So I am running the following script on my widget (using 'edit script') in order to grab the date of the maximum dollars for a year using a different bar chart widget on the dashboard, and display that date (along with the $ amount) on an indi...

Personalized Data Insights Widget: Deliver personalized insights tailored to each user’s preferences or role, with Sisense managing the data modeling behind the scenes.
Custom Notification & Alerting System: Notify users when key metrics change, with Sisense monitoring data and triggering real-time alerts, enhancing proactive decision-making.
Embedded Data-Driven AI Recommendations: Add AI-powered recommendations to your app, such as product suggestions or customer retention tactics, leveraging Sisense’s predictive analytics.
Self-Service Data Exporter: Enable users to export data from Sisense dashboards in multiple formats (CSV, Excel, JSON) for easy offline analysis.
Embeddable AI-powered Widgets and Dashboards: Offer AI-powered insights like sales or inventory forecasts, revenue insights, etc directly in your app, with Sisense handling all the data modeling and AI creating the actual widgets for you.
Interactive Goal Tracking System: Allow users to set and track KPIs in real-time with Sisense providing up-to-date data visualizations for an engaging goal management experience.
In-App Dashboard Customizer: Empower users to personalize their dashboard experience by rearranging widgets and adjusting filters, while Sisense takes care of the data accuracy.
In-App Decision Support System: Let users simulate different scenarios (e.g., budget planning) and see data-driven outcomes using Sisense's predictive analytics.
Multi-Dimensional Data Explorer: Give users the ability to explore data from multiple angles using flexible filters, while Sisense ensures accurate query execution and visualizations.

Sisense Community

Hey everyone! We're thrilled to introduce a collection of exciting power packs from the Sisense Innovation Lab and we want YOU to help shape what comes next!

Forum Posts

How to display current date in the header of the dash board using Blox code ? any help

Sisense is Getting a Customer Newsletter! We want your input!

Column freezing for a table

Resolved! Tenants migration

Resolved! Applying a filter on a dashboard with two data sources

Resolved! Add Comments to Blox

Resolved! Change Widget Description

Resolved! Embed image stored locally to blox

Resolved! Limit Dashboard Sharing to a Group

Resolved! Date and Time Functions

Resolved! Widget Data Not Included in Downloaded CSV After Calculation (Table Widget)

Calculating average units for two years

Seeking Recommendations: Sisense Hands-On Training for ETL Workflow and Dashboard Creation

Resolved! Excluding from an existing Dashboard filter using BLOX

Resolved! Widget Display Not Updating On Dashboard Filter Change

Community Content Spotlight

Content you missed that you never planned on reading

Unhiding a column in an elastic model, still not s...

Creating a Custom Usage Analytics dashboard

Re arrange few columns in the pivot table

Funnel Chart % of Total Calculation

How do I lock a dashboard filter through dashboard...

How to make the size of each stage equal for a fun...

Running Rate

Indicator text

Filter for values that contain line breaks

How to make all images the same size in a BloX con...

Convert Bar Charts into Radial Bars

Highlight Bars with Above/Below Average Values in ...

Re: How do I lock a dashboard filter through dashb...

Re: Unhiding a column in an elastic model, still n...

Re: Convert Bar Charts into Radial Bars