Forum Discussion
Avg Tickets on Helpdesk System per year
Hi, I'm building a report to show the average tickets per year logged on the IT helpdesk. The Helpdesk Dataset contains TicketID, Ticket Start Date. I joined this table with a custom Date Table w...
Here is a sample data. There are 168 rows and the avg should be 84.5. I would like to show the avg number of tickets per month and per year
| Ticket # | Entered Date |
| 421680 | 12/05/2022 15:55 |
| 421602 | 12/05/2022 14:32 |
| 420640 | 11/05/2022 10:54 |
| 419686 | 10/05/2022 9:58 |
| 419670 | 10/05/2022 9:47 |
| 418729 | 9/05/2022 9:03 |
| 416882 | 5/05/2022 10:17 |
| 415315 | 3/05/2022 11:26 |
| 412433 | 28/04/2022 10:12 |
| 411614 | 27/04/2022 9:53 |
| 411460 | 27/04/2022 9:26 |
| 410996 | 26/04/2022 15:52 |
| 410697 | 26/04/2022 11:57 |
| 410546 | 26/04/2022 10:04 |
| 410483 | 26/04/2022 9:10 |
| 408480 | 21/04/2022 15:21 |
| 404058 | 13/04/2022 16:52 |
| 403757 | 13/04/2022 10:46 |
| 403654 | 13/04/2022 9:17 |
| 403602 | 13/04/2022 8:38 |
| 402519 | 11/04/2022 15:23 |
| 402243 | 11/04/2022 10:18 |
| 402142 | 11/04/2022 9:00 |
| 400743 | 7/04/2022 14:32 |
| 400149 | 6/04/2022 17:02 |
| 399185 | 5/04/2022 15:22 |
| 398959 | 5/04/2022 11:04 |
| 396278 | 31/03/2022 11:52 |
| 396158 | 31/03/2022 9:13 |
| 393855 | 28/03/2022 10:24 |
| 389431 | 21/03/2022 14:31 |
| 387497 | 17/03/2022 15:32 |
| 387195 | 17/03/2022 10:37 |
| 387137 | 17/03/2022 9:43 |
| 387124 | 17/03/2022 9:30 |
| 386489 | 16/03/2022 11:41 |
| 383123 | 10/03/2022 10:42 |
| 381306 | 7/03/2022 15:30 |
| 373027 | 21/02/2022 12:42 |
| 369823 | 15/02/2022 14:14 |
| 369065 | 14/02/2022 14:42 |
| 368950 | 14/02/2022 12:24 |
| 367363 | 10/02/2022 12:28 |
| 367270 | 10/02/2022 10:56 |
| 366880 | 9/02/2022 16:18 |
| 366817 | 9/02/2022 14:50 |
| 366778 | 9/02/2022 13:42 |
| 366237 | 8/02/2022 17:14 |
| 362439 | 2/02/2022 13:01 |
| 361588 | 1/02/2022 9:11 |
| 360612 | 29/01/2022 17:11 |
| 360394 | 28/01/2022 20:36 |
| 359612 | 27/01/2022 13:13 |
| 358237 | 24/01/2022 16:23 |
| 358160 | 24/01/2022 14:58 |
| 358091 | 24/01/2022 13:39 |
| 357815 | 24/01/2022 8:57 |
| 357255 | 21/01/2022 17:48 |
| 356630 | 20/01/2022 15:30 |
| 356463 | 20/01/2022 11:52 |
| 356321 | 20/01/2022 9:16 |
| 352326 | 13/01/2022 11:29 |
| 351805 | 12/01/2022 14:39 |
| 351333 | 12/01/2022 12:35 |
| 350469 | 11/01/2022 10:27 |
| 343443 | 22/12/2021 15:21 |
| 342066 | 20/12/2021 14:12 |
| 340073 | 16/12/2021 10:19 |
| 339647 | 15/12/2021 16:10 |
| 339580 | 15/12/2021 14:48 |
| 338221 | 13/12/2021 14:50 |
| 334544 | 7/12/2021 9:33 |
| 334128 | 6/12/2021 14:46 |
| 333973 | 6/12/2021 11:50 |
| 331471 | 1/12/2021 15:05 |
| 329853 | 29/11/2021 15:25 |
| 326948 | 23/11/2021 13:49 |
| 326830 | 23/11/2021 11:34 |
| 326262 | 22/11/2021 12:48 |
| 326212 | 22/11/2021 12:01 |
| 323688 | 17/11/2021 9:16 |
| 323201 | 16/11/2021 13:15 |
| 322732 | 15/11/2021 16:07 |
| 321250 | 11/11/2021 15:13 |
| 319285 | 8/11/2021 16:09 |
| 319184 | 8/11/2021 14:14 |
| 316839 | 3/11/2021 15:47 |
| 316458 | 3/11/2021 8:33 |
| 310074 | 21/10/2021 9:21 |
| 309633 | 20/10/2021 14:02 |
| 307968 | 18/10/2021 10:43 |
| 307860 | 18/10/2021 9:51 |
| 306968 | 15/10/2021 12:15 |
| 305734 | 13/10/2021 12:58 |
| 303410 | 8/10/2021 13:53 |
| 303269 | 8/10/2021 9:57 |
| 302973 | 7/10/2021 15:01 |
| 299888 | 1/10/2021 8:42 |
| 297738 | 27/09/2021 15:19 |
| 297570 | 27/09/2021 11:19 |
| 297513 | 27/09/2021 10:12 |
| 297460 | 27/09/2021 9:15 |
| 296628 | 23/09/2021 16:20 |
| 295185 | 21/09/2021 8:38 |
| 294787 | 20/09/2021 10:49 |
| 293635 | 16/09/2021 14:30 |
| 293125 | 15/09/2021 14:48 |
| 290689 | 9/09/2021 11:29 |
| 290578 | 9/09/2021 9:08 |
| 284448 | 26/08/2021 13:09 |
| 283744 | 25/08/2021 10:14 |
| 283138 | 24/08/2021 11:03 |
| 280688 | 18/08/2021 16:45 |
| 275294 | 11/08/2021 17:04 |
| 270167 | 5/08/2021 10:37 |
| 268292 | 2/08/2021 10:06 |
| 268205 | 2/08/2021 9:38 |
| 262140 | 20/07/2021 9:41 |
| 261462 | 19/07/2021 10:39 |
| 259870 | 14/07/2021 15:44 |
| 259143 | 13/07/2021 10:28 |
| 258956 | 12/07/2021 19:25 |
| 258795 | 12/07/2021 13:36 |
| 258405 | 11/07/2021 14:15 |
| 257864 | 9/07/2021 9:19 |
| 255828 | 5/07/2021 8:51 |
| 255271 | 2/07/2021 16:01 |
| 254572 | 1/07/2021 15:09 |
| 254486 | 1/07/2021 13:14 |
| 254462 | 1/07/2021 12:33 |
| 248850 | 23/06/2021 12:53 |
| 248653 | 23/06/2021 8:37 |
| 247570 | 21/06/2021 11:18 |
| 247424 | 21/06/2021 9:09 |
| 245944 | 17/06/2021 16:03 |
| 245110 | 16/06/2021 10:13 |
| 245003 | 16/06/2021 7:58 |
| 244744 | 15/06/2021 15:21 |
| 244648 | 15/06/2021 13:07 |
| 242955 | 11/06/2021 10:33 |
| 242481 | 10/06/2021 12:36 |
| 238060 | 2/06/2021 15:19 |
| 237492 | 1/06/2021 16:23 |
| 234013 | 26/05/2021 14:09 |
| 230161 | 20/05/2021 9:11 |
| 229621 | 19/05/2021 12:02 |
| 227243 | 14/05/2021 13:31 |
| 223501 | 10/05/2021 22:36 |
| 217253 | 29/04/2021 13:05 |
| 205853 | 7/04/2021 8:29 |
| 205822 | 7/04/2021 7:32 |
| 202486 | 31/03/2021 9:39 |
| 199582 | 25/03/2021 14:20 |
| 193752 | 15/03/2021 8:17 |
| 189323 | 3/03/2021 15:46 |
| 189304 | 3/03/2021 15:10 |
| 188608 | 2/03/2021 12:47 |
| 186865 | 25/02/2021 9:18 |
| 186456 | 24/02/2021 11:12 |
| 186084 | 23/02/2021 15:49 |
| 185516 | 22/02/2021 11:31 |
| 177507 | 1/02/2021 14:24 |
| 169127 | 8/01/2021 16:19 |
| 169066 | 8/01/2021 12:57 |
| 165138 | 30/12/2020 11:15 |
| 153168 | 2/12/2020 14:38 |
| 153127 | 2/12/2020 13:26 |
| 153115 | 2/12/2020 13:08 |