1 Reply Latest reply on Mar 19, 2013 6:29 PM by LyndsayHowarth

    Graph Legend - Restrict Repetitive Data

    g.bathurst

      Hello,

       

      I have a (Line) Graph that uses a TIMESTAMP on the X axis. I use a calculation that displays the hour on the X-Axis legend; hour (TIMESTAMP Field), this displays fine.

       

      Problem, The Legend is too compressed to display the multipe repetions of the hour, they are all mashed together, even at very small font size.

       

      I'm thinking I could resolve the mashed up legend by displaying the only the FIRST occurance of the hour and leaving the rest of the occurances in that hour blank.

      I'm bogged down on how best to execute this...suggestions?

       

      TIA

        • 1. Re: Graph Legend - Restrict Repetitive Data
          LyndsayHowarth

          Here is a theory (there would be several other ways I can thing of too):

           

          Calculate the hour separately and the date separately.

          Create a summary field called min time which gives you min of your timestamp

          Sort by date and hour and timestamp.

          Create a calculation getsummary(min time, hour)

          Create another calculation which says if (Timestamp = min time; Timestamp;'') (you might do it on a Time field and replace the value so it doesn't recalculate)

          Now you have records marked for the first entry for each hour. You should be able to find those records and chart them.

           

          That's a time-interval sort of approach... so you are not actually charting the records between. You could use a relationship back to the same date and hour then chart the related measures as averages.

           

          HTH

           

          - Lyndsay