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

Knowledge Base Articles

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
  • 201 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
  • 249 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
  • 125 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
  • 607 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
  • 273 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
  • 170 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
  • 738 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
  • 490 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
  • 1384 Views
  • 0 comments
  • 0 kudos

Reorder pivot columns by viewers

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

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

Indicator With Dates, Time And Duration

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

intapiuser by Community Team Member
  • 954 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
  • 1309 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
  • 1018 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
  • 403 Views
  • 0 comments
  • 0 kudos

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

intapiuser by Community Team Member
  • 907 Views
  • 0 comments
  • 0 kudos
Labels
Featured Article
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: