{"uid":"cap_31xwXRvg7DkJ3hO_c_TWC","slug":"partnership-pipeline-numeric-interval-filter-date-by-category-pivot-4768cddc","name":"Partnership Pipeline — Numeric Interval Filter + Date by Category Pivot","description":"Partnership pipeline — Numeric interval filter + Date by category pivot: Numeric interval filter + Date by category pivot for supplied partnership pipeline records (qualified_partners, active_partners). 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-company-09-133?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","qualified_partners","active_partners"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"active_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"qualified_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","active_partners":1,"qualified_partners":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","active_partners":2,"qualified_partners":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":30}],"maxItems":200,"minItems":1},"field":{"enum":["qualified_partners","active_partners"],"type":"string","default":"qualified_partners"},"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_HYg9tsY4w-KwIBaN8tGoU","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 partnership pipeline rows by a numeric range on a chosen field and produces a date-by-category pivot table, returning two analytical reports on up to 200 supplied rows.","exampleAgentPrompt":"I have 150 partnership pipeline records with company groups and dates — can you filter them where qualified_partners is between 5 and 50, and also pivot the data by date and company category? The rows include fields like row_id, company_group, date, active_partners, and qualified_partners.","exampleUseCases":[{"title":"Qualify active partner threshold analysis","prompt":"Here are our partnership pipeline records for Q4 — filter them to only show rows where active_partners falls between 2 and 20, and also give me a pivot of active_partners by date and company group so I can see which groups are most active each day."},{"title":"Qualified partner range segmentation","prompt":"I've got 80 rows of partnership data with company groups and dates. Can you filter for qualified_partners between 15 and 75 and then pivot the qualified_partners values by date and category so I can spot trends across groups?"},{"title":"Monthly partnership pipeline review","prompt":"Run two reports on my partnership pipeline data: first, filter the qualified_partners field to only include rows with values from 0 to 100; second, pivot those records by date and company_group. I'll paste the rows — there are about 120 of them across group-a and group-b."}],"resultDescription":"Returns two analytical reports on the supplied rows: (1) a numeric interval-filtered subset of rows where the chosen field (qualified_partners or active_partners) falls within the specified minimum–maximum range, and (2) a pivot table cross-tabulating values by date and company_group category. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Missing required row fields (row_id, date, company_group) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows returns an error or truncated result","minimum greater than maximum yields an empty filtered result set","Null numeric values in the chosen field are excluded from interval filtering","Invalid field enum value (not qualified_partners or active_partners) causes a schema error"],"whenToPreferThis":"Choose this endpoint when you have already collected partnership pipeline records (with qualified_partners and active_partners fields) and need both a numeric range filter and a date-by-category pivot in a single paid call. It is ideal for offline or batch analytical reporting on supplied data rather than live CRM lookups. Prefer it when you need two distinct analytical views — filtered rows plus a cross-tab pivot — delivered together for $0.01 USDC on up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:57.291Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-numeric-interval-filter-date-by-category-pivot-4768cddc"}