Sometimes users prefer to receive alerts via Slack channel as opposed to email. While alerts are only built for email, we can receive alerts in Slack using Slack's 'Email' app. 1. Click 'Add Configuration' 2. Choose the Slack channel you want to send...
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. See ...
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. # Salesforce apex page tag # include ...
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 emb...
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 ex...
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...
Quick to figure out Run the following code within the Python/R editor. (Write Select 1 in the SQL editor to be able to use the Python/R editor)import pkg_resources; installed_packages = [(d.project_name, d.version) for d in pkg_resources.working_set]...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Share this page:
