3 Replies Latest reply: Jul 5, 2012 3:31 AM by Johannes Sunden RSS

    GaugeChart doesn't change when selection is changing

      Hi,

       

      i have a Gauge chart that should respond when i make selections in my Listboxes. For now it only calculates tyhe percentage once.

      I would like to present the percentage of meldingen that are intime.

       

      I have the following table:

      Meldingen:

      LOAD

             DATAAREAID,

             NOTIFICATIONID,

             CBSDISTRICTID,

          CBSNEIGHBOURHOODID,

          DISTURBANCEDESCRIPTION,

          DISTURBANCEID,

          STATUS AS MeldingStatusID,

          DATE(FLOOR(NUM(REGISTRATIONDATETIME))) as REGISTRATIONDATETIME,

          DATE(FLOOR(NUM(DEALBEFOREDATETIME))) as DEALBEFOREDATETIME,

          DATE(FLOOR(NUM(CLOSEDDATETIME))) as CLOSEDDATETIME,

          IF (CLOSEDDATETIME > DEALBEFOREDATETIME, 0,1) as INTIME

          ;

       

      The expression in mij Gauge is as follows:

      =Sum(INTIME)/Count(NOTIFICATIONID) *100 &'%'

      In my opinion is SUM(INTIME) the number of meldingen that are in time, and count NOTIFICATIONID the total of meldingen

       

      Can anybody help me?