Loading

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

Data pubblicazione: May 6, 2025
Operazione

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

Fasi
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
Numero articolo Knowledge

001465268

Allegati

reference line on stacked bar chart.twbx

1208 KB

 
Caricamento
Salesforce Help | Article