| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
{
"utilities": [
{
"_id": "594376d9f59a7c6d1cb00e18",
"name": "Server CLI Request",
"tags": {
"value": 1497509263823,
"label": "aaron",
"action": "Start",
"category": "Videos"
},
"date": "2017-06-16T06:12:41.402Z",
"__v": 0
},
{
"_id": "594376d9f59a7c6d1cb00e19",
"name": "Server CLI Request",
"tags": {
"value": 1497509350209,
"label": "kynan",
"action": "Stop",
"category": "Videos"
},
"date": "2017-06-16T06:12:41.402Z",
"__v": 0
},
{
"_id": "59437648f59a7c6d1cb00e12",
"name": "Server CLI Request",
"tags": {
"value": 1497509263823,
"label": "aaron",
"action": "Start",
"category": "Videos"
},
"date": "2017-06-16T06:10:15.991Z",
"__v": 0
},
{
"_id": "59437648f59a7c6d1cb00e13",
"name": "Server CLI Request",
"tags": {
"value": 1497509350209,
"label": "kynan",
"action": "Stop",
"category": "Videos"
},
"date": "2017-06-16T06:10:15.991Z",
"__v": 0
},
{
"_id": "59437348f59a7c6d1cb00e01",
"name": "Server CLI Request",
"tags": {
"value": 1497592616045,
"label": "HowTo",
"action": "Start",
"category": "Videos"
},
"date": "2017-06-16T05:57:28.370Z",
"__v": 0
},
{
"_id": "594372b4f59a7c6d1cb00dfd",
"name": "Server CLI Request",
"tags": {
"value": 1497592500120,
"label": "HowTo",
"action": "Start",
"category": "Videos"
},
"date": "2017-06-16T05:55:00.120Z",
"__v": 0
}
]
} |
Requests By Tag Name in Last X Weeks
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[
{
"$match":{
"tags.category":"#category#",
"tags.action": "#action#",
"date":{
"$gte":"#gte#",
"$lte":"#lte#"
}
}
},
{
"$project":{
"action":"$tags.action"
}
},
{
"$group":{
"_id":"$action",
"count":{
"$sum":1
}
}
}
] |
Click the image to increase the size.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
{
"utilities": [
{
"_id": "Start",
"count": 4
}
]
} |
Actions in Specific Category
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
[
{
"$match": {
"tags.request.answerSpace.name": "#answerspace#",
"tags.request.answerSpace.form": {
"$exists": true
},
"date": {
"$gte": "#gte#",
"$lte": "#lte#"
}
}
},
{
"$project": {
"form": "$tags.request.answerSpace.form"
}
},
{
"$group": {
"_id": "$form",
"count": {
"$sum": 1
}
}
}
]
|
Click the image to increase the size.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
{
"utilities": [
{
"_id": "Stop",
"count": 2
},
{
"_id": "Start",
"count": 4
}
]
}
|