Looking to visualize your forecasting data? The code snippet below illustrates how you can get an informative and aesthetically pleasing visual, like the one above! Note this uses the plot.ly library as well as the Python and R integration.The code r...
Need A common requirement for self service BI is to enable the viewers to save their own report. This can be achievable in Sisense if you are a designer of a dashboard. However, when you are a viewer, you cannot even re-order the pivot columns as you...
Purpose/Benefits This plugin adds additional functionality on how one can display duration and date/time stamps in a Sisense indicator. Seconds to Duration takes the calculated integer and converts it to duration in hours, minutes, seconds, etc. Use ...
Link to raw dataBackgroundOne of the more frequent questions that we get asked on Sisense for Cloud Data Teams is how a user can alter/set the size of the bubbles/markers beyond the default “weight options” as seen in some of our built-in bubble char...
Sometimes, phone numbers don't come in a format that easy for extraction. It requires a little bit of magic with Regex expressions in Redshift to get what you're looking forLet's say I have this table, called "comments," as my underlying dataset. I w...
Single Scatter Point ChartLine Chart for Multiple Data PointsBackgroundLet’s say that we would like a dynamic chart where we can visualize the number of users who started a game session over the course of a month as a line chart, but also have the fu...
Want to show a rolling average for your data, but not the granular breakdown? We can use the average window function to run this calculation. First, I created a CTE that contains the number of new users per day on a fictional gaming platform. If you ...
NOTE: you don't need to be doing Machine Learning to make a cool 3D plot like this! This post takes the output of a machine learning model and shows the results on a 3D plot, but you can plot almost anything with 3 numerical dimensions using basicall...
Sisense for Cloud Data Teams has a feature called Text on Dashboards that allow users to add text boxes as banners, announcements, and descriptions of charts! However, they currently only support one font. With the R and Python integration, users can...
In MySQL, it’s easy to convert an integer representing a number of seconds into a string representing a human-readable amount of time.This is especially useful when you want to compare two timestamps, for example if you wanted to know how much time e...
There are lots of knobs (a.k.a hyperparameters) we can turn when coming up with a Machine Learning model. in the script below, we take the well-known iris dataset, and play around with different hyperparameters. First, a few notes: In machine learnin...
Let’s say you have some aggregated data and want to break it out into multiple rows. Maybe the original data source provided the values in this format, or maybe it was produced by another SQL View using Listagg() or Stringagg(). Perhaps it's extracte...
A common request is to apply conditional formatting on entire rows based on a value in a given column. Currently, with Sisense for Cloud Data Teams charts, you can only conditionally format columns. Python charts give us much more customizability aro...
SQL Alerts are very handy to keep track of any critical metrics. Oftentimes it makes most sense to do a relative comparison of your data. For instance, "alert me if my metric dropped between yesterday and today." The below SQL code is an example of h...
MySQL aficionados have likely leveraged its ability to declare variables. Unfortunately, this capability isn't supported by all flavors of SQL. For such situations, we can still achieve a similar result by creating a CTE of variables (for more inform...
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:
