Loading

How to Display the Sales Target Value on Stacked Bar Chart with Reference Line

Publiceringsdatum: May 6, 2025
Uppgift

How to display the sales target value on stacked bar chart with reference line.

Steg
When adding the average of target sales as a reference line to a stacked bar chart, it needs to be calculated as a weighted average, not as simple average.

Below is an example using Sample - Superstore data.

1. Create a stacked bar chart.
2. Create a calculated field and enter sales target value. 
User-added image
3. Drop Monthly Sales Target field to Detail.
4. Open Analytics pane and drag and drop Reference Line to the view.
5. Set Reference Line as follows.
User-added image
Knowledge-artikelnummer

001465268

Bilagor

reference line on stacked bar chart.twbx

1208 KB

 
Laddar
Salesforce Help | Article