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' ...
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 gamin...
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 here, a b...
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...
We can leverage filters to even change the field we are grouping by! This technique allows users to effectively see many different analyses, all in one query.Below we have a query looking into the number of users by month for a fictional gaming compa...
[Written by Kyle Demeule]As a Canadian I was always amazed at some of the salaries baseball or football players we're able to get (Jason Heyward getting 21 million year? He plays outfield right?), especially compared to Hockey (one of the best player...
The funnel chart can be created as a variation of the bar chart. Here is an easy SQL Snippet to take your table, the values, and the series of steps. It will calculate the left and right padding for all values less than the maximum, creating the funn...
Not everyone has to be a six sigma black belt to appreciate and use a well-designed control chart. The top and bottom red lines indicate a standard deviation away, the green line indicates the average, and the black line indicates the values over tim...
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:
