Hi! We need assistance showcasing overall data in comparison to a goal. This goal will be different month to month and needs to have the ability to change. This is in beast mode and we would like to compare our actual opportunities to the goals we can set manually. Any help would be greatly appreciated.
Have you tried using a form of the group by chart type? You can have one group be your actual and the other be your goal
I like to use the Bullet chart type for this type of visualization. It allows you to have a different goal for each month (or names as it is referred to in the Bullet chart). Here is a link to the KB article.