Knowledge Base

Connecting Data Points With Smoothed Lines (Spline Curves) In Periscope With Plot.Ly (Python And R)

Ever looked at a chart like this: and thought to yourself that the data would make much more sense with curved lined connecting the points, rather than straight lines? Well fear not, because plot.ly makes it easy to adjust this using the spl...

Waterfall Charts -- Plot.Ly

Waterfall charts are a great way to highlight changes in your data between steps or periods. The following python script easily plugs in with your SQL output, simply paste this into your Python 3.6 code box provided with the Python/R Integration,...

Overlapping Area Chart — Plot.Ly

We can create overlapping area charts in Sisense for Cloud Data Teams with the Plot.ly integration! These offer a better way to see the exact value per shaded region than stacked area graphs. If your purpose, however, is to draw attention to the tota...

Progress To Goal (Radial Bar Charts) — Plot.Ly

Looking to create a radial bar chart with plot.ly? Look no further! Radial bar charts are a great way to show progress to a goal. The following python script easily plugs in with your SQL output, simply paste this into your Python 3.6 code box pr...

Boxplot -- Plot.Ly

Boxplots are a widely recognized chart type and are excellent for quickly and succinctly visualizing distributions. The following Python script, leveraging the plot.ly library with Sisense for Cloud Data Team's Python/R Integration, generates the ima...

KPI Chart — Plot.Ly

Contextualizing KPIs is a must. For instance, if a company has 500 users, how does that compare to the number of users last week? Using Sisense for Cloud Data Teams' Python Integration, we can create customized number overlays to cleanly present ...

Sankey -- Plot.Ly

Sankey diagrams are a very easy-to-digest way to look at the flow of objects between different points. The below script takes a SQL output with these 3 columns:unique_id: the unique identifier for that entitystage_name: the name of the stage in the s...

Gantt Chart -- Plot.Ly

Gantt charts are a great way to show which projects and tasks different teams are working on at a given time. This chart type is heavily used by Project Managers, Task Managers, and anyone else managing multiple workflows. We can use the plot.ly ...

Funnel Chart -- Plot.ly

Funnel charts are a great way to represent any drop-offs in sample size throughout a series of steps. Using a little bit of Python handiwork in Sisense for Cloud Data Teams' R/Python integration, we can easily create this chart type. A common u...

Use A Chart-Level Filter For Your Y Axis - Plot.ly

Want to create a chart-level filter, allowing you to change your Y axis? Say hello to your new favorite library plot.ly! Sisense for Cloud Data Teams' Python and R integration allows you to use Plot.ly (as well as a host of other libraries), some of ...

Visualizing Text Data With WordClouds

A popular way of visualizing text data is using WordClouds. Using Python's WordCloud library this can be done with a column of text data and a few lines of code.# SQL output is imported as a pandas dataframe variable called "df" import matplotlib.pyp...

Visualizing Forecasting Data (Prophet) In Plot.Ly — Python

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...

Setting The Marker/Bubble Size In Bubble Charts

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...

Extract A Phone Number From A String In Redshift

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...

Dynamic Line Or Scatter Chart Based On A Date Range Filter

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...

Rolling Averages Using Window Functions

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. I...

3D Scatter Plots In Plot.ly

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...

Text Boxes With Different Fonts!

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...

MySQL’s Sec_to_time() Function In Redshift

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...

Introduction To Hyperparameter Optimization - Machine Learning

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 lear...

Sisense Community

Enable/disable field suggestions in the NLQ (Simple Ask)

Knowledge Base Articles