Overlaying a Line Value on a Chart

[John_G]

Hello - I have a data table that looks like this, and I am trying to make a bar chart that displays the subcontract value as a 'line value' (see second pic as an example of what I am trying to achieve) 

So I have many different issue descriptions per company, many companies per project, and a single subcontract value for each company on each project. 

I'm stuck! Can anyone help me on this?  

[Sean]

@John_G where exactly are you stuck?

Ok you want the line to represent the subcontract value.

I see 8 bars - what do they represent - and how do you calculate the value of each bar?

The sample data table you've posted is not enough to duplicate the chart?

[John_G]

@Sean Hi - Yes I know the data set I posted is just an example and does not match the graph I posted. 

Yes, I want the line to represent the contact value at each project. 

Each bar represents a project, and a count of how many issues are noted for a particular subtrade on the project. 

The problem is, each issue on a project has the same 'subcontract value' 

For example:

Trade A | Project 1 | Missing plug            | Subcontract value $100,000

Trade A | Project 1 | Missing switch         | Subcontract value $100,000

Trade A | Project 1 | Missing thermostat | Subcontract value $100,000

If I graph this, I get a line that says either "3" or "$3,000,000" but what I really need is a line that says "$100,000"

Make sense? 

[Sean]

@John_G

Okay I get it now - easiest way to solve this => go to Line Values => Right-Click => select either MIn or Max

[Sean · Accepted solution]

@John_G

Here it is with MIn/Max - the way you probably have it set up

If you do want to use Measures though - here you go...

Hope this helps!

[John_G]

Awesome thank you much!