{"uid":"cap_T32ZUIAeTZqFvl30FVh1a","slug":"time-entries-date-by-category-pivot-5e0b0686","name":"Time Entries Date-by-Category Pivot","description":"Time entries - Date by category pivot: Date by category pivot for Time entries. 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-time-entries-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","project","date","hours","billable_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"project":{"type":"string","default":"","maxLength":80},"billable_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","hours":10,"row_id":"row-1","project":"group-a","billable_hours":1},{"date":"2026-10-02","hours":20,"row_id":"row-2","project":"group-b","billable_hours":2},{"date":"2026-10-03","hours":15,"row_id":"row-3","project":"group-a","billable_hours":3},{"date":"2026-10-04","hours":30,"row_id":"row-4","project":"group-b","billable_hours":4}],"maxItems":200,"minItems":1},"field":{"enum":["hours","billable_hours"],"type":"string","default":"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_R228gPRiyKr2uBauPsw5v","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":"Generates a date-by-category pivot table for time entry records, aggregating hours or billable hours by project across dates.","exampleAgentPrompt":"Can you pivot my time entries by date and project, using hours as the value field? Here are the rows: row-1 on 2026-10-01 for group-a was 10 hours with 1 billable, row-2 on 2026-10-02 for group-b was 20 hours with 2 billable, row-3 on 2026-10-03 for group-a was 15 hours with 3 billable.","exampleUseCases":[{"title":"Weekly project hours cross-tab","prompt":"I have a week's worth of time entries across three projects — can you pivot them by date and project so I can see how many hours were logged per project each day? Use total hours as the value field."},{"title":"Billable hours breakdown by client","prompt":"Take these 50 time log rows for October and generate a pivot showing billable hours grouped by project and date, so I can see which client categories racked up the most billable time on which days."},{"title":"Monthly timesheet audit pivot","prompt":"I need a date-by-project pivot of my team's time entries for the whole month — up to 200 rows — using the hours field, so I can spot gaps or spikes in any project's logged time across the calendar."}],"resultDescription":"A pivot table (matrix) where rows represent dates and columns represent project categories, with cells containing the aggregated value (hours or billable_hours) for each date-project combination, derived from up to 200 input time entry records.","failureModes":["Missing required fields (row_id, project, date, hours, billable_hours) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted returns an error","Invalid field enum value (not 'hours' or 'billable_hours') causes a bad request","Empty rows array is rejected","Payment failure or insufficient USDC balance prevents processing"],"whenToPreferThis":"Choose this endpoint when you need a structured date-by-project pivot of time entry records locally computed without external enrichment, especially when you have up to 200 rows of time tracking data and need a quick, inexpensive ($0.01 USDC) cross-tabulation of hours or billable hours by project and date.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:47:50.053Z","isFirstParty":false,"canonicalSlug":"time-entries-date-by-category-pivot-5e0b0686"}