{"uid":"cap__PgMxORRERV48sJJmbLN7","slug":"internal-support-numeric-interval-filter-date-by-category-pivot-a309d08f","name":"Internal Support — Numeric Interval Filter + Date by Category Pivot","description":"Internal support — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied internal support records (responded_requests, received_requests). 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-operations-22-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","responded_requests","received_requests"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"received_requests":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"responded_requests":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","received_requests":1,"responded_requests":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","received_requests":2,"responded_requests":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","received_requests":3,"responded_requests":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","received_requests":4,"responded_requests":30}],"maxItems":200,"minItems":1},"field":{"enum":["responded_requests","received_requests"],"type":"string","default":"responded_requests"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_wKEAPWMhws810TP9W1vAb","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":"Filters internal support records by a numeric interval and pivots date data by category, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Filter our support records where responded_requests is between 5 and 50, then pivot the dates by team_group — here are the rows: [{\"row_id\":\"r1\",\"team_group\":\"group-a\",\"date\":\"2026-10-01\",\"received_requests\":10,\"responded_requests\":8},{\"row_id\":\"r2\",\"team_group\":\"group-b\",\"date\":\"2026-10-02\",\"received_requests\":20,\"responded_requests\":45}].","exampleUseCases":[{"title":"Support team response rate audit","prompt":"I have 150 rows of daily support data across three team groups. Can you filter for rows where responded_requests falls between 10 and 100, then pivot the dates by team_group so I can see which teams are most active each day?"},{"title":"Received requests volume analysis","prompt":"Run a numeric interval filter on received_requests between 0 and 500, and give me a date-by-category pivot grouped by team_group — here's my dataset of 80 support log rows."},{"title":"Low-response team identification","prompt":"I want to find which team groups had responded_requests between 1 and 20 on any given day, and see a date pivot by category. Use these 200 rows of internal support records to run both reports at once."}],"resultDescription":"Returns two independent analytical reports: (1) rows from the supplied dataset where the chosen field (responded_requests or received_requests) falls within the specified numeric interval [minimum, maximum], and (2) a pivot table of dates broken down by team_group category — all computed locally on the supplied data, no external lookups.","failureModes":["Missing required row fields (row_id, team_group, date, responded_requests, received_requests) cause validation errors","Date values not matching YYYY-MM-DD pattern are rejected","Supplying more than 200 rows exceeds the maxItems limit","Minimum value greater than maximum value may yield empty filter results","Null numeric values in the filtered field may be excluded from interval results"],"whenToPreferThis":"Choose this endpoint when you have up to 200 internal support records with team_group and date dimensions and need both a numeric range filter on request counts AND a date-by-category pivot in a single low-cost call ($0.01 USDC). It is ideal for offline/batch analytical work on pre-collected support data where no live data lookup, external enrichment, or prediction is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:47:57.889Z","isFirstParty":false,"canonicalSlug":"internal-support-numeric-interval-filter-date-by-category-pivot-a309d08f"}