Creating a Gauge Chart to Reflect Upcoming Events Based on Todays Date

[Anonymous]

I need to create a gauge chart to reflect upcoming events based on todays date.  I am sure it is something simple but for some reason I cant wrap my brain around it.  Any help would be greatly appreciated.  Here is an example.

The clients sends their customer a certain letter based on a renewal date.  So for example if the renewal date is Jan. 1, 2015 they would send a letter at 90 days, 60 days, and 30 days of that date.  I need a gauge that would reflect the following.

Green: Renewal date is greater than 90 days of todays date.

Yellow: Renewal date is 90 to 61 days of todays date.

Orange: Renewal date is 60 to 31 days of todays date.

Red: Renewal date is 30 days or past todays date.

Thanks,

Chris

[Gysbert_Wassenaar]

You could use a straight table, add customer as dimension and and expression that returns a reference to a built-in image:

if([Renewal date]-today()>90, 'qmem://<bundled>/BuiltIn/led_g.png',

     if([Renewal date]-today()>60,  'qmem://<bundled>/BuiltIn/led_y.png',

          if([Renewal date]-today()>30, 'qmem://<bundled>/BuiltIn/led_0.png', 'qmem://<bundled>/BuiltIn/led_r.png')))

Set the Representation option to Image and the Image Formatting setting to Keep Aspect.

If that's not what you need, please provide more details and some sample data.