By Holly Szkoropad, GoodData
There is an easy way to add static numbers to your reports. Static numbers can signify SLA goals, limits, or any type of baseline within a report. These types of reports are generated by a simple custom metric, which will return the same baseline no matter how it's sliced. These metrics are easy to edit and provide flexibility as SLAs change overtime.
This recipe uses a SLA First Reply Time of four hours. This is the Limit metric of the report. Your Goal metric is a First Reply Time of three hours. These metrics give you a static visual to compare against your actual average reply time.
In the steps below, you can create metrics to capture your goal and limit.
- Create a new report with a First Reply Time base metric.
Note: The Goal and Limit metrics must be created in the Advanced Metric Editor. Since they are static values, you can type them in directly. For more information see the How to create a custom metric video on GoodData's support site.
- Name: Goal
- Definition: SELECT 3
- Name: Limit
- Definition: SELECT 4
- Break down your report with the Week (Sun-Sat)/Year (Created) attribute. This attribute gives weekly averages to compare against your Goal and Limit metrics. Click done when you're finished.
- Choose a chart type. This recipe uses a Bullet chart; however, static numbers will work in any type of chart.
Configure the metrics' location in the Show Configuration side panel.
- Actual Value: First Reply Time
- Target: Limit
- Good: Goal
Change the metrics' colors by selecting
You can now easily identify when the first reply time is within acceptable parameters. Save your report.