Hello,
Ive created a bullet chart in a SSRS report to measure actual AUM against a Target AUM.
LinearPointer1 Is the actual AUM
LinearPointer2 is the Target AUM in 2019
At the start of 2015 AUM started at 3 billion and our goal is 12 billion by the end of 2019. So we are targeting adding .15 billion a month. (9 bill /60 months).
I wanted to see if someone could help me create three dynamic background colored ranges.
Red
I would like to create an expression for End range at Scale Value that counts the numbers of months after 12/31/14, then multiples that numbers by .09 (.15 *.6), and then adds the starting 3 (starting AUM).
This would indicated that we are below 60% of the target. Each months the value would update because the monthly count would increase.
Yellow
Start range at scale value This would be same expression as the end value for Red.
End range at Scale Value - counts the numbers of months after 12/31/14, then multiples that number by .12 (.15 *.8), and then adds the starting 3 (starting AUM).
This would indicate the where doing fair.
Green
Start range at scale value This would be same expression as the end value for Y