# Report to show how many scheduled entities someone is assigned to at any given day **URL:** \ **Category:** Get Help\ **Created:** [January 13, 2023, 5:58pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802 "2023-01-13T17:58:45Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Louis-FelixBorealys](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Louis-FelixBorealys](https://community.fibery.io/u/Louis-FelixBorealys)\ **Post date:** [January 13, 2023, 5:58pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802/1 "2023-01-13T17:58:45Z")
Hey everyone, I’ve took a look at the reports doc, but it seems that it’s gonna be very long for me to grasp the concepts and I believe that what I need is something that other people certainly have needed and done in our group. In the screenshot below, I have a team member (3D modeler) which is assigned on 4 entities (circled in red). Some of them happen at the same time. I’ve represented each days they are superposed with the blue numbers at the bottom : ![Timeline Reports example](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/be1923f1c930cbb67160d55e0a8ef6078eb29941.png) What I would like to achieve, is a report with a timeline on the horizontal axis and teams members on the vertical axis that show how many entities someone is assigned for each days on a time line. Something like this, but the problem this one is that only use the start date, not the whole duration of an entities : ![Report example](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b7b21f21600cfe6718539d053442b5d23900fa35.png) Bonus : Showing a number with a heat color instead of just superposed blues. I hope i was clear enough in my explanations. Many thanks! 😃 LF ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 13, 2023, 7:02pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802/2 "2023-01-13T19:02:58Z")
Do the assigned entities use a daterange or a datetimerange? ---
**Author:** ![Louis-FelixBorealys](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Louis-FelixBorealys](https://community.fibery.io/u/Louis-FelixBorealys)\ **Post date:** [January 13, 2023, 7:08pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802/3 "2023-01-13T19:08:26Z")
Yes, but it’s generated with a formula : ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b16f4753c8614db8d22f7326792b950979681329.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 13, 2023, 7:19pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802/4 "2023-01-13T19:19:08Z")
I’d recommend an area chart: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/9a09d9edbbf7ba078a5a64579dd2f12404b30111.png) I’d suggest using this configuration for the x-axis ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2622489e718e53d1baccc88b8fb7f7e5da0b5c19.png) and this for the y-axis ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d1b03f523d27c39a6015f9fce81ebaa2c3fa63cb.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/85fa9a0b19c5f51a05067d91acbcffbb54567fb1.png) Note: I can’t be certain what the field name is for the User, it might be Assignee or whatever ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/5a8e9b59003dc06dec557b6d19de92b289d13180.png) Hopefully, you’ll end up with something like this: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/1781136bcd2cd8dfebf78715529c779ed8a8340c.png) ---
**Author:** ![Louis-FelixBorealys](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Louis-FelixBorealys](https://community.fibery.io/u/Louis-FelixBorealys)\ **Post date:** [January 13, 2023, 8:24pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802/5 "2023-01-13T20:24:56Z")
It worked! Many thanks Chris! 😃 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/19ebcf960899e77fcb410672bd1b18cc8072fabe.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 13, 2023, 8:25pm UTC](https://community.fibery.io/t/report-to-show-how-many-scheduled-entities-someone-is-assigned-to-at-any-given-day/3802/6 "2023-01-13T20:25:37Z")
Great! and you found the colour-coding - I forgot to include that in my example.