Data Dictionary

Overview

Represents the total amount of sales tax collected from all transactions within a defined period. Essential for compliance, financial reporting, and profitability calculations.

Formula

Insights and Actions

• Ensures accurate collection and reporting of tax obligations.
• Compare tax contributions across different regions or markets.
• Helps determine pre- and post-tax profitability.
• Use tax data to project financial liabilities.
• Detect anomalies in tax calculation or reporting.

Detailed Breakdown

• Tax Tax_amount

Suggested Dimensions

Related Metrics

Example Use

Query

SELECT COALESCE(SUM(tax_amount), 0) AS tax_amount FROM orders WHERE order_date BETWEEN :start AND :end;