Topic: Cross-tab query on hours and days
Kind time of the days, respected ! There was a task to make sampling of basis that it was visible, how much intensively, in what time of days during year go orders. I found an output such: to make cross-tab query, in which lines hours (from 0-23), and in columns day of year (from 1-365). I implemented it is such request:
TRANSFORM Count (public_TS_Orders. ID) AS [Count-ID] SELECT DISTINCT DATEPART ("h", public_TS_Orders. DeliveryTime) as 123 FROM public_TS_Orders GROUP BY public_TS_Orders. DeliveryTime ORDER BY public_TS_Orders. DeliveryTime, public_TS_Orders. DeliveryTime PIVOT DatePart ("y", public_TS_Orders. DeliveryTime);
As a result, on days a scale correct, and here hours, reaching to 23, are started over again from zero. In general, for visualization I put a picture.
Stick please with a nose where I was mistaken. Two days Google I torment... Thanks!