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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
Contains the following:Area Code, City Name, "State Name",US,Lat,LongSourced from https://github.com/ravisorg/Area-Code-Geolocation-Database/File Here.
Simplified outline map of the United States in GeoJSON format. Join this data to your datasets to create beautiful GeoJSON Map charts!File Here
List used in blog post on sentiment analysis of Donald Trumps Tweets: https://www.sisense.com/blog/text-analysis-with-trump-tweets/File here.
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,}', ' ')
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...
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...
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...
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...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
