cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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_field,benchmark_field,dimension_field)
select
  case
    when [value_field] < [benchmark_field]
      then [benchmark_field] - [value_field]
    else null
  end as value
  , 'to benchmark' as label
  , [dimension_field]
  , rank() over(order by [value_field]) as ord
from
  [table]
union all
select
  case
    when [value_field] > [benchmark_field]
      then [benchmark_field]
    else [value_field]
  end as value
  , '[value_field]' as label
  , [dimension_field]
  , rank() over(order by [value_field]) as ord
from
  [table]
union all
select
  case
    when [value_field] >= [benchmark_field]
      then [value_field] - [benchmark_field]
    else null
  end as value
  , 'passed benchmark' as label
  , [dimension_field]
  , rank() over(order by [value_field]) as ord
from
  [table]
order by 2 desc, 4 desc
Version history
Last update:
‎03-02-2023 09:30 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy