Charts and Time Tracking, filtered by Date

Feature requests
, ,
1

Hi,

We would like to visualise the data from a time tracking column, by date logged . We would like two methods:

  1. In a bar chart, date/day from time tracked columnas the X-Axis with the amount of hours on the Y-Axis

E.g. 2 hrs logged on Monday, 3 hrs logged on Tuesday, 5 hours logged on Wednesday

This would should Monday, Tuesday, Wednesday on the X-Axis and the amount of time tracked per day on the vertical Y-Axis

  1. Filtering a chart to show time logged, within the last week, on 3 projects

E.g. We have line items of Project A, B & C and time tracked for each in a column

Bar Chart to show:

  • Project A, B, C on the X-Axis
  • Number of hours logged to each project on the Y-Axis
    Then to advanced filter show only time tracked that was logged in the last 7 days.

Does anyone know if this is possible?

2

I would like to be able to do a general filter similar to this - Time Tracking by Date. A filtered view that is able to be exported for invoicing and billing.

3

Hi,

I’m trying to do something similar, but filtered by tasks: I’d like to create a chart displaying tasks and sub-tasks sorted by time-tracking lenght. It would be great if the monday-devs would include more options regarding graphs and time-tracking in the future.

4

@djb85 @EllieCopperLeaf @Dennis you can do that with the Analytics & Reports add-on by Screenful which allows reporting time tracking data both on top level items and subitems, and filtering the charts based on the time logged.

You can learn more from this guide: Creating charts based on time tracking data - Screenful Guide for monday.com

5

Hi, my team actually created a custom coded solution in this domain. It’s a board view that allows you to choose time tracking columns on multiple boards to pull excel reports from where the time is grouped by person/board. Maybe it’ll help some teams out. It’s a private app and just a prototype for now but you can install it with this link. Let me know if you find it useful.