Extract weekdays from order dates and compare order counts

Check the data grain

This workflow expects one row per order and an order-date field. Parse a text date first. If an order number repeats across line items, raw row counts are not order counts; remove duplicates or otherwise align the grain first.

Create a weekday field

1. Select the order dataset in the sidebar, click Table, then open the Wrangle tab.
2. When the order date is text, turn on Parse Date and choose the matching Format. Skip this when it is already a date.
3. Turn on Extract Date Part, select the order date as Input Column, and choose Weekday as the date part.
4. Name the output Order Weekday and inspect the preview.

Count orders by weekday

1. In the same wrangling panel, turn on Aggregate Rows.
2. Set Group By to Order Weekday.
3. Choose Count as the aggregate function and name the result Order Count.
4. Confirm one row per weekday in the preview and click Create Dataset.
5. Optionally open Visualize for the new dataset and compare weekday and order count in a bar chart.

Limitations to consider

Raw counts can be misleading when the date range contains different numbers of each weekday. Holidays, opening hours, and timezone also matter. DataCello creates weekday and count fields; it does not automatically normalize business days or establish causality.