Loading model details...
Gemma 3 27B (free) | DAXBench
Back to Leaderboard
Google
Gemma 3 27B (free)
Rank
#81
Overview
Analytics
Score Overview
50.5%
Overall Score
46.7%
Accuracy
100.0%
Syntax Valid
Score Dimensions
55
Correctness
62
Best Practices
62
Performance
63
Clarity
Performance by Complexity
Basic
100.0%
Intermediate
46.0%
Advanced
37.8%
Tasks Correct
14 / 30
Avg Response Time
1660ms
Task Breakdown
Summary
Dimensions
Task
Category
Score
Time
Total Sales Amount
task-001
aggregation
100%
1227ms
Count of Customers
task-002
aggregation
100%
1036ms
Average Unit Price
task-003
aggregation
100%
1060ms
Distinct Product Count
task-004
aggregation
100%
1053ms
Total Order Quantity
task-005
aggregation
100%
796ms
Year-to-Date Sales
Query Failed
task-006
time intelligence
10%
1236ms
Previous Year Sales
task-007
time intelligence
100%
1047ms
Sales by Category Filter
task-008
filtering
100%
1024ms
Year-over-Year Growth Percentage
Query Failed
task-009
calculation
10%
2170ms
Running Total with CALCULATE and FILTER
task-010
iterator
30%
2054ms
Sales Summary by Category
task-011
table manipulation
100%
1313ms
Product List with Renamed Columns
Query Failed
task-012
table manipulation
10%
1300ms
Union of High-Value Transactions
Query Failed
task-013
table manipulation
10%
1412ms
Year-Category Analysis Matrix
task-014
table manipulation
30%
1194ms
Product Percentage of Category Total
Query Failed
task-015
context transition
10%
2749ms
Virtual Relationship with TREATAS
task-016
context transition
100%
1589ms
Granularity-Aware Measure with VALUES
Query Failed
task-017
context transition
10%
1796ms
Running Count with EARLIER
task-018
context transition
30%
1709ms
Multiple Filter Conditions
task-019
filtering
100%
1513ms
Percentage of Total with ALLEXCEPT
Query Failed
task-020
filtering
10%
2110ms
Filter Intersection with KEEPFILTERS
Query Failed
task-021
filtering
10%
1588ms
Product Ranking with RANKX
task-022
iterator
100%
1289ms
Top 5 Products with TOPN
Query Failed
task-023
table manipulation
10%
3147ms
90th Percentile Order Value
task-024
iterator
100%
985ms
Handle Missing Data with BLANK
task-025
calculation
100%
1281ms
Safe Ratio with Cascading Fallbacks
task-026
calculation
30%
2632ms
Safe Year-over-Year with Missing Data
Query Failed
task-027
time intelligence
10%
4135ms
3-Month Rolling Average
Query Failed
task-028
time intelligence
10%
2036ms
Same Month Previous Year Comparison
task-029
time intelligence
30%
1573ms
Fiscal Year-to-Date (July Start)
task-030
time intelligence
100%
1754ms