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 dat...
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...
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 numbe...
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 ...
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 mea...
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() co...
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 s...
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]) = ...
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 * detractor...
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]) t...
A correlated subquery is a subquery that references a field from a table that is not included within the subquery. In other words, there are references to the "outer" query in the "inner" query. Correlated subqueries are not only computationally inef...
Funnel charts are a common way to visualize conversion for various stages in a business process.Sometimes, it could be interesting to visualize a funnel split by demographic - I recommend just limiting the split to two groups - anything more and the ...
Want to show a rolling average to your data? Using the Python / R integration, we can use a few quick lines in R to accomplish this. Here are the first few rows of our SQL output - a list of dates with the number of users created on a fictional ga...
Note: This solution requires Sisense for Cloud Data Teams' Python/R integration Let's say you have data set that is heavily skewed, like this hypothetical data set here plotting the amount users paid on a fictional gaming app. As we can see h...
Contextualizing KPIs is a must. For instance, if a company has 500 users, how does that compare to the number of users last week? Using Sisense for Cloud Data Teams' Python Integration, we can create customized number overlays to cleanly present this...
We've found here at Sisense that it's often very helpful to have the default dashboard on a site include a table of contents for even quicker navigation to key dashboards, or even a table of hyperlinks to offer a smooth transition between Sisense for...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
