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 when '[my_filter|De...
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 round(1....
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(ord...
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,}', ' ')
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Share this page:
