{"uid":"cap_02zxxoxwpgaIB7D7p1phh","slug":"dataset-storage-analytics-date-by-category-pivot-keyed-dataset-a523ae2f","name":"Dataset Storage Analytics: Date-by-Category Pivot + Keyed Dataset Comparison","description":"Dataset storage — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison for supplied dataset storage records (used_mb, row_count). 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-18-188?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","used_mb","row_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"used_mb":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","used_mb":10,"row_count":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","used_mb":20,"row_count":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","used_mb":15,"row_count":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","used_mb":30,"row_count":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["used_mb","row_count"],"type":"string","default":"used_mb"},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","used_mb","row_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"used_mb":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","used_mb":10,"row_count":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","used_mb":21,"row_count":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","used_mb":17,"row_count":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","used_mb":33,"row_count":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":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_efxsqyVNO0Fpkix2-EklP","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":"Runs two analytical reports on supplied dataset storage records: a date-by-category pivot table and a keyed comparison between two datasets, for up to 200 rows each.","exampleAgentPrompt":"I have two versions of my storage dataset — each with row_id, dataset_group, date, used_mb, and row_count fields, up to 200 rows each — can you pivot the first one by date and category for used_mb, and compare the two datasets keyed by row_id?","exampleUseCases":[{"title":"Monthly storage growth pivot by team","prompt":"I've got storage records for each team (dataset_group) with daily used_mb readings across October — can you pivot them by date and team so I can see which groups are consuming the most space day by day?"},{"title":"Before-and-after migration comparison","prompt":"I ran a data migration last week and have two snapshots of our dataset storage records — same row_ids but different used_mb values. Can you compare them keyed by row_id so I can see exactly what changed?"},{"title":"Row count trend analysis by category","prompt":"I have 150 rows of dataset storage logs with date, dataset_group, and row_count. Can you pivot row_count by date and dataset_group to show me how each category's record count has grown over time?"}],"resultDescription":"Returns two independent analytical reports: (1) a date-by-category pivot table showing the selected metric (used_mb or row_count) aggregated across dates and dataset groups, and (2) a keyed comparison report showing differences between two supplied datasets matched by row_id, both computed locally from the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, dataset_group, date, used_mb, row_count) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows in either dataset array returns an error","Null numeric values may affect aggregation totals in pivot and comparison outputs","Empty rows array (minItems: 1 violated) returns a validation error"],"whenToPreferThis":"Choose this endpoint when you need both a date-by-category pivot table AND a keyed comparison between two storage datasets in a single $0.01 call, using only your own supplied data (no external data fetched). Ideal for storage analytics workflows where you already have the records and need fast, local computation without prediction or professional assessment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:44:32.068Z","isFirstParty":false,"canonicalSlug":"dataset-storage-analytics-date-by-category-pivot-keyed-dataset-a523ae2f"}