db.sbe_perf_latest.aggregate([{ $match: { tags: {$ne: "ignore"}, test: {$in: ["Long.Scan.Snapshot.Scan.21.21", "Medium.Scan.Snapshot.Scan.15.15"] }} }, {$project: {signed_percent_change_stable: 1, test: 1, signed_z_score_change_stable: 1, _id: 0}}, {$sort: {signed_percent_change_stable: 1}}]).pretty()
[
{
signed_percent_change_stable: -24.66040878744127,
signed_z_score_change_stable: -3.169921403018614,
test: 'Medium.Scan.Snapshot.Scan.15.15'
},
{
signed_percent_change_stable: -24.211982539751745,
signed_z_score_change_stable: -2.9066299053588978,
test: 'Long.Scan.Snapshot.Scan.21.21'
},
{
signed_percent_change_stable: -20.030570534513117,
signed_z_score_change_stable: -1.6357795683938086,
test: 'Medium.Scan.Snapshot.Scan.15.15'
},
{
signed_percent_change_stable: -18.831185311502324,
signed_z_score_change_stable: -1.6432838109504526,
test: 'Long.Scan.Snapshot.Scan.21.21'
},
{
signed_percent_change_stable: -17.19448683124061,
signed_z_score_change_stable: -2.1648182774504536,
test: 'Long.Scan.Snapshot.Scan.21.21'
},
{
signed_percent_change_stable: -12.60341078706027,
signed_z_score_change_stable: -2.241378239643826,
test: 'Medium.Scan.Snapshot.Scan.15.15'
}
]