Seleziona un'organizzazione
How to Add Average Lines for Each Dimension Set to Color
Data pubblicazione: Feb 24, 2026
Operazione
Is it possible to add trend lines for each dimension member in Color on a scatterplot?
Fasi
1. Add SUM(Sales) to Columns.
2. Add SUM(Profit) to Rows.
3. Add Sub-Category to Detail.
4. Add Category to Color.
5. Create a calculated field and name it Profit for Furniture.
IF [Category]="Furniture" THEN [Profit] END6. Create a calculated field and name it Profit for Office Supplies.
IF [Category]="Office Supplies" THEN [Profit] END7. Create a calculated field and name it Profit for Technology.
IF [Category]="Technology" THEN [Profit] END8. Add SUM(Profit for Furniture), SUM(Profit for Office Supplies), and SUM(Profit for Technology) to Detail.
9. Open Analytics pane and drag Average Line to Table > SUM(Profit).
10. Right-click the average line on the view and select Edit. Configure it as follows:
11. Repeat step 9 & 10 to add more average lines.
Numero articolo Knowledge
001463409
Questo articolo ha risolto il problema?
Facci sapere, così possiamo migliorare!
