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

Knowledge Base Articles

Walkthrough: Unaggregate/Disaggregate Data

Let’s say you have some aggregated data and want to break it out into multiple rows. Maybe the original data source provided the values in this format, or maybe it was produced by another SQL View using Listagg() or Stringagg(). Perhaps it's extracte...

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

Conditional Formatting On Entire Rows With Plot.ly

A common request is to apply conditional formatting on entire rows based on a value in a given column. Currently, with Sisense for Cloud Data Teams charts, you can only conditionally format columns. Python charts give us much more customizability aro...

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

SQL Alert - Tell Me If A Value Dropped Since Yesterday

SQL Alerts are very handy to keep track of any critical metrics. Oftentimes it makes most sense to do a relative comparison of your data. For instance, "alert me if my metric dropped between yesterday and today." The below SQL code is an example of h...

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

Creating A Table Of Variables In SQL

MySQL aficionados have likely leveraged its ability to declare variables. Unfortunately, this capability isn't supported by all flavors of SQL. For such situations, we can still achieve a similar result by creating a CTE of variables (for more inform...

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

Plotly Choropleth With Slider (Map Charts Over Time)

Plotly is great for its interactivity on visualizations! With choropleth charts we can add a slider to the bottom of the chart to see how data changes over time on a map. The end user can drag the slider across the bottom to see the colors on the hea...

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

Changing Line Styling -- Plot.ly (Python And R)

Wanted to alter the thickness of the lines in your series, add markers to your lines, and make them dashed or dotted? The plot.ly library support on Sisense for Cloud Data Teams' Python/R integration allows you to tailor these parameters to your hear...

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

Custom Aggregation Filter

Aggregating data by various periods of time is made easy with Sisense for Cloud Data Teams' built-in date aggregation filter. Sometimes, however, you may wish to group your data by different periods of time. In this post, we'll look at how to create ...

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

Every Kind Of JOIN

More often than not, you'll need data from multiple different tables to create the perfect chart! There are many ways to do this but the most common way in SQL would be to use Joins! There are four basic types of Joins: inner, left, right and full. S...

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

Compounding Values With Dynamic Multipliers

Coming from the world of spreadsheets, you may have defined a set of values recursively with ease, referencing the previous value plus another variable to calculate a new value. Something like this:In the above screenshot, the result column is calcul...

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

Plotting A Gradient Line In R

Color is an extremely useful visualization tool. On a line chart, a color gradient can be used to emphasize the highs and lows. Using the Python / R integration in Sisense for Cloud Data Teams, we can definitely achieve this look.   Here's the SQ...

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

Python Bullet Charts

 However, if we seek to further customize the look of a bullet chart, the R/Python integration comes in very handy! The above image is a bullet chart created using matplotlib, and allows quick interpretation of how well a business is tracking tow...

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

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

intapiuser by Community Team Member
  • 1080 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
  • 481 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 t...

intapiuser by Community Team Member
  • 404 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
  • 325 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 rigoro...

intapiuser by Community Team Member
  • 7302 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 ...

intapiuser by Community Team Member
  • 505 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. ...

intapiuser by Community Team Member
  • 280 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.    Fo...

intapiuser by Community Team Member
  • 13991 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
  • 700 Views
  • 0 comments
  • 0 kudos
Labels