This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
New to R? Not a problem! You can still deliver valuable insights to your team using a few simple functions. This article walks through how you can use the Python and R integration along with its charting capabilities to rapidly build data models.Here...
Oftentimes, we want to explore the relationship and correlation between multiple variables. Below are three different methods you can achieve this in Sisense for Cloud Data Teams, along with important tips to know as you're building out your models ...
With the Role Based Access Control, Admins have more control over what their users can do and on which dashboards. With memberships to multiple roles, Admins can specify the dashboards each user can see and what kind of privileges they have on those...
Drilldown DocumentationDirect Replacement Filters DocumentationWhen drilling down from a chart to another dashboard, we have the option to pass any of the column values as a filter value in the destination dashboard. However, sometimes we would like ...
A dashboard filter that allows users to paste in an email address requires special consideration. In particular, as mentioned on our filter documentation, special characters except hyphens and decimals are stripped out. In this post, we'll work aroun...
The Render API is perfect if you want to download a nicely formatted and dynamic PDF image of an entire dashboard. The Render API is an add-on feature in Sisense for Cloud Data Teams. Here is the official documentation on the Render API. This post wi...
With Auto Archive, unused dashboards, views, and uploaded CSVs will automatically be archived after a number of days defined in site settings by an administrator. To make sure nothing gets accidentally archived by this, we can set up an Alert that wi...
If you’re anything like us—and if you’re reading this, you probably are—you’ve found yourself in a position where you’ve created 60+ interdependent (600+ line) data transformations defined in SQL as a core step of your ETL. You may even be sitting th...
Connecting To RedshiftYou can connect to Amazon Redshift using a JDBC or ODBC connection, any tool or program which connects via these methods, or programmatically (AWS provides examples for Java and .NET). AWS supports SSL connections for security.A...
MotivationA frequent business question often posted is "What is the change in [users, units sold, views, etc]? Using Python's matplotlib library, one way to visualize this change is to visualize it alongside an arrow indicating the direction of chang...
I’ve seen this quite a few times so I thought I’d write a little community post about it since our native way in specifying timezones doesn’t work with filters! Normally, this would be the way to convert a datetime column to a specific timezone. ...
Sometimes it's important to be able to access large amounts of data directly in a table. For chunks of data that can't be safely loaded in a browser, one option would be to split the results in multiple charts on the same dashboard, so the user could...
The parameterized snippet below can be used to find the number of weekdays between 2 dates. We named this one difference_in_weekdays(start_date,end_date) Redshift(DATEDIFF('day', [start_date], [end_date])) -(DATEDIFF('week',[start_date], [end_date]...
Found a great article that reviews the differences between these 3 useful window functions. I've adapted the theoretical data to provide a more practical (albeit simplified) business context.All coding credit goes to the authors of the article. Highl...
The Embed Refresh Trigger PostMessage that is accepted by embedded dashboards can be used to allow public users to refresh their view of an embedded dashboard, or to set a refresh rate on those embeds. The data_ts parameter is sufficient for checking...
Here's an example script for how to embed dashboards in a Salesforce page - in this case, we're embedding in the Accounts page. Be sure to replace your dashboard id, API key, and include the appropriate filters. <apex:page standardController="Account...
When opening an embedded dashboard, we check the most recent refresh timestamp for the given filter set, and if this is less than the specified “data_ts” parameter, then we will refresh the embedded dashboard at the time of opening. Specifically, thi...
The following is a simplified example on how to create an event listener in order to implement a Drilldown in an embedded chart. Refer here for our official documentation on our Embeds Refer to this community post to see how to easily generate an...
Similar to the User and Group API, Sites that have RBAC enabled can use the User and Role Management APIs for RBAC allows us to create, read, update, and destroy users and roles programmatically. Here's the official documentation. Below are simple...
With the release of our User and Group Management APIs, we can now create, read, update, and destroy users and groups programmatically. CRUD! Here's the official documentation.Here are some super simple examples showing how you can test this out in P...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
