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

Knowledge Base Articles

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

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

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 when '[my_filter|De...

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

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

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

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

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

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 round(1....

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

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

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

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

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

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(ord...

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

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

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

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

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

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.

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

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,}', ' ')

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