⭐ GitHub SQL ↓
Reporting Infrastructure

Rank-based
Time Period Filtering

A centralised, database-agnostic engine that resolves any filter combination — Week, Month, Quarter, Year, or Custom — into a precise date range using one elegant formula.

Platform-Agnostic Config-Driven Rank-Based Algorithm 15 Reporting Views 3 Anchor Formats
Filter Selection
Q2-2025 2025-02 2025-06-30 Q4-2024
Result ● Live
Generated SQL
Filter Predicate
Stored Procedure
Full Query
Time Period Config Table 15 rows
Show / hide config rows
TP_Category TP_Category_display Reporting_view Reporting_view_span Reporting_view_order
Why this solution
🌐
Platform-Agnostic
Works across SQL Server, PostgreSQL, Snowflake, Redshift, BigQuery, and any BI tool
⚙️
Configurable
Add or change filters by updating the config table — zero code edits required
📈
Scalable
Easily supports new views and time logic by inserting new config rows
🔗
Consistent
Single source of truth that unifies time logic across all teams and reports
⚡
Efficient
Integer rank-based filtering is index-friendly and reduces query redundancy