Line + Nested Bar

clloyd01

Hello -

 

Has anyone had any luck with using the chart type " Line + Nested Bar" ? I'd like to show all of our sales reps' opportunities in their various sales stages in a nested bar with the total value of their opps as a line using this chart type. The problem that I'm running into is, how do select the values for the line? 

 

This chart type isn't listed in the card building documentation so any help that anyone might be able to lend would be appreciated!

 

Thanks,

Chad

 

Valiant

Chad,

 

The line for the 'Line + Nested Bar' will be whatever measure you put in the Y Axis field. Take a look at the screenshot below:

The .Percent Change field will by my line in this example and the other two measures in the Series section are the resulting bars that make up your nested bar.

 

So if you want something like a total value for the line, you can create something like a SUM Beastmode and then drop that in your Y Axis.

 

If you have any other questions, please let me know.

 

Hope this helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.