4 Replies Latest reply: Jul 18, 2014 10:43 AM by Richard Howard RSS

    Line Chart show dimension label every 4 values

    Richard Howard

      I'm sure this must be very simple but I'm going round in circles trying to make this work.

       

      I have a table of values broken down into quarters of a day e.g. 01/07/2014 06:00, 01/07/2014 12:00, 01/07/2014 18:00, 02/07/2014 00:00, etc and I'd like to build a simple line chart that shows the sum of the IN and OUT numbers but only show a single dimension label by day but have four data points between each day.

       

      So currently I have this:

      Capture.PNG.png

       

      And I'd like something like this (ignore that it shows a label every four days as excel wouldn't let me break down a day into 4 segments)

      Capture3.PNG.png

       

      I've also attached the sample app.

       

      Cheers