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

Knowledge Base Articles

Leveraging Sisense Notebooks with Compose SDK

Leveraging Sisense Notebooks with Compose SDK In today’s developer ecosystem, delivering a tailored creator experience is essential for success, especially when integrating analytics into customer-facing applications. Many existing solutions offer a...

Screenshot 2024-09-17 at 4.01.02 PM.png Screenshot 2024-09-17 at 4.00.43 PM.png
spuma by Sisense Team Member
  • 202 Views
  • 0 comments
  • 1 kudos

Display df.describe() Output In A Dataframe

The .describe() function in Python is really handy for exploratory analysis! Sometimes, you would want to display this as a table on a dashboard, but how? The output is typically printed out as text, not as a dataframe.Fear not, getting this into a d...

intapiuser by Community Team Member
  • 7819 Views
  • 1 comments
  • 0 kudos

Radial Funnel Chart

Here is an alternate visualization of a funnel chart - instead of using bars, it depicts the different steps as concentric circles.How to use: define an array in the extract() function of the values you'd like to use. If you are pulling data from a d...

intapiuser by Community Team Member
  • 701 Views
  • 2 comments
  • 0 kudos

Creating A "Select All" Condition For A Multi-Select Filter!

Often, users will have a large number of filter values selected in a multi-select filter, and rather than having to deselect or 'x' out every filter value, you may want to quickly check the full, unfiltered data. This is something you can do in Sisen...

intapiuser by Community Team Member
  • 1342 Views
  • 1 comments
  • 0 kudos

Alerts In Slack

Sometimes users prefer to receive alerts via Slack channel as opposed to email.  While alerts are only built for email, we can receive alerts in Slack using Slack's 'Email' app. 1. Click 'Add Configuration' 2. Choose the Slack channel you want to sen...

intapiuser by Community Team Member
  • 879 Views
  • 1 comments
  • 0 kudos

Top 4 Reasons Your View Isn't Materializing

Ever have a SQL view that won't seem to materialize? Getting that dreaded red X even when results are showing in the View editor? Well follow the below instructions to turn those red X's into green checks!1. YOUR SQL SYNTAX ISN'T REDSHIFT COMPATIBLE....

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

Weighted Vs Unweighted Averages

When summarizing statistics across multiple categories, analysts often have to decide between using weighted and unweighted averages.   An unweighted average is essentially your familiar method of taking the mean. Let's say 0% of users logged into m...

intapiuser by Community Team Member
  • 4642 Views
  • 0 comments
  • 1 kudos

Test For Normal Distribution Of Data With Python

One of the first steps in exploratory data analysis is to identify the characteristics of the data, importantly including a test for distribution patterns. In this example, learn how to check if your data is normally distributed in Python with a visu...

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

Get Yesterday's Date

Often times, we want to analyze data with the date from yesterday. How do we auto-populate yesterday's date? There are a few formats that we can use! The syntax below lets us get yesterday's date with timestamp:select dateadd(day,-1,getdate()) To onl...

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

Pivoting And Melting Dataframes

Here's the scenario: you just used SQL and have an output that shows the results you want, but it isn't optimally displayed. Instead of writing cumbersome case when statements, unions/union alls, we can quickly use a few short functions in Python or...

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

Gantt Chart For Team Workflows

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.Using Periscope Data's Pytho...

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

Transposing Tables Using Python Pandas

Pandas makes transposing tables beautifully simple! Below are a couple examples using the example SQL output below: This first Python snippet allows you to define your own column headers: # SQL output is imported as a pandas dataframe variab...

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

Custom Date Range Filter

Update: Sisense for Cloud Data Teams now allows you the ability to create additional date range filters without having to go through the below workaround. Refer to our docs here under "Additional Date Range Filters"Sometimes, users would like to appl...

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

Getting Around Overlapping Data Labels With Python

A common hazard when adding data labels to a chart, is that often times the data labels will overlap when there are two points located relatively close to one another. Fortunately, the flexibility of python allows us a way around overlapping data lab...

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

Creating Charts With Broken Axes

Sometimes outliers are just in the way of chart creation and we want to put them in their own section of chart. Python can help us do that! I started with a data set like "count of users created by month" where there were only values for Jan-Feb and ...

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

A Beginner's Guide To Linear Regression Models In Python

Does your team prefer Python over R? Or are you looking to brush up your on your Python skills? We'll walk through a simple example of a linear regression model using the scikit-learn library in the Python/R Integration. In this exercise, we will als...

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

Remove Whitespace Margins From Plotly Charts

Plotly is wonderful, but sometimes you end up with a chart that looks like it's too small, or that it's not taking up all the space. Why does it do that? In this post, you'll learn how to fix that:With Python, this is actually very easy. We just need...

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

Donut Charts — Plot.Ly

The above example is taken from plot.ly's documentation here. A few updates have been made to the example to make it easier to use within the Sisense for Cloud Data Team's Python/R integration.Pie charts with a hole in it give us donut charts. Now ma...

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

Horizontal Funnel Chart — Plot.Ly

Visually it can be preferable to display a funnel chart horizontally. The following code outlines how to do this.  Note, your SQL output must have 2 columns titled as follows:phases: the names of each stage along the funnelvalues: the value associate...

intapiuser by Community Team Member
  • 1011 Views
  • 0 comments
  • 0 kudos
Labels