-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathMongo.ts
142 lines (119 loc) · 4.53 KB
/
Mongo.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
Mongo
db.callArrivals.find()
db.callArrivals.find().forEach(function(item){
if (typeof(item.event_timestamp) == "string"){
print(item.event_timestamp);
item.event_timestamp = new ISODate(item.event_timestamp);
db.callArrivals.save(item);
}
})
db.callArrivals.find({
event_timestamp: { $lte: new ISODate('2019-12-29') }
});
db.callArrivals.find({
event_timestamp: { $lte: new ISODate('2019-12-01T00:04:00Z') }
});
db.callArrivals.find({
clientId: "testClientOne",
event_timestamp: {
$gt : ISODate("2019-12-01T00:02:00.000+00:00"),
$lt : ISODate("2019-12-01T00:31:00.000+00:00")
}
})
db.callArrivals.find({
"event_timestamp" : {
"$gt" : { "$date" : "2019-12-01T00:02:00Z"},
"$lt" : { "$date" : "2019-12-01T00:31:00Z"}
}
})
db.callArrivals.find({
clientId: "testClientOne",
"event_timestamp" : {
"$gt" : ISODate("2019-12-01T00:02:00Z"),
"$lt" : ISODate("2019-12-01T00:31:00Z")
}
})
"_class" : "com.design.ivrservice.models.CallArrivals"
db.callArrivals.find().forEach(function(item){
item._class = "com.design.ivrservice.models.CallArrivals"
db.callArrivals.save(item);
print(item._class);
})
db.callArrivals.find({
"clientId": "testClientOne",
"event_timestamp": {
"$gt": ISODate("2019-12-01T00:02:00Z"),
"$lt": ISODate("2019-12-01T00:31:00Z")
}
})
db.callArrivals.find().forEach(function(item){
print("["+item.event_timestamp);
item.event_timestamp = new Date(item.event_timestamp);
print("->"+item.event_timestamp);
item._class = "com.design.ivrservice.models.CallArrivals"
print("->"+item._class+"]");
db.callArrivals.save(item);
})
db.callArrivals.aggregate(
{
$match : {
clientId: "testClientOne",
event_timestamp: {
"$gt": ISODate("2019-12-01T00:02:00Z"),
"$lt": ISODate("2019-12-01T00:31:00Z")
}}
},
{
$group : {_id:"$clientId", avgCallsInQueue: {$avg: "$CallsInQueue"}, avgSL: {$avg: "$SL"}, avgAbandon: {$avg: "$Abandon"}, avgQueue: {$avg: "$LongQueueTime"} }
}
);
=TEXT(A1,"yyyy-mm-ddThh:MM:ss")
db.agentSummary.find().forEach(function(item){
print("["+item.event_timestamp);
item.event_timestamp = new Date(item.event_timestamp);
print("->"+item.event_timestamp);
item._class = "com.design.ivrservice.models.AgentSummary"
print("->"+item._class+"]");
db.agentSummary.save(item);
})
db.agentSummary.aggregate(
{
$match : {
clientName: "testClientOne",
event_timestamp: {
"$gt": ISODate("2019-12-01T00:02:00Z"),
"$lt": ISODate("2019-12-01T00:31:00Z")
}}
},
{
$group : {_id:"$clientName", avgAHT: {$avg: "$AHT"}, avgConversion: {$avg: "$Conversion"}, avgCSAT: {$avg: "$CSAT"}, avgAnswered: {$avg: "$Answered"} }
}
);
{"aggregate": "agentSummary", "pipeline": [
{"$match": {"clientName": "testClientOne"}},
{"$match": {"event_timestamp": {"$gte": {"$date": "2019-12-01T00:02:00Z"}, "$lte": {"$date": "2019-12-01T01:02:00Z"}}}},
{"$group": {"_id": "$clientName", "avgAHT": {"$avg": "$AHT"}, "avgConversion": {"$avg": "$Conversion"}, "avgCSAT": {"$avg": "$CSAT"}, "avgAnswered": {"$avg": "$Answered"}}}
db.agentSummary.aggregate(
{
$match : {
clientName: "testClientOne",
event_timestamp: {
"$gt": ISODate("2019-12-01T00:02:00Z"),
"$lt": ISODate("2019-12-01T00:31:00Z")
}}
},
{
$group : { _id:{clientId:"$clientName", agentName: "$AgentName" },
avgAHT: {$avg: "$AHT"},
avgCPH: {$avg: "$CPH"},
avgAnswered: {$avg: "$Answered"},
avgAbandonPerct: {$avg: "$AbandonPerct"},
avgUnvlPer: {$avg: "$UnvlPer"},
avgHoldPerct: {$avg: "$HoldPerct"},
avgAvgACW: {$avg: "$AvgACW"} }
}
);
{ "aggregate" : "__collection__", "pipeline" : [
{ "$match" : { "clientId" : "testClientOne"}},
{ "$match" : { "event_timestamp" : { "$gte" : { "$date" : "2019-12-01T00:02:00Z"}, "$lte" : { "$date" : "2019-12-01T01:02:00Z"}}}},
{ "$group" : { "_id" : { "agentName" : "$agentName", "clientId" : "$clientId"}, "avgCPH" : { "$avg" : "$cph"}, "avgAnswered" : { "$avg" : "$answered"}, "avgAbandonPerct" : { "$avg" : "$abandonPerct"}, "avgUnvlPer" : { "$avg" : "$unvlPerct"}, "avgAHT" : { "$avg" : "$aht"}, "avgHoldPerct" : { "$avg" : "$holdPerct"}, "avgACW" : { "$avg" : "$acw"}}}, { "$project" : { "avgCPH" : 1, "avgAnswered" : 1, "avgAbandonPerct" : 1, "avgUnvlPer" : 1, "avgAHT" : 1, "avgHoldPerct" : 1, "avgACW" : 1, "_id" : 0, "agentName" : "$_id"}}]}