Chart Type - Funnel Chart


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
intapiuser
Admin
Joined December 15, 2022