MX Dynamic Charts Forum :: Wrong Values

This thread was displayed: 456 times

Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/


View All View Non Threaded Newest first
  • 01-12-2007 00:28:00 GMT +2 bradley baker

    There seems to be an issue where all my data is being multiplied by the labels.

    IE my label field is numeric and it seems to be multiplying itself by the value field!?!

    My lables are numeric and are then inner joined

    SELECT *
    FROM incidents i INNER JOIN drop_down.it_personnel t on t.it_id=i.incident_it_personnel

    How can I fix this?

     

    Example

    lable is 7 and value is 4 on the chart is shows up as 28 and not 4

    10 and 10 = 100 not 10.  as you can see this make everything wr>

     

    You can ignore, had a noob moment =)  Figured out I had to get the counts and just the lables, work much better now hehe

    SELECT count(*), it_name
    FROM incidents i   INNER JOIN drop_down.it_personnel p on p.it_id=i.incident_it_personnel
    GROUP BY incident_it_personnel
MX Dynamic Charts 1.1.0
© Adobe Systems Romania. All rights reserved.