Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
1. Go to Expression tab: Uncheck"Relative" checkbox
2. Go to Presentation tab: Uncheck "Show labels on every.." checkbox.
This should work
Hi Jeroen,
Could you upload a small example application to illustrate the problem?
I uploaded a file within my original post.
Thnx for responding!
1. Go to Expression tab: Uncheck"Relative" checkbox
2. Go to Presentation tab: Uncheck "Show labels on every.." checkbox.
This should work