1 Reply Latest reply: Apr 3, 2012 10:34 AM by Magnus ÅVITSLAND RSS

    Gauge Chart Frustration

      I have a table containing milestone dates of varying "types" (A, B, C, etc). I am trying to create a set of gauge charts, one for each type, and I'm having difficulty getting the number of milestone dates that have occurred this year up to and including Today to display correctly.

       

      I am creating a separate gauge chart for each type (with one being for the either E or F sum). I am not specifying any dimensions, and am trying to use an expression such as this:

       

      Sum(If([Milestones.MS Abbr]='D',If(Year([Milestones.MS Date])=2012,If([Milestones.MS Date]<=Today(),1,0),0),0))

       

      For some reason, this is not working. What am I doing wrong?