📋 Summary:

What it is: The Completed Hour AM/PM dimension represents the time of day an order was completed, categorized into morning or afternoon/evening time bands.

How to use it:
• Analyze purchasing patterns by identifying peak ordering times during day or night
• Segment customer behavior to understand when different customer groups prefer to complete wine orders

Tip: Select multiple AM/PM values to create comprehensive time-of-day filtering for more nuanced order analysis across broader time ranges.

This summary was generated by AI.

📊 Quick Stats:

This is the AM/PM representation of in local time zone of the order_completed_date

We extract the hour from the time and it returns just the hour component as an integer from 0-23, discarding any minutes or seconds.

Here's how it works:

The code then converts 24-hour format to 12-hour format:

So an order completed at 2:45:30 PM would show as "2 PM" in the order_completed_hour_am_pm field, effectively grouping all orders from 2:00:00 PM to 2:59:59 PM together.

​

Order General

Type: string