Date Sequences – a stupid error to watch for.

DataGraph Forums › Technical Support › Support Desk › Date Sequences – a stupid error to watch for.

Tagged: 

  • This topic has 2 replies, 2 voices, and was last updated 1 year ago by iantownsend.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #15850
    iantownsend
    Participant

      I have just enjoyed watching the tutorial on YouTube for understanding and manipulating dates.

      I decided to experiment with a set of personal data consisting of a date column and a column of weights.  I could create box and whicker and histograms with the data, but could not get the date sequence to work.  This proved to be because in the spreadsheet from which the 200 data points had been imported, one date had been entered incorrectly as 2323 instead of 2023.

      I am now taking great care to check and error trap data before starting to create graphs.

       

      #15853
      dgteam
      Moderator

        Glad you are finding the tutorials helpful! One helpful feature for quickly checking the content of any column is to use Quick graph.

        1 – Click the header to select the column
        2 – Hit the space bar

        If the column is a date or number column, you will see a pop-up window with a Histogram. Very helpful for seeing the range of the data and seeing outliers! If the column is a text column, you get a list of each unique entry and a count of the number of instances.

         

        #15854
        iantownsend
        Participant

          Thank you!  I am aware of using the spacebar to see the histogram, but failed to use it.  I will in future.  I thought I had made an error in configuring the data.  Once I realised a year had been entered into the original spreadsheet incorrectly, everything corrected within seconds.  It is a case of “practice makes perfect”.  Datagraph has so many powerful features it takes a while to learn them.

        Viewing 3 posts - 1 through 3 (of 3 total)
        • You must be logged in to reply to this topic.

        DataGraph Forums › Technical Support › Support Desk › Date Sequences – a stupid error to watch for.