Loading model details...
Gemini 2.0 Flash | DAXBench
Back to Leaderboard
Google
Gemini 2.0 Flash
Rank
#29
Overview
Analytics
Score Overview
76.6%
Overall Score
73.3%
Accuracy
100.0%
Syntax Valid
Score Dimensions
79
Correctness
88
Best Practices
88
Performance
88
Clarity
Performance by Complexity
Basic
100.0%
Intermediate
74.1%
Advanced
71.0%
Tasks Correct
22 / 30
Avg Response Time
760ms
Task Breakdown
Summary
Dimensions
Task
Category
Score
Time
Total Sales Amount
task-001
aggregation
100%
577ms
Count of Customers
task-002
aggregation
100%
469ms
Average Unit Price
task-003
aggregation
100%
597ms
Distinct Product Count
task-004
aggregation
100%
614ms
Total Order Quantity
task-005
aggregation
100%
502ms
Year-to-Date Sales
task-006
time intelligence
100%
615ms
Previous Year Sales
task-007
time intelligence
100%
748ms
Sales by Category Filter
task-008
filtering
100%
573ms
Year-over-Year Growth Percentage
task-009
calculation
30%
1105ms
Running Total with CALCULATE and FILTER
Query Failed
task-010
iterator
10%
842ms
Sales Summary by Category
task-011
table manipulation
100%
615ms
Product List with Renamed Columns
task-012
table manipulation
100%
705ms
Union of High-Value Transactions
task-013
table manipulation
30%
1125ms
Year-Category Analysis Matrix
task-014
table manipulation
100%
537ms
Product Percentage of Category Total
task-015
context transition
30%
908ms
Virtual Relationship with TREATAS
task-016
context transition
100%
657ms
Granularity-Aware Measure with VALUES
Query Failed
task-017
context transition
10%
766ms
Running Count with EARLIER
task-018
context transition
30%
751ms
Multiple Filter Conditions
task-019
filtering
100%
580ms
Percentage of Total with ALLEXCEPT
task-020
filtering
100%
822ms
Filter Intersection with KEEPFILTERS
task-021
filtering
100%
829ms
Product Ranking with RANKX
task-022
iterator
100%
1186ms
Top 5 Products with TOPN
task-023
table manipulation
30%
1061ms
90th Percentile Order Value
task-024
iterator
100%
553ms
Handle Missing Data with BLANK
task-025
calculation
100%
512ms
Safe Ratio with Cascading Fallbacks
task-026
calculation
100%
1075ms
Safe Year-over-Year with Missing Data
Query Failed
task-027
time intelligence
10%
1194ms
3-Month Rolling Average
task-028
time intelligence
100%
930ms
Same Month Previous Year Comparison
task-029
time intelligence
100%
619ms
Fiscal Year-to-Date (July Start)
task-030
time intelligence
100%
719ms