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

Knowledge Base Articles

Radar Charts In Python

Radar charts are an effective way to quickly grasp a profile of an individual item. You may have seen them before on video games or personality tests. Some other great use cases are: Different attributes to mark the health of a particular customer ac...

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

Communicating Deadlines Through Calendars In Python

Ultimately, the most effective way to show upcoming deadlines is to display a calendar. We can easily build this out using Sisense for Cloud Data Teams' Python integration (Python code below!)The Python script below builds a function with the followi...

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

Gantt Charts Version 2 - Individual Workstreams

While some users like showing Gantt charts that allow overlapping dates, many would prefer a visual that clearly shows individual work streams, especially in organizations where members are focused on one task at a given time. The input to the Python...

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

Contract Adherence KPI Chart

MotivationA frequent business question often posted by Sales teams is "Where are our customers currently in terms of contract adherence?" This helps inform next steps and conversations for an account. With Python's matplotlib, we can make custom obje...

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

Dealing With Missing Values In Python

Python pandas offers a few different options to deal with null values. Based on your dataset, there will likely be a preferred method to account for null values that 1. accurately represents your data and 2. preserves a decent sample size for rigorou...

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

Choropleths Made Easy In R

Choropleths are fancy names for maps with heatmaps, probably because no one wants to say heatmap maps and feel redundant. In R there are packages that make Choropleth objects. choroplethr holds the shape files, create a join of your data frame, and o...

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

Beware Of Many To Many Joins!

Row counts looking off or data not looking quite right after a join? Well, you could possibly be doing a many-to-many join if the columns in your join conditions aren't distinct! Let's take the following example. Say you have this table, t1. And this...

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

Part 1: Understanding The NVL/COALESCE Expression

What are Nulls? The null value can be confusing--does it represent a zero, an empty space, a blank placeholder? In SQL, null represents an “unknown” type or the absence of a value, and the use case and queries involving nulls are often unique. For ex...

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

Part 2: Understanding The NVL/COALESCE Expression

Now, on to the second part of our journey with the NVL/Coalesce Expression!Coalesce Expression & Return TypesWhen a Coalesce/NVL expression is applied, all inputs/arguments should be the same datatype, as the Coalesce function will return the first n...

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

Window Functions!

Window Functions are a great way to analyze your data in a different way! Similar to other calculation statements in SQL, window functions allow you to do a calculation across a set of rows or columns. The difference is with window functions the data...

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

Sorting Stacked Proportional Bar Charts By Magnitude

By default in many charting libraries and tools, series within stack bars are arranged in the same order. Looking at the image below, blue is above orange, which is above green, which is above purple.But let's say we want these series within each bar...

intapiuser by Community Team Member
  • 1164 Views
  • 0 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
  • 368 Views
  • 2 comments
  • 0 kudos

Conditional Formatting For Rows With Similar Results

So you have a table neatly ordered by users, you proudly present it to your boss, waiting for the praise, but you forgot: She’s desperately near-sighted! How can she tell when the user_id changes without having to stress her eyes? If only there was a...

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

Using Python To Plot Only The Rolling Average Line

Want to show a rolling average to your data? Using the Sisense for Cloud Data Teams Python / R integration, we can accomplish this with a single line of Python code. Here are the first few rows of our SQL output - a list of dates with the number of u...

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