2 Replies Latest reply: Sep 4, 2012 4:30 AM by 958329 RSS

    Time Series Line Graph

    958329
      Hi, I am new to Studio. I have a bunch of tweets, which are time-stamped and I am trying to plot a temporal line graph to see the changes over time. Could someone advise how this can be done? Thanks!
        • 1. Re: Time Series Line Graph
          958946
          Easiest way is to load the data, ensuring that the twitter "created_at" attribute is formated as:

          EEE, d MMM yyyy HH:mm:ss Z

          You need to do this in the metadata for the tweets.

          You can then use put the created_at date on the group dimension (category axis) and use the count of tweets as the series metric.

          The only issue with using the unformatted date is that it retains all of the time component too, which can look a bit unsightly.

          If this is an issue for you (as Im sure it will be), then you can use the reformatter control to strip out the different date/time parts into string parts such as month, date (format as YYYYMMDD), hour, etc.

          Here is an example:

          $out.0.Str_Hour = date2str($in.0.interaction_created_at, "hh");
          $out.0.Str_Date = date2str($in.0.interaction_created_at, "yyyy-MM-dd");
          $out.0.Str_Year_ = date2str($in.0.interaction_created_at,"yyyy");
          $out.0.Str_Month = date2str($in.0.interaction_created_at, "yyyyMM");
          • 2. Re: Time Series Line Graph
            958329
            Hi, my date is currently in the following format: yyyy-MM-dd HH:mm:ss How and where should I go about converting it? Thanks!