Visual Benchmark for Data Analytics AI Agents

Question II9: Identifying data discrepancies given guidance

  • Prompt: Orders can have the SubTotal calculated three ways: A) From the SalesOrderHeader B) Sum of OrderQty*UnitPrice C) Sum of OrderQty*ListPrice The calculation of C may often be higher than A or B because of discounts - call the ratio of A to C "Discount Rate". A and B, however, should always be the same. Give me an export of every Sales Order where A and B are NOT the same. In the result, include the Discount Rate, Sales Order ID, and all 3 versions of the Subtotal.
  • Category: Insight Identification
  • Datasets: AdventureWorks

Latest Results

Tool Score Timestamp Video Recording
unsupervised 0 June 28, 2024 - 1:48AM
ChatGPT 5 July 10, 2024 - 05:54 PM
Video Unavailable