{"uid":"cap_1uScel6CE3cgNfiuveB1V","slug":"duplicate-observations-analytics-base-100-series-two-measure-2c06edef","name":"Duplicate Observations Analytics: Base-100 Series + Two-Measure Correlation","description":"Duplicate observations — Base-100 series + Two-measure correlation: Base-100 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-165?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_M7br0a4nDj7daAUCFiN4T","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 Base-100 indexed time series and a two-measure correlation report for supplied duplicate-observation records (duplicate_rows, total_rows) — up to 200 rows, two independent analytical reports per call.","exampleAgentPrompt":"Can you run a base-100 series and two-measure correlation on my duplicate observation data? I have 4 rows — group-a on 2026-10-01 with 10 duplicate_rows out of 1 total, group-b on 2026-10-02 with 20 duplicate_rows out of 2 total, group-a on 2026-10-03 with 15 duplicate_rows out of 3 total, and group-b on 2026-10-04 with 30 duplicate_rows out of 4 total — use duplicate_rows as the field and base_index 0.","exampleUseCases":[{"title":"Data pipeline duplicate trend indexing","prompt":"I have daily duplicate row counts from two dataset groups over the past month — can you index them to a base-100 series starting from the first row and also give me a correlation between duplicate_rows and total_rows? Here's my data: group-a on 2026-11-01 had 5 duplicate_rows out of 100 total, group-a on 2026-11-02 had 8 duplicate_rows out of 120 total, group-b on 2026-11-01 had 12 duplicate_rows out of 200 total, group-b on 2026-11-02 had 18 duplicate_rows out of 210 total."},{"title":"Cross-group duplicate correlation audit","prompt":"We're auditing data quality across two ingestion pipelines. Can you compute the two-measure correlation between duplicate_rows and total_rows for these records and also produce a base-100 indexed series using total_rows as the field, starting at base_index 0? Groups are pipeline-x and pipeline-y across five dates in October 2026."},{"title":"Monitoring duplicate rate normalization","prompt":"I want to normalize my weekly duplicate observation counts to a base-100 index so I can compare trends — use duplicate_rows as the field and base it off row index 2. Also run the two-measure correlation report on the same dataset. I have 6 rows across dataset groups alpha and beta from 2026-09-01 to 2026-09-06."}],"resultDescription":"Returns two independent analytical reports: (1) a Base-100 indexed series normalizing the selected field (duplicate_rows or total_rows) relative to the specified base_index row, and (2) a two-measure correlation report between duplicate_rows and total_rows across the supplied records. No external lookups or predictions are made — all computation is performed locally on the supplied data.","failureModes":["Fewer than 1 row supplied — minItems:1 validation error","More than 200 rows supplied — maxItems:200 exceeded","Invalid date format (not YYYY-MM-DD) — pattern validation failure","base_index out of range (0–199) — schema validation error","null values in duplicate_rows or total_rows may affect correlation computation","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — schema validation error"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous local analytical outputs — a Base-100 normalized time series AND a correlation between duplicate_rows and total_rows — computed entirely from supplied data without any external API calls or predictions. Ideal for data quality workflows where you want to track duplicate observation trends over time and measure how duplicate counts relate to total row volumes across dataset groups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:16.838Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-base-100-series-two-measure-2c06edef"}