{"uid":"cap_IEHRE0DJzKOwSHeXJXnYO","slug":"equipment-runtime-date-by-category-pivot-e12b32e1","name":"Equipment Runtime Date-by-Category Pivot","description":"Equipment runtime - Date by category pivot: Date by category pivot for Equipment runtime. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded date by category pivot deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-equipment-runtime-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","machine","date","run_hours","downtime_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"machine":{"type":"string","default":"","maxLength":80},"run_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"downtime_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","machine":"group-a","run_hours":10,"downtime_hours":1},{"date":"2026-10-02","row_id":"row-2","machine":"group-b","run_hours":20,"downtime_hours":2},{"date":"2026-10-03","row_id":"row-3","machine":"group-a","run_hours":15,"downtime_hours":3},{"date":"2026-10-04","row_id":"row-4","machine":"group-b","run_hours":30,"downtime_hours":4}],"maxItems":200,"minItems":1},"field":{"enum":["run_hours","downtime_hours"],"type":"string","default":"run_hours"}}},"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_L47XCENvFQ5sRexKjhQ9S","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":"Pivots equipment runtime and downtime hours data by date and machine category, returning a summary table of up to 200 records.","exampleAgentPrompt":"Pivot my equipment runtime data by date and machine category — I have 4 rows: row-1 machine group-a on 2026-10-01 with 10 run hours and 1 downtime hour, row-2 group-b on 2026-10-02 with 20 run hours and 2 downtime hours, row-3 group-a on 2026-10-03 with 15 run hours and 3 downtime hours, row-4 group-b on 2026-10-04 with 30 run hours and 4 downtime hours — and use run_hours as the pivot field.","exampleUseCases":[{"title":"Daily runtime comparison across machine groups","prompt":"I have a week's worth of equipment logs for two machine groups, Alpha and Beta — can you pivot the run_hours by date and machine category so I can see side-by-side how many hours each group ran each day? Here are the rows: row-1 Alpha 2026-11-01 8h run 0.5h down, row-2 Beta 2026-11-01 12h run 1h down, row-3 Alpha 2026-11-02 9h run 0h down, row-4 Beta 2026-11-02 11h run 2h down."},{"title":"Downtime hotspot analysis by category","prompt":"Can you pivot our equipment downtime_hours by date and machine category? I want to see which groups had the most downtime on which days. I'll give you 6 records: row-1 Press-A 2026-10-10 6h run 2h down, row-2 Press-B 2026-10-10 8h run 0.5h down, row-3 Press-A 2026-10-11 4h run 4h down, row-4 Press-B 2026-10-11 7h run 1h down, row-5 Press-A 2026-10-12 5h run 3h down, row-6 Press-B 2026-10-12 9h run 0h down."},{"title":"Monthly utilization summary for maintenance planning","prompt":"Please create a date-by-category pivot on run_hours for our three machine lines — Line-1, Line-2, Line-3 — across these 9 daily records for October: row-1 Line-1 2026-10-01 10h run 0h down, row-2 Line-2 2026-10-01 14h run 1h down, row-3 Line-3 2026-10-01 6h run 3h down, row-4 Line-1 2026-10-02 11h run 0.5h down, row-5 Line-2 2026-10-02 13h run 0h down, row-6 Line-3 2026-10-02 5h run 4h down, row-7 Line-1 2026-10-03 9h run 1h down, row-8 Line-2 2026-10-03 15h run 0h down, row-9 Line-3 2026-10-03 7h run 2h down."}],"resultDescription":"Returns a date-by-category pivot table where rows represent dates and columns represent machine categories, with cells containing the aggregated value (run_hours or downtime_hours) for each date-category combination, computed locally from the supplied records without external enrichment.","failureModes":["Missing required fields (row_id, machine, date, run_hours, downtime_hours) causes validation error","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows supplied triggers a max-items validation error","Empty rows array (minItems:1 violated) returns an error","Invalid field enum value (not run_hours or downtime_hours) returns a schema error","Null numeric values are accepted but may result in blank pivot cells"],"whenToPreferThis":"Choose this endpoint when you have raw equipment operational records (up to 200 rows) and need a structured pivot table grouped by date and machine category for either run hours or downtime hours. It is ideal for quick local aggregation without needing an external analytics platform or BI tool. It is not suitable for time-series forecasting, anomaly detection, or datasets exceeding 200 records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:04:38.204Z","isFirstParty":false,"canonicalSlug":"equipment-runtime-date-by-category-pivot-e12b32e1"}