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...
Window Functions are a great way to analyze your data in a different way! Similar to other calculation statements in SQL, window functions allow you to do a calculation across a set of rows or columns. The difference is with window functions the data...
By default in many charting libraries and tools, series within stack bars are arranged in the same order. Looking at the image below, blue is above orange, which is above green, which is above purple.But let's say we want these series within each bar...
Here is an alternate visualization of a funnel chart - instead of using bars, it depicts the different steps as concentric circles.How to use: define an array in the extract() function of the values you'd like to use. If you are pulling data from a d...
So you have a table neatly ordered by users, you proudly present it to your boss, waiting for the praise, but you forgot: She’s desperately near-sighted! How can she tell when the user_id changes without having to stress her eyes? If only there was a...
Let's say you're tracking a KPI, and want to see if any changes in your KPI are statistically significant. It would be nice to mark these points on your line graph to call attention to these particular increases and decreases. In the above visualizat...
Want to show a rolling average to your data? Using the Sisense for Cloud Data Teams Python / R integration, we can accomplish this with a single line of Python code. Here are the first few rows of our SQL output - a list of dates with the number of u...
Radial bar charts are a great way to visualize progress charts - but sometimes it's helpful to be able to visualize that progress with the additional context of more pipeline as well.Input: you will need to provide the chart maker function with at le...
Once you’ve gotten familiar with bivariate linear regressions (one explanatory variable, and one response variable), you may want to delve into seeing how multiple explanatory variables contribute to your response. Not sure how to get started? Well y...
FOR CLOUD DATA TEAMS Confidence intervals are a favorite among many professionals with a statistics background. We can use the R integration in Sisense for Cloud Data Teams to show the Confidence interval as a shaded region around a line of means fro...
Transposing a dataframe in R is as simple as 2 quick lines of code. The first is to actually transpose the table, and the second is to name your column headers. Below is the dataframe we will be transposing. This is pulled from using the head() comma...
Oftentimes we want our end users to select a filter in order to use a dashboard. One of the ways we can do this is by building it into then chart SQL, as shown below: select case when '[source_test|default]' = 'default' then 'Please select a filter v...
This post is from one of our customers!This post is from one of our customers!Use this case statement in a snippet with a rating parameter to change numerical ratings to stars:case when ROUND([rating]) = 5 then '★★★★★' when ROUND([rating]) = 4 then '...
This post is from one of our customers!Some handy snippets for calculating NPS and accuracy. [nps] ((promoters/total ) - (detractors/total))[nps_var] ((1 - [NPS]) ^ 2 * promoters/total + (0 - [NPS]) ^ 2 * neutral/total + (-1 - [NPS]) ^ 2 * detractors...
Use this case statement to add up and down arrows to your metrics, for instance:case when [value_field] < lag([value_field]) over(order by [order_field]) then '▲ ' when [value_field] = lag([value_field]) over(order by [order_field]) then 'no change' ...
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:
