GaugeChart doesn't change when selection is changing

[#1]

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?

[Anonymous]

Hi Jeroen,

Could you upload a small example application to illustrate the problem?

[#3]

I uploaded a file within my original post.

Thnx for responding!

[Anonymous · Accepted solution]

1. Go to Expression tab: Uncheck"Relative" checkbox

2. Go to Presentation tab: Uncheck "Show labels on every.." checkbox.

This should work