Forum Discussion
Cumulative Heat Map
I'm trying to make a heat map of counting locations visited in racks, but what I need is for the color to be by the cumulative. Example: I have a column about how many times those locations have bee...
This would be the data: Regarding locations and QTY Mov, perform the cumulative and from that cumulative make the logic that I explained above:
| Location | Vin. | QTY Mov. | Zone |
| 104-058-01 | 1 | 41 | 3 Attracted |
| 105-049-01 | 1 | 30 | 3 Attracted |
| 110-039-01 | 1 | 30 | 2 Medium |
| 106-021-01 | 1 | 28 | 1 Forward |
| 104-054-01 | 1 | 24 | 3 Attracted |
| 108-049-01 | 1 | 24 | 3 Attracted |
| 109-007-01 | 1 | 23 | 1 Forward |
| 105-048-01 | 1 | 22 | 3 Attracted |
| 117-053-01 | 1 | 22 | 3 Attracted |
| 104-012-01 | 1 | 21 | 1 Forward |
| 106-049-01 | 1 | 21 | 3 Attracted |
| 110-045-01 | 1 | 21 | 3 Attracted |
| 114-050-01 | 1 | 21 | 3 Attracted |
| 103-041-01 | 1 | 20 | 2 Medium |
| 112-050-01 | 1 | 20 | 3 Attracted |
| 105-063-01 | 1 | 19 | 3 Attracted |
| 104-053-01 | 1 | 18 | 3 Attracted |
| 105-002-01 | 1 | 18 | 1 Forward |
| 105-050-01 | 1 | 18 | 3 Attracted |
| 108-044-01 | 1 | 18 | 3 Attracted |
| 109-002-01 | 1 | 18 | 1 Forward |
| 115-022-01 | 1 | 18 | 1 Forward |
| 116-034-01 | 1 | 18 | 2 Medium |
| 103-023-01 | 1 | 17 | 2 Medium |
| 106-048-01 | 1 | 17 | 3 Attracted |
| 103-022-01 | 1 | 16 | 1 Forward |
| 103-024-01 | 1 | 16 | 2 Medium |
| 104-015-01 | 1 | 16 | 1 Forward |
| 104-019-01 | 1 | 16 | 1 Forward |
| 108-041-01 | 1 | 16 | 2 Medium |
| 109-057-01 | 1 | 16 | 3 Attracted |
| 114-007-01 | 1 | 16 | 1 Forward |
| 114-010-01 | 1 | 16 | 1 Forward |
| 115-006-01 | 1 | 16 | 1 Forward |
| 103-053-01 | 1 | 15 | 3 Attracted |
| 104-051-01 | 1 | 15 | 3 Attracted |
| 105-003-01 | 1 | 15 | 1 Forward |
| 108-022-01 | 1 | 15 | 1 Forward |
| 109-051-01 | 1 | 15 | 3 Attracted |
| 117-041-01 | 1 | 15 | 2 Medium |
| 117-048-01 | 1 | 15 | 3 Attracted |
| 103-018-01 | 1 | 14 | 1 Forward |
| 103-053-04 | 4 | 14 | 3 Attracted |
| 104-013-01 | 1 | 14 | 1 Forward |
| 104-014-01 | 1 | 14 | 1 Forward |
| 105-038-01 | 1 | 14 | 2 Medium |
| 108-024-01 | 1 | 14 | 2 Medium |
| 113-013-01 | 1 | 14 | 1 Forward |
| 114-045-01 | 1 | 14 | 3 Attracted |
Thank you very much, sorry for the delay