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

Knowledge Base Articles

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
  • 669 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
  • 321 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
  • 226 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
  • 804 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
  • 547 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
  • 1595 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
  • 571 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
  • 1038 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
  • 1414 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
  • 1150 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
  • 467 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
  • 1147 Views
  • 0 comments
  • 0 kudos

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

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

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

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

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

intapiuser by Community Team Member
  • 843 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: