1 Reply Latest reply: Sep 14, 2010 7:30 AM by Miguel Angel Baeyens de Arce RSS

    Values adding together

    pepps1976

      I am trying to create a bar graph that shows total amount of Quotes per month from jan 2010 to september 2010 my script looks like this at the moment

       

       

       

       

       

       

       

       

       

       

       

       



       

      LOAD

       

       

      Month(ih_quodate) as [Quote Month],Text(ih_quotat) as [Quote No]; LOAD * WHERE Year([ih_quodate]) = 2010
      SQL SELECT
      `ih_quodate`,
      `ih_quotat`
      FROM
      ihead;

      My Bar graph seems to display coreectly and shows the correct amount of quotes for Jan but then seems to add up Febs quotes with January Quotes and the same with the rest of the months.

      So January would be say 112 and febuary should be 210 but it show Februarys as 322 instead, it does this for all the other months just adding them together.

      Is it possible to prevent this.?

      Thanks

      John