12 Replies Latest reply on Jul 18, 2016 4:38 AM by khalid norat

    continuous line graph - remove breaks between weeks? possible?

    ryan otto

      good day all - i have created a line graph counting parts replaced by week - it is a running total and is continuous.

       

      we have our own fiscal week calendar that differs from most - i have this in columns

      i have WEEKDAY(Service Date) in columns that shows the week day of that week the count was done

      in rows i have SUM(Number of Records)

       

      it works fine, but i get .... breaks in between the weeks. i need to show 1 continuous line and i can't figure it out.

      i have included a picture of the issue...i need the lines to connect between the weeks =) so a line connecting the 5 to the 5 and the 9 to the 9 etc.

       

      any help is appreciated.

       

      t1.JPG