Ashby Analytics
Building Custom Reports & Dash...
Adding Lines to Reports & Forecasts
5 min
this document reviews how to add various line types to count over time and segmentation reports these line types can be horizontal reference lines for target thresholds, or trend lines for progress tracking the option to add forecasts and progress tracking is also covered add goal lines to reports to count over time reports adding goal lines to reports in ashby is currently supported for count over time and segmentation report types to add a line, simply click "add line" in the view options section of the report configuration once a line is added you will have a new set of line options depending on your report configuration the two types of lines, reference lines and goal lines, and an optional forecast summary are described below reference lines a reference line is a straight line threshold to be rendered on any report the reference line has three possible value choices custom a line is rendered at the numeric value specified by the user input average a line is rendered at the average value of the reported data median a line is rendered at the median value of the reported data add a reference line with a custom value select + add line in the view options section enter an optional label for your line select reference line as the line type select custom for the value and enter the target value screen shot 2022 12 27 at 7 37 46 am png trend lines & forecasts trend lines can be added to reports to represent a linear target over time a trend line type requires an end value which represents the target for the end of the time period the start value of the line is automatically provided to fit the linear growth over the time grouping and target end value provided however, a custom start value can be entered when a count over time count as is switched to running total, the option to forecast progress against the trend line is made available enabling the forecast summary provides a forecast based on historic progress in the report screen shot 2021 09 03 at 4 17 14 pm png adding a trend line with a forecast select + add line in the view options set the report counting to running total select the trend line line type enter a target value you wish to reach by the end of your time period the start value is optional and will default to a linear extrapolation from your end value toggle on include forecast? forecast details the forecast line is determined by your reported performance to date and does a linear extrapolation when mousing over the forecast line, the current time elapsed, percent to goal, and estimate of your end value based on past activity are shown details png