{"uid":"cap_lLEFVJlju33K3mb7wVUYC","slug":"record-routing-analytics-daily-sum-series-secondary-measure-weighted-7f613423","name":"Record Routing Analytics — Daily Sum Series + Secondary-Measure Weighted Mean","description":"Record routing — Daily sum series + Secondary-measure weighted mean: Daily sum series + Secondary-measure weighted mean for supplied record routing records (accepted_records, rejected_records). 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-19-142?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["accepted_records","rejected_records"],"type":"string","default":"accepted_records"}}},"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_cVSkwcrfxlk12v_vt1Xno","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 secondary-measure weighted mean for accepted_records and rejected_records routing data across up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Compute the daily sum series and secondary-measure weighted mean for my record routing data — I have 4 rows with accepted_records as the primary field, grouped as group-a and group-b across dates 2026-10-01 through 2026-10-04.","exampleUseCases":[{"title":"ETL pipeline rejection rate analysis","prompt":"I have a week of ETL run data with accepted and rejected record counts per day across two dataset groups. Can you compute the daily sum series for rejected_records and give me the secondary-measure weighted mean so I can spot which days had the worst rejection rates?"},{"title":"Daily ingestion volume tracking","prompt":"Here are 50 rows of record routing logs with dates, group labels, and accepted_records counts — please run the daily sum series and weighted mean reports on accepted_records so I can see how ingestion volume trends over time."},{"title":"Dataset group acceptance comparison","prompt":"I want to compare two dataset groups' routing performance. Can you calculate the daily sum series plus the secondary-measure weighted mean for accepted_records across my 30 rows of routing data, split by group-a and group-b?"}],"resultDescription":"Returns two independent analytical reports: (1) a daily sum series showing totals of the selected field (accepted_records or rejected_records) aggregated by date, and (2) a secondary-measure weighted mean across the supplied rows, using the complementary measure as the weight. Both reports cover up to 200 input rows and are computed using local analytical engines with no external lookups.","failureModes":["Fewer than 1 row supplied returns a validation error","More than 200 rows submitted exceeds the maximum and is rejected","Invalid date format (not YYYY-MM-DD) fails schema validation","Missing required fields (row_id, date, accepted_records, rejected_records) causes rejection","Null values in both primary and secondary measure fields may produce undefined weighted mean","Invalid field enum value (not 'accepted_records' or 'rejected_records') fails validation"],"whenToPreferThis":"Choose this endpoint when you have tabular record routing data (accepted/rejected record counts by date and group) and need both a daily aggregated sum series and a weighted mean statistic in a single $0.01 call. Ideal for lightweight, offline analytical summarization of up to 200 rows without needing a full data warehouse or BI tool. Not suitable for real-time monitoring, predictive analytics, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:48:07.108Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-daily-sum-series-secondary-measure-weighted-7f613423"}