This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
[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...
What methods do you use to effectively communicate "Here is the KPI versus a Benchmark"? One of my favorite is to use the chart series type to indicate the difference between a realized KPI and the theoretical goal. Here's an example:To add this line...
I love a great benchmark or comparison to goals. One solution that Kyle on my team came up with was a bullet chart. I standardized this with a Parameterized SQL Snippet to do all the transformation heavy lifting for you Name: bullet_chart(table,value...
An important analytical technique is to look at the rate of change over time. An easy graph to investigate this is a bar chart with the period over period change in percent or value. In this snippet, you can calculate the change for various time peri...
People love to see their schedules. So a Gantt Chart can be a great addition to a dashboard to offer context. Here is a Parameterized Snippet and set of toggles to get a Gantt Chart going with little effort. Base: Bar Chart Toggles: Horizonta...
Everyone loves to see values relative to benchmarks in a Gauge Chart format. The speedometer gauge is such a common way of people ingesting information that it has become commonplace in the Business Intelligence world. I'm not going to hate it as the...
Ever needed to perform wildcard filtering on a string column? You can achieve this using our Direct Replacement Filters plus the trick of concatenating a '%' onto the filter in the WHERE clause. Let's say you had a dataset on Donald Trump's Tweets lo...
With maps, I like to use color to easily show relative densities and concentration. For this, use a case when statement to split your regions into groups, like so:case when density <= 10 then '1-10' when density <= 20 then '11-20'...
Let's say you have a list of names that you want to filter by, but one of the names contains an apostrophe. You would rather not remove the apostrophe and have the filter values and results displayed with the incorrect spelling to the end user, so re...
When creating dashboards, we often would like to ensure that the same colors correspond to the same series across multiple charts. This could be desirable because our series could have associated brand colors, or simply to ensure continuity and effec...
If you have a mix of visualizations using Sisense for Cloud Data Teams' default charting options and R/Python charts, ensuring a uniform look gives a cohesive flow to the entire dashboard.By playing around with ggplot2's customization options, we can...
So you've built a beautiful dashboard but your user decides to use a filter combination that returns no rows. Sometimes it's not even your users, it may just be that you have a structure where not all charts should have data returned. To account for ...
Filters are a useful way to hone in on a specific subset of data, but let's say that you prefer highlighting records that meet the filtering criteria, rather than eliminating others from view entirely. This is definitely possible with the R/Python in...
Creating an embed URL is a multistep process that can easily be botched along the way. Finding where the mistake was made can be tricky, and the generation of multiple embed URLs can be a painful process to repeat. With a simple python script we can ...
Sometimes when using python code, there will be cases when no data is returned. To account for this in python if you can first check if the dataframe has empty rows with. if df.size == 0: (then run all of my actual code) else: (run code to s...
A stack rank chart shows the relative rankings of different objects over time. These are useful for determining on whether rankings are fluctuating highly or staying fairly consistent.The SQL output must have the 3 following columns:date: the date of...
You can easily create a wildcard filter that allows you to filter by a word or series of words on your chart using this post on Wildcard Filters. However, let's say you have a list of comma separated filter values that you'd like to filter on and it...
As a member of the Solutions team, I rely on several handy troubleshooting tricks to debug numerous queries. I've put a few of my favorites below - feel free to comment below with any additional debugging tools that you like to use! 1. Run portion...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
