On /insights page, we have "Most Booked" and "Least Booked" charts, and they're based on createdAt column.

We can clarify their titles to be "Most Bookings Scheduled" and "Least Bookings Scheduled".

And then we can add new two charts based on "startTime" column. In packages/features/insights/server/trpc-router.ts we have createInsightsBookingService and it can take startTime as dateTarget. This new charts should pass startTime to dateTarget, and it should also add one more condition to check if those bookings were actually completed. (status)

TODOs:

• Renaming the existing two charts
• Adding two new charts
  • new UI components
  • corresponding trpc handlers
  • some modification to the method in InsightsBookingBaseService