This content has been marked as final. Show 3 replies
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:
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?