Add a time column

Use Time Column to display additional time information to your views.

Note: Some steps vary depending on whether you are creating an asset view or an event view. Where the procedure varies, the step is noted with the type of view to which it applies.

1. On the My Views page, select the view you want to modify and click Modify View. Then click Next to open the Modify View page.

   Note: If you are already on the Modify View page, skip to the next step.

2. Click Add Column.

3. (Asset Views) Click the Time Column tab.

   Use Time Column to add columns that display your time stamp data in a different format.

   

   1. From the Select Time Column Options for list, select either local time or Greenwich Mean Time (GMT).

      For example, if you choose Hour and GMT, this adds a column to your view that displays only the hour of your PI point in GMT time.

   2. Select a unit of time in the left column and click the right arrow.

   3. When you are finished, click the Display time column button.

4. (Event Views) Click the Time Column tab.

   The Select Time Column Options for list displays the different time-related data that you can display in the event view, including the event frame start time and end time. You can display this time in either local time of the computer running the PI Integrator Framework service or Greenwich Mean Time (GMT).

   

   1. From the Select Time Column Options for list, select the data you want displayed in your view.

   The following table describes the different times that can be displayed in your view.

   List Options	Description
   Local	When you use sampled values, time stamp of the data in local time. When you use summarized values, this time is Event Frame Local End Time.
   GMT	When you use sampled values, time stamp of the data in GMT time. When you use summarized values, this time is Event Frame GMT End Time.
   Event Frame Local Start Time	Start time of the event frame in local time.
   Event Frame Local End Time	End time of the event frame in local time.
   Event Frame GMT Start Time	Start time of the event frame in GMT time.
   Event Frame GMT End Time	End time of the event frame in GMT time
   Event Frame Duration	Event frame end time – (minus) event frame start time.
   Event Frame Relative Time	Row time – (minus) event frame start time.

5. Select the unit of time in the left column and click the right arrow.

   For example, if you select Event Frame Local Start Time and Hour, this adds a column with only the hour of the event frame start time in local time format.

6. When you are finished, click the Display time column button.