I am working on displaying our teams goals + actuals on a chart and am having trouble. I would like to display their goals as one line on a chart and their actual numbers as another line on that chart. Currently, I can only display the Measure (actuals) and can not display their goals as they were uploaded as constant numbers in a Dimension field.
I imagine my options are
- Turn their goals from a Measure to Dimension
- Somehow visualize the Measure