Hi,
I have a Custum Colum that works out 15minute time window. if I use this Colum to break down one of my measures that shows a total number of successful discharges shipments. Which looks like this...
| 13:00:00 | 234 |
| 13:15:00 | 1441 |
| 13:30:00 | 741 |
| 13:45:00 | 752 |
| 14:00:00 | 4242 |
| 14:15:00 | 772 |
| 14:30:00 | 244 |
| 14:45:00 | 2222 |
| 15:00:00 | 444 |
Am not sure how to get this to add each Colum instead of showing totals per the breakdown of 15m, I need the totals to increase and add by the 15m window like this below.
| 13:00:00 | 0 |
| 13:15:00 | 118 |
| 13:30:00 | 737 |
| 13:45:00 | 1491 |
| 14:00:00 | 2330 |
| 14:15:00 | 3122 |
| 14:30:00 | 3906 |
| 14:45:00 | 5013 |
| 15:00:00 | 5988 |
| 15:15:00 | 7485 |
| 15:30:00 | 8873 |
| 15:45:00 | 10171 |
| 16:00:00 | 11601 |
| 16:15:00 | 12997 |
| 16:30:00 | 14495 |
| 16:45:00 | 15782 |
| 17:00:00 | 16958 |
| 17:15:00 | 18193 |
| 17:30:00 | 19433 |
| 17:45:00 | 20873 |
| 18:00:00 | 22486 |
| 18:15:00 | 24076 |
| 18:30:00 | 25257 |
| 18:45:00 | 27029 |
| 19:00:00 | 28422 |
| 19:15:00 | 30151 |
| 19:30:00 | 32943 |
| 19:45:00 | 35743 |
| 20:00:00 | 38538 |
| 20:15:00 | 41514 |
| 20:30:00 | 45017 |
| 20:45:00 | 48832 |
| 21:00:00 | 51744 |
| 21:15:00 | 54054 |
| 21:30:00 | 57370 |
| 21:45:00 | 60516 |
| 22:00:00 | 62417 |
| 22:15:00 | 65542 |
| 22:30:00 | 69334 |
| 22:45:00 | 73194 |
| 23:00:00 | 77062 |
| 23:15:00 | 80707 |
| 23:30:00 | 84414 |
| 23:45:00 | 88218 |
| 00:00:00 | 91733 |
| 00:15:00 | 95459 |
| 00:30:00 | 98769 |
| 00:45:00 | 101533 |
| 01:00:00 | 104706 |
| 01:15:00 | 107461 |
| 01:30:00 | 110317 |
| 01:45:00 | 113420 |
| 02:00:00 | 116661 |
| 02:15:00 | 119153 |
| 02:30:00 | 120695 |
| 02:45:00 | 122326 |
| 03:00:00 | 123863 |
| 03:15:00 | 124767 |
| 03:30:00 | 126427 |
| 03:45:00 | 128345 |
| 04:00:00 | 129667 |
| 04:15:00 | 130057 |
| 04:30:00 | 130658 |
| 04:45:00 | 131257 |
| 05:00:00 | 131931 |
| 05:15:00 | 132125 |
| 05:30:00 | 132160 |
| 05:45:00 | 132160 |
| 06:00:00 | 132160 |
| 06:15:00 | 132160 |
I use this measure to drill down my total shipments:
CoyTotal = calculate (countrows(ItemTracking), search("R***C-Normal*", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("LD***-Normal", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("SPUD***-Normal*", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("SVC***-Normal", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("R*5*C-MAX_R*", ItemTracking[Merged],, 0)>0
