Good day Lisa.
Guessing, do you mean, the sheet SLA from your attached workbook? Do you mean you want the workbook to look like the image? Is it the constant reference line you're interested in (the dotted red line), or something else?
I am wanting to convert mine to look like the image
Good day Lisa.
Okay, then first I'd add constant reference lines:
- Click on the Analytics Tab in the upper left corner of the screen.
- Double-click the "Constant Line". Set the value to be 0.9.
- Right click the newly added line to edit the line.
- Change the label to be Custom, "Target SLA = 90.0%"
- Change the formatting to be a red dashed line.
Then update the format for the values on the bar chart to be %.
- Right click "AGG(p1 SLA%)" in the row shelf, select "Format..."
- Click the Pane tab.
- Select Numbers, choose Percentage.
- Choose alignment, select direction "horizontal".
Is this what you're looking for?
The concern is that once I add P1% and P2 % is where my graph comes undone - I need to be able to have both on the graph
Also, you may be want to something more like this:
To get this:
- Remove the dual measures P1 SLA %, P2 SLA % from the rows shelf.
- Add Measure Names to the filters. Select P1 SLA %, P2 SLA % in this filter.
- Add Measure Names to rows shelf.
- Add Measure Values to the rows shelf
- Drag Measure Values onto the Color widget.
- Click the Color widget, edit colors, select blue/orange diverging.
I am not having issues with the trend lines or the formatting part
I think this will work - I was over thinking it - Thank you again