Symptom
You want to have a target line in some of your charts, but you are not able to do it as the system does not have this functionality by standard.
Environment
SAP Cloud for Customer
Cause
SAP Cloud for Customer does not provide a standard target line in any kind of chart.
Resolution
Let's say that your business need is to show how many opportunities you have per month in 2016, while your target is to achieve 50 opportunities in a monthly basis.
As workaround to have a custom target line in your chart, you can do the following.
- Go to the Design Key Figures work center and click New button.
- Insert a name, select a data source and choose Calculated as Type.
- Click Next button.
- In the formula label, type the desired value. If you want to have a target line for 50 opportunities, just type 50 in the formula label.
- Finish it. As you did not apply any formula/function, your key figure will always show the same value.
- In Fiori, go to Business Analytics work center and Design Reports view.
- Search All and Find your report.
- Move to the rows visualization all the required fields.
- Go to Change Chart (table icon) and select Dual-Axis Combination chart type.
Keywords
targetline, target, targe line, chart, analytics, report, line, dualaxis, dual axis , KBA , chart , targetline , targe line , target , line , dualaxis , report , analytics , dual axis , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To