Bullet chart help

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

September 4th, 2015 6:53pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics