Loading

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

Julkaisupäivä: May 6, 2025
Tehtävä

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

Vaiheet
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-artikkelin numero

001465268

Liitteet

reference line on stacked bar chart.twbx

1208 KB

 
Ladataan
Salesforce Help | Article