Forum Discussion

ColleenBurch's avatar
Qrew Trainee
2 years ago

Cumulative goal line on Line Trend Chart

I have created a report formula query field to show my actuals in a cumulative way for my primary y axis. (It is grouped by week in the x axis.)  What would a query look like to create a goal line in the secondary y axis that shows an increase by 45 each week (goal is 45/week)?  I do not have a field to summarize the goal.  Is there another report formula query that could accomplish this?

Colleen Burch
No RepliesBe the first to reply