```sql orders_by_month
select date_trunc('month', order_date) as month, sum(sales) as total_sales
from orders
group by 1
order by 1

### Multiple Series

```markdown
```sql sales_by_category
select 
  date_trunc('month', order_date) as month,
  category,
  sum(sales) as total_sales
from orders
group by 1, 2
order by 1, 2

### Customized Line with Markers

```markdown
<LineChart 
  data={sales_by_category} 
  x="month" 
  y="total_sales" 
  series="category"
  lineWidth=3
  markers="true"
  markerSize=8
  yFmt="usd"
  xAxisTitle="Month"
  yAxisTitle="Revenue"
/>

```sql metrics
select 
  month,
  revenue,
  order_count
from monthly_metrics

### Step Line Chart

```markdown
<LineChart 
  data={inventory_levels} 
  x="date" 
  y="quantity"
  step="true"
  stepPosition="end"
  title="Inventory Levels"
/>

<LineChart 
  data={sales_by_category} 
  x="month" 
  y="total_sales" 
  series="category"
  seriesColors={{
    'Electronics': 'primary',
    'Clothing': 'secondary',
    'Food': 'accent'
  }}
  seriesOrder={['Electronics', 'Clothing', 'Food']}
/>