Knowledge Base

What Version Of Each Library/Package Is Sisense For Cloud Data Teams Using? [Python And R]

Quick to figure out Run the following code within the Python/R editor. (Write Select 1 in the SQL editor to be able to use the Python/R editor)import pkg_resources; installed_packages = [(d.project_name, d.version) for d in pkg_resources.working_set...

Graphing Plot.Hist() As A Chart On Your Dashboard

Plot.Hist( ) is a very useful function for creating histograms in Python. However, this is ultimately a bar chart that can be graphed by Sisense for Cloud Data Teams as well, and would better match other charts on the dashboard. The data generated by...

Using A Case/When Clause With Default Filter Values

Sometimes when using direct replacement filters, you may want to filter or manipulate your data differently depending on the value or values supplied by the filter. Consider the following example: select * from my_table where case wh...

A More Robust LIKE/SIMILAR TO/Wildcard Filter At The Dashboard Level With A Matching Expression Filter!

You may have seen our earlier post on how to create a LIKE wildcard filter by concatenating the wildcard operator (%) onto a filter value. One of our engineers suggested a better method - using a Matching Expression Filter type instead. This way, the...

Controlling Cohort Grid Ordering Via Cross Joins

When determining the ordering of rows and columns in cohort grids, Sisense for Cloud Data Teams examines the order of your underlying data. In most cases, this produces a result in the desired order. Sometimes however, there's that one pesky column t...

Snippet - Month Versus Month In Prior Year

Here's a Parameterized Snippet to calculate the metrics versus the same month in the prior year. Ideally the metrics have already been calculated in a CTE or View and can easily be plugged into the template.Name: month_versus_prior_year(table,field,d...

Byte Conversion

We created a parameterized snippet to take a raw amount of bytes and convert it to Kilobytes, Megabytes, Gigabytes, and Terabytes accordingly. Snippet Name: Byte_Conversion(byte_field)Snippet Text: case when [byte_field] > 1099511627776 then ro...

Using The Built-In Date Range Filter To Dynamically Update BigQuery Results

BigQuery, unlike other flavors of SQL, breaks out its tables by day. Each table has a suffix with the date included, but what if you want to allow your end-user to dynamically query only tables from certain dates?By using table wildcard operators in ...

Excluding Data That Isn't Fully Baked

Have a dataset where you want to display everything but the most recent time period? This is handy to do if you want to only disclose KPIs once data has been given the chance to fully mature. (For example, If we're in the middle of Q4, I only want to...

Chart Type - Waterfall Chart

Waterfall charts are a beautiful way to show a positive and negative stack in series. This sums to a running total over the series of values. It allows a consumer to quickly see the rise and fall over the series so they can identify the points in the...

YTD Sum Vs Prior YTD Sum

This parameterized snippet will calculate the sum of a metric for the current YTD vs prior years to current date (day of year).Name Ytd_sum(Table,Date_field,Value_field)select year , [value_field] , ([value_field] / nullif(lag([value_field]) over...

Chart Type - Histogram

Histograms are useful for showing the distribution of a data set while aggregating up to see more general trends. Here is the SQL code (in a handy parameterized snippet!) for binning numeric data and creating histograms from columns.Snippet Name: his...

US Area Code City And Lat/Long Information

Contains the following:Area Code, City Name, "State Name",US,Lat,LongSourced from https://github.com/ravisorg/Area-Code-Geolocation-Database/File Here.

Simple US Outline GeoJSON

Simplified outline map of the United States in GeoJSON format. Join this data to your datasets to create beautiful GeoJSON Map charts!File Here

Sentiment Analysis - Scored Words

List used in blog post on sentiment analysis of Donald Trumps Tweets: https://www.sisense.com/blog/text-analysis-with-trump-tweets/File here.

Clean Text To Alphanumeric Characters Only

SQL Code to clean strings to alphanumeric characters only. Useful for cleaning survey data and data which may contain special/foreign charactersregexp_replace( regexp_replace(lower([text]), '[^a-zA-Z ]', ' ') , '( ){1,}', ' ')

Retention Cohort Without An 'All Activities' Table

Our blog has a post about calculating retention, but this assumes I have a table with user activity from every single day per user, which is, more often than not, not the case. So I put together a version that uses just the start date and end date, a...

[Customer Contribution] Search For User By Radius SQL

This post is from one of our customers!Looking forward to that free shirt! In the mean time, here's a fun sql snippet I wrote to find select users (for something I was working on) by radius of area:SELECT location.id,location.name,location.addres...

Correlation Coefficient SQL Snippet

Want to create a convenient Sisense for Cloud Data Teams SQL Snippet which emulates a function and returns the (Pearson) correlation coefficient between two variables?Create a SQL Snippet called 'correlation_calc(metric_1 , metric2)' and insert the f...

[Customer Contribution] Generate True Count From Start/End Date Range

This post is from one of our customers!I work for a company that uses a subscription revenue model, where subscriptions are stored in postgres as start and end timestamps. For our insurance & billing department, it's important to know how many assets...

Sisense Community

Enable/disable field suggestions in the NLQ (Simple Ask)

Knowledge Base Articles