Loading

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

發佈日期: May 6, 2025
工作

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

步驟
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
知識文章編號

001465268

附件

reference line on stacked bar chart.twbx

1208 KB

 
正在載入
Salesforce Help | Article