To copy site objects such as charts, dashboards, views, and SQL snippets between spaces using Git integration, the following conditions should be met and steps followed.
15Views
1like
0Comments
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 ...
1.7KViews
0likes
0Comments
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...
6KViews
1like
0Comments
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 you...
6.9KViews
0likes
0Comments
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 dat...
26KViews
0likes
0Comments
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, w...
1.2KViews
0likes
0Comments
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 els...
1.8KViews
0likes
0Comments
Usually when I need to upload a CSV I will use the Sisense for Cloud Data Team's CSV functionality. It's fast, easy, allows me to join the data with all my databases, and automatically casts t...
8.1KViews
0likes
0Comments
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 hea...
6.5KViews
0likes
0Comments
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 Da...
3.7KViews
0likes
0Comments
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 o...
13KViews
0likes
0Comments
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 ...
5.6KViews
0likes
0Comments
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 ...
5.7KViews
0likes
0Comments
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 ...
16KViews
0likes
0Comments
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...
2.8KViews
0likes
0Comments
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...
1.5KViews
0likes
0Comments
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 ...
6KViews
0likes
0Comments
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 P...
1.3KViews
1like
0Comments
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. ...
1.6KViews
0likes
0Comments
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 ...
897Views
0likes
0Comments