Bar Chart with Multiple Reference Lines

[evansabres]

I have a bar char in which the dimension is called 'nwEventDate' and an expression of =[Net Sold Qty]

For each nwEventDate, I have a target number for [Net Sold Qty]. In the chart, I want to create a reference indicator to show where each nwEventDate is in relation to the target [Net Sold Qty]

What is the most efficient way to do this?

[effinty2112 · Accepted solution]

Hi Evan,

Try a combo chart with the two expressions Sum([Net Sold Qty]) and Target. In the Expressions tab configure the first expression as Bar and the second as Symbol.

Cheers

Andrew

[evansabres]

Andrew -

Thank you for the response. Each nwEventDate has a different target quantity [Net Sold Qty]

For example, 10/1/17  has a target of 18,000

but 10/2/17 has a target of 16,500

Would your solution still apply?

[Anil_Babu_Samineni]

Yes