Knowledge Base Article

Chart Type - Funnel Chart

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

Here is a list of all the settings that were changed from default to achieve the above chart:
- Toggle horizontal bar chart to create the top to bottom funnel effect
- For best results, we recommend a series name with appropriate alphanumeric ordering and using the Preserve Sort Order toggle in Legend Settings.
- In order to make the series colors blend into the background, you can use the the hexcode #f9f9f9.

Snippet Name: Funnel_chart(Table,Values,Series)

select
 [series]
 , 1.0 *  (max - [values]) / 2 as left_buffer
 , [values] as value
 , 1.0 * (max - [values]) / 2 as right_buffer
from
 (
   select
     max([values]) as max
   from
     [table]
 )
 , [table]
Updated 03-02-2023
No CommentsBe the first to comment