Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

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

intapiuser by Community Team Member
  • 585 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 708 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 244 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 273 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 136 Views
  • 0 comments
  • 0 kudos

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 entity stage_name: the name of the stage in the...

intapiuser by Community Team Member
  • 647 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 302 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 199 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 785 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 532 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 1495 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 1361 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 1090 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 430 Views
  • 0 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: