{"uid":"cap_i8KDMjFVOTR1-TAJwUCTi","slug":"duplicate-observations-daily-sum-series-and-two-measure-correlation-756ff391","name":"Duplicate Observations Daily Sum Series and Two-Measure Correlation","description":"Duplicate observations — Daily sum series + Two-measure correlation: Daily sum series + Two-measure correlation 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-141?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"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_sy4DmRQtmAWS6y4Wqjdho","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":"Computes a daily sum time series and a two-measure correlation report for supplied duplicate_rows and total_rows data, up to 200 rows.","exampleAgentPrompt":"Can you run a daily sum series and two-measure correlation on my duplicate observations data? I have 5 rows across two dataset groups — group-a and group-b — with dates from 2026-10-01 to 2026-10-05, and I want to analyze the duplicate_rows field.","exampleUseCases":[{"title":"Data quality audit for ETL pipeline","prompt":"I have a week of ETL run logs with duplicate_rows and total_rows counts per day across two pipeline groups. Can you compute the daily sum series for duplicate_rows and show me the correlation between duplicate_rows and total_rows so I can see if duplication scales with volume?"},{"title":"Monitoring duplicate trends across dataset groups","prompt":"I'm tracking duplicate record counts across group-a and group-b datasets over the past month. Please give me a daily sum series and a correlation report between duplicate_rows and total_rows using these 80 rows of observations."},{"title":"Data governance report for deduplication review","prompt":"I need to prepare a data governance summary — can you run a daily sum series plus a two-measure correlation on my duplicate observations? I have 150 rows covering three dataset groups with dates from January through March, using the total_rows field."}],"resultDescription":"Returns two analytical reports: (1) a daily sum time series aggregating the selected measure (duplicate_rows or total_rows) by date, and (2) a two-measure correlation report showing the statistical relationship between duplicate_rows and total_rows across the supplied dataset. Both reports are computed locally from the submitted data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, date, dataset_group, duplicate_rows, total_rows) cause validation errors","Dates not in YYYY-MM-DD format fail pattern validation","Null values in measure fields may affect correlation computation","Empty rows array returns an error (minItems: 1)","Invalid field enum value (must be duplicate_rows or total_rows)"],"whenToPreferThis":"Choose this endpoint when you have tabular duplicate observation records with date, group, and two numeric measures (duplicate_rows, total_rows) and need both a daily aggregated time series and a correlation analysis in a single low-cost call. It is ideal for data quality monitoring, ETL auditing, and deduplication trend analysis on datasets up to 200 rows where no external data, predictions, or live lookups are needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T06:54:47.177Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-daily-sum-series-and-two-measure-correlation-756ff391"}