Custom Report Builder
Drag fields to the canvas, configure filters and groupings, then preview or export
📊 Available Fields
Identity Fields ▼
License No.
TEXT
Company Name
TEXT
Sector
ENUM
License Type
ENUM
Region
ENUM
Date Fields ▼
Issue Date
DATE
Expiry Date
DATE
Last Inspection
DATE
Application Date
DATE
Status Fields ▼
License Status
ENUM
Compliance Score
NUM
Violations Count
NUM
Inspection Result
ENUM
Metric Fields ▼
Processing Days
NUM
Fee Paid (IDR)
CURR
Penalty Amount
CURR
Days to Expiry
CALC
Aggregates ▼
COUNT(*)
AGG
SUM(Fee Paid)
AGG
AVG(Compliance Score)
AGG
AVG(Processing Days)
AGG
ⓘ Click or drag fields to add columns
↕
Company Name
TEXT
×
↕
Sector
ENUM
×
↕
License Status
ENUM
×
↕
Compliance Score
NUM
×
↕
AVG(Processing Days)
AGG
×
↕
COUNT(*)
AGG
×
↷ Drop additional fields here
Group By
Sector ×
License Status ×
+ Add Group
Filters
▷ Live Preview
Click Run Preview to generate results
| Company | Sector | Status | Score | Avg.Days | Count |
|---|---|---|---|---|---|
| BPDB | Electricity | Active | 94% | 10.2 | 1 |
| PT Pertamina | Oil & Gas | Active | 88% | 12.4 | 1 |
| PT PGN Tbk | Gas | Pending | 80% | 15.1 | 1 |
| PT Star Energy | Geothermal | Active | 91% | 9.8 | 1 |
| PT Medco Energi | Oil & Gas | Expired | 71% | 18.3 | 1 |
| Preview (5 of est. 312 rows) | 84.8% | 13.2 | 312 | ||
Summary Metrics
312
Total Records
84.8%
Avg. Compliance
13.2
Avg. Processing Days
18
Non-Compliant
Start from Template
📜 Licensing Overview
Company, sector, status, expiry
✅ Compliance Analysis
Score, violations, inspector
💰 Revenue Breakdown
Fee, penalty, sector, quarter
💲 Tariff Comparison
Proposed vs approved rates