Hi!
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
Thank you!
Hey
Welcome to the community! 😃
For a quick fix, I would suggest you create a Custom Measure, being the maximum of the goal-dimension. (Given that its type is a number.)
Clicking on the cog next to the goal dimension and selecting “Max” could already do the trick.
Note: This does sort-of assume there is an other dimension (not hidden) that assures there is only one goal for each row.
I hope this helps!
Kind regards,
Daan
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
