Date and Time Adjustments

Overview:

Normalize and handle time-related data for reporting and analysis.

Transformations:

1. Convert Timestamps:

   • Convert raw timestamps into readable formats like YYYY-MM-DD or adjust them to the correct time zone.
   • Learn more about Timestamp Conversion

2. Calculate Service Duration:

   • Compute the time difference between ticket creation and resolution time to determine resolution duration.
   • Learn more about Service Duration Calculation

3. Hour-of-Day Segmentation:

   • Extract hour or day-of-week features from timestamp fields to analyze service center load patterns.
   • Learn more about Time-Based Analysis

4. Generate Time Intervals:

   • Categorize service request response time into “Fast”, “Medium”, or “Slow” based on predefined thresholds.
   • Learn more about Time Interval Classification