Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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?
Yes