1 of 1 people found this helpful
You're on the right track with using a line and running sum. What I would do is use a parameter for your daily goal amount (in this case it's 3.5) and a calculated field that goes:
Running_Sum(Avg([Daily Goal Parameter])).
This will increment by 3.5 (or whatever other number you select for the parameter) for every day that you are showing data. This distinction is important, because it won't automatically go up for every calendar day, and the results will be different if you're only showing part of a month.
Hope this helps,
Thanks, Zack, very helpful! It would be great if this were a reference line that I could format separately, but I'll take this as a big improvement.