{"uid":"cap_Xh_qjQwejeXhJkQJltvFF","slug":"duplicate-observations-equal-width-histogram-date-by-category-pivot-ba6a7770","name":"Duplicate Observations — Equal-Width Histogram + Date by Category Pivot","description":"Duplicate observations — Equal-width histogram + Date by category pivot: Equal-width histogram + Date by category pivot for supplied duplicate observations records (duplicate_rows, total_rows). 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-04-173?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"bins":{"type":"integer","default":5,"maximum":30,"minimum":1},"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"}}},"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_UP0McuCZv3IMD-mYggJI5","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":"Generates an equal-width histogram and a date-by-category pivot table for supplied duplicate observation records (duplicate_rows, total_rows) in a single call.","exampleAgentPrompt":"I have 150 duplicate observation records with row IDs, dates, dataset groups, and duplicate_rows counts — can you run an equal-width histogram with 10 bins on duplicate_rows and also generate a date-by-category pivot for those records?","exampleUseCases":[{"title":"Data quality audit across dataset groups","prompt":"I've got records from our ETL pipeline with duplicate_rows and total_rows counts per dataset group and date — can you run a histogram with 5 bins on duplicate_rows and pivot them by date and category so I can see where the duplication is worst?"},{"title":"Distribution analysis for deduplication report","prompt":"We have 80 rows of duplicate observation data from last quarter with dataset groups like 'customers' and 'orders' — please generate an equal-width histogram with 8 bins on total_rows and a date-by-category pivot so I can put it in our deduplication report."},{"title":"Monitoring duplicate trends over time","prompt":"Here are 120 daily duplicate observation records across our 'group-a' and 'group-b' datasets — can you produce a 10-bin histogram on duplicate_rows and a date-by-category pivot so I can see if duplicates are trending up or down over time?"}],"resultDescription":"Returns two independent analytical reports: (1) an equal-width histogram showing frequency distribution of the selected numeric field (duplicate_rows or total_rows) across up to 30 user-defined bins, and (2) a date-by-category pivot table aggregating values by date and dataset_group. Both reports are computed locally on the supplied data, with no external lookups or predictions.","failureModes":["Exceeds 200 rows — request rejected","bins parameter outside 1–30 range — validation error","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — schema validation error","Invalid date format (not YYYY-MM-DD) — pattern validation error","Null values in numeric fields may affect histogram bin calculations","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you have up to 200 duplicate observation records and need both a frequency distribution histogram and a date-by-category pivot in one low-cost call. It is ideal for data quality audits, ETL pipeline monitoring, and deduplication reporting where you supply your own data and need fast, local statistical summaries without any external data fetching or prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:20.421Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-equal-width-histogram-date-by-category-pivot-ba6a7770"}