cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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, simply reference it in your select statement as an additional column. Then you can define the series settings on the right hand side of your chart editor to display benchmark as a line while the rest of your data is displayed in bar format.
select
value
, 9 as benchmark
from
table
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