Loading model details...
Gemini 2.0 Flash Lite | DAXBench
Back to Leaderboard
Google
Gemini 2.0 Flash Lite
Rank
#70
Overview
Analytics
Score Overview
59.2%
Overall Score
53.3%
Accuracy
100.0%
Syntax Valid
Score Dimensions
64
Correctness
81
Best Practices
80
Performance
81
Clarity
Performance by Complexity
Basic
100.0%
Intermediate
55.5%
Advanced
48.8%
Tasks Correct
16 / 30
Avg Response Time
796ms
Task Breakdown
Summary
Dimensions
Task
Category
Score
Time
Total Sales Amount
task-001
aggregation
100%
428ms
Count of Customers
task-002
aggregation
100%
426ms
Average Unit Price
task-003
aggregation
100%
417ms
Distinct Product Count
task-004
aggregation
100%
393ms
Total Order Quantity
task-005
aggregation
100%
414ms
Year-to-Date Sales
task-006
time intelligence
100%
470ms
Previous Year Sales
Query Failed
task-007
time intelligence
10%
523ms
Sales by Category Filter
task-008
filtering
100%
524ms
Year-over-Year Growth Percentage
task-009
calculation
30%
888ms
Running Total with CALCULATE and FILTER
task-010
iterator
30%
745ms
Sales Summary by Category
task-011
table manipulation
30%
722ms
Product List with Renamed Columns
task-012
table manipulation
100%
1024ms
Union of High-Value Transactions
task-013
table manipulation
100%
1146ms
Year-Category Analysis Matrix
Query Failed
task-014
table manipulation
10%
980ms
Product Percentage of Category Total
task-015
context transition
30%
803ms
Virtual Relationship with TREATAS
Query Failed
task-016
context transition
10%
857ms
Granularity-Aware Measure with VALUES
task-017
context transition
30%
928ms
Running Count with EARLIER
task-018
context transition
30%
690ms
Multiple Filter Conditions
task-019
filtering
100%
659ms
Percentage of Total with ALLEXCEPT
task-020
filtering
100%
1267ms
Filter Intersection with KEEPFILTERS
task-021
filtering
100%
860ms
Product Ranking with RANKX
Query Failed
task-022
iterator
10%
640ms
Top 5 Products with TOPN
task-023
table manipulation
100%
1030ms
90th Percentile Order Value
task-024
iterator
100%
603ms
Handle Missing Data with BLANK
task-025
calculation
100%
475ms
Safe Ratio with Cascading Fallbacks
Query Failed
task-026
calculation
10%
975ms
Safe Year-over-Year with Missing Data
task-027
time intelligence
30%
1430ms
3-Month Rolling Average
task-028
time intelligence
30%
1956ms
Same Month Previous Year Comparison
task-029
time intelligence
100%
610ms
Fiscal Year-to-Date (July Start)
task-030
time intelligence
30%
992ms