Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Solved! Go to Solution.
its ok i managed to figure the cold out, but thnak you very much for taking the time to read my post.
@Anonymous ,
"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."
Could you share more details about the logic?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
its ok i managed to figure the cold out, but thnak you very much for taking the time to read my post.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |