Calculation anomaly

Hello Team,

Records are loaded in mongodb as per details below:

1. _id
2. :
   1. 5f76dea38c3771266ee0317c
3. time
4. :
   1. "2020-10-01 00:00"
5. rnc
6. :
   1. "MBSC_ROD"
7. v10_cssr_speech_(no_ident_encrypt)(%)
8. :
   1. "100"
9. v10_cdr_speech(%)
10. :
    1. "0"
11. v10_no__of_voice_calls(number)
12. :
    1. "58"
13. v10_no__of_cs_call_drops(number)
14. :
    1. "0"
15. v10_speech_rrc_setup_success_ratio(%)
16. :
    1. "100"
17. v10_speech_rab_setup_success_ratio(%)
18. :
    1. "100"
19. v10_cs_traffic_(erl)
20. :
    1. "1.6801"
21. efd_ps_rab_setup_success_rate(%)
22. :
    1. "99.8202"
23. efd_ps_call_drop_rate(%)(%)
24. :
    1. "0.4754"
25. v10_dl_traffic_(gbytes)
26. :
    1. "8.9251"
27. v10_ul_traffic_(gbytes)
28. :
    1. "0.8561"
29. total_ps_throughput
30. :
    1. "87217.2814"
31. id
32. :
    1. "2020-10-01 00:00MBSC_ROD"
33.  
34. _id
35. :
    1. 5f76dea38c3771266ee0317d
36. time
37. :
    1. "2020-10-01 00:00"
38. rnc
39. :
    1. "RNC_FL"
40. v10_cssr_speech_(no_ident_encrypt)(%)
41. :
    1. "99.9751"
42. v10_cdr_speech(%)
43. :
    1. "0.0234"
44. v10_no__of_voice_calls(number)
45. :
    1. "4190"
46. v10_no__of_cs_call_drops(number)
47. :
    1. "1"
48. v10_speech_rrc_setup_success_ratio(%)
49. :
    1. "99.9751"
50. v10_speech_rab_setup_success_ratio(%)
51. :
    1. "100"
52. v10_cs_traffic_(erl)
53. :
    1. "173.5029"
54. efd_ps_rab_setup_success_rate(%)
55. :
    1. "99.8672"
56. efd_ps_call_drop_rate(%)(%)
57. :
    1. "0.0589"
58. v10_dl_traffic_(gbytes)
59. :
    1. "74.2592"
60. v10_ul_traffic_(gbytes)
61. :
    1. "6.8139"
62. total_ps_throughput
63. :
    1. "363001.5898"
64. id
65. :
    1. "2020-10-01 00:00RNC_FL"
66.  
67. _id
68. :
    1. 5f76dea38c3771266ee0317e
69. time
70. :
    1. "2020-10-01 00:00"
71. rnc
72. :
    1. "RNC_PL"
73. v10_cssr_speech_(no_ident_encrypt)(%)
74. :
    1. "99.9216"
75. v10_cdr_speech(%)
76. :
    1. "0.1479"
77. v10_no__of_voice_calls(number)
78. :
    1. "3945"
79. v10_no__of_cs_call_drops(number)
80. :
    1. "6"
81. v10_speech_rrc_setup_success_ratio(%)
82. :
    1. "99.9723"
83. v10_speech_rab_setup_success_ratio(%)
84. :
    1. "99.9493"
85. v10_cs_traffic_(erl)
86. :
    1. "179.7597"
87. efd_ps_rab_setup_success_rate(%)
88. :
    1. "99.9242"
89. efd_ps_call_drop_rate(%)(%)
90. :
    1. "0.0495"
91. v10_dl_traffic_(gbytes)
92. :
    1. "87.3757"
93. v10_ul_traffic_(gbytes)
94. :
    1. "8.6842"
95. total_ps_throughput
96. :
    1. "430241.8535"
97. id
98. :
    1. "2020-10-01 00:00RNC_PL"
99.  
100. _id
101. :
     1. 5f76dea38c3771266ee0317f
102. time
103. :
     1. "2020-10-01 00:15"
104. rnc
105. :
     1. "MBSC_ROD"
106. v10_cssr_speech_(no_ident_encrypt)(%)
107. :
     1. "100"
108. v10_cdr_speech(%)
109. :
     1. "0"
110. v10_no__of_voice_calls(number)
111. :
     1. "77"
112. v10_no__of_cs_call_drops(number)
113. :
     1. "0"
114. v10_speech_rrc_setup_success_ratio(%)
115. :
     1. "100"
116. v10_speech_rab_setup_success_ratio(%)
117. :
     1. "100"
118. v10_cs_traffic_(erl)
119. :
     1. "0.9053"
120. efd_ps_rab_setup_success_rate(%)
121. :
     1. "99.725

.....

We will require to do a summation of v10_no__of_voice_calls(number) for each time based on RNCs. For example, 00:00, there are 3 RNCs. So, on Tableau, we will require the sum of 'v10_no__of_voice_calls(number)' for each RNCs at 00:00. For each time calculation will be like this.

Kindly advise.

Regards,

Roshan