{"uid":"cap_AIH55QzPdGCeuynbCGSmd","slug":"numeric-precision-comparisons-duplicate-key-report-date-by-category-975f8670","name":"Numeric Precision Comparisons — Duplicate Key Report + Date by Category Pivot","description":"Numeric precision comparisons — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied numeric precision comparisons records (source_value, transformed_value). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-20-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_value","transformed_value"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"transformed_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_value":10,"dataset_group":"group-a","transformed_value":1},{"date":"2026-10-02","row_id":"row-2","source_value":20,"dataset_group":"group-b","transformed_value":2},{"date":"2026-10-03","row_id":"row-3","source_value":15,"dataset_group":"group-a","transformed_value":3},{"date":"2026-10-04","row_id":"row-4","source_value":30,"dataset_group":"group-b","transformed_value":4}],"maxItems":200,"minItems":1},"field":{"enum":["source_value","transformed_value"],"type":"string","default":"source_value"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_JxFNUzOES2Wj_4VLtIB-V","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Runs two local analytical reports on supplied numeric precision comparison records: a duplicate key report and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"I have a table of up to 200 numeric precision comparison records with row IDs, dataset groups, dates, source values, and transformed values — can you run a duplicate key report and a date-by-category pivot on the source_value field for me?","exampleUseCases":[{"title":"ETL pipeline data quality audit","prompt":"I just ran an ETL job and have 150 rows of source vs transformed numeric values tagged by group and date — can you check for any duplicate row IDs and also pivot the source_value totals by date and dataset group so I can spot anomalies?"},{"title":"Numeric transformation accuracy review","prompt":"I have a set of before-and-after numeric records from our data pipeline, each with a row ID, group label, and date. Run a duplicate key report and a date-category pivot on the transformed_value field so I can see where values changed across groups."},{"title":"Finance reconciliation comparison report","prompt":"Here are 80 rows of financial reconciliation data with source and transformed amounts, grouped by category and dated by transaction date — give me a duplicate row ID report and a pivot of source_value by date and category."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any repeated row_id values in the supplied dataset, and (2) a date-by-category pivot table aggregating the selected numeric field (source_value or transformed_value) across dataset_group and date dimensions. All computation is performed locally on the supplied data with no external lookups.","failureModes":["Input array is empty or missing — minItems:1 validation error","Row count exceeds 200 — maxItems:200 validation error","row_id missing or blank — minLength:1 validation error","date field does not match YYYY-MM-DD pattern — pattern validation error","source_value or transformed_value out of range ±1,000,000,000,000 — numeric bounds error","field enum value not 'source_value' or 'transformed_value' — enum validation error","Payment of 0.01 USDC not provided — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical reports — a duplicate key check and a date-by-category pivot — on a batch of up to 200 numeric comparison records (source vs transformed values), without requiring any external data lookups or live integrations. It is ideal for ETL auditing, data quality checks, and transformation validation workflows where you already have the full dataset locally.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:39.053Z","isFirstParty":false,"canonicalSlug":"numeric-precision-comparisons-duplicate-key-report-date-by-category-975f8670"}