Forum Discussion

ColleenBurch's avatar
ColleenBurch
Qrew Trainee
12 months 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