DKRbella0814
Board Regular
- Joined
- Aug 10, 2008
- Messages
- 155
Hello,
Can someone tell me if it is possible to create two views of 'Gap to Goal' in a single stacked bar chart? If so, please advise how to construct the table.
What I want included in the table is the following: Growth Funnel Target vs. Growth Funnel Actual (difference is gap to goal) AND Wins Target vs. Wins Actual (difference is gap to goal) - both need to be tracked on a monthly basis and it would be GREAT to be able to show the gap to goal for both metrics over the year (Jan-Dec).
I've tried experimenting with the following tables (Blank = gap to goal or difference between goal and actual), but no luck:
Growth Funnel Blank Wins Blank
Goal 1,200 186
Jan-2016 778.3 422 0 186
Feb-2016 894 306 4 182
Mar-2016 1000 200 37 149
Would like for the chart to look like this, but with two waterfalls - Gap to Goal for Growth Funnel and Gap to Goal for Wins.
https://www.think-cell.com/en/support/manual/waterfall.shtml
Thanks in advance!
Can someone tell me if it is possible to create two views of 'Gap to Goal' in a single stacked bar chart? If so, please advise how to construct the table.
What I want included in the table is the following: Growth Funnel Target vs. Growth Funnel Actual (difference is gap to goal) AND Wins Target vs. Wins Actual (difference is gap to goal) - both need to be tracked on a monthly basis and it would be GREAT to be able to show the gap to goal for both metrics over the year (Jan-Dec).
I've tried experimenting with the following tables (Blank = gap to goal or difference between goal and actual), but no luck:
Growth Funnel Blank Wins Blank
Goal 1,200 186
Jan-2016 778.3 422 0 186
Feb-2016 894 306 4 182
Mar-2016 1000 200 37 149
Would like for the chart to look like this, but with two waterfalls - Gap to Goal for Growth Funnel and Gap to Goal for Wins.
https://www.think-cell.com/en/support/manual/waterfall.shtml
Thanks in advance!
