Today we’re releasing a new version of the Cloud report builder.
It features a completely new UI design and approach to building reports that should make it easier for new people to create reports. At the same time, the new code editor provides more capabilities than the previous one so if you have MongoDB knowledge (or some googling) you can create more advanced reports.
Here is a list with all the supported operations in the custom code box:
List of supported operations (5 July 2021)
$addFields
$count
$group
$limit
$match
$project
$set
$sort
$sortByCount
$unset
$abs
$add
$allElementsTrue
$and
$anyElementTrue
$arrayElemAt
$avg
$ceil
$cmp
$concat
$cond
$convert
$dateFromParts
$dateToParts
$dateFromString
$dayOfMonth
$dayOfWeek
$dayOfYear
$divide
$eq
$exists
$expr
$first
$floor
$gt
$gte
$hour
$ifNull
$in
$indexOfCP
$isArray
$isNumber
$isoDayOfWeek
$isoWeek
$isoWeekYear
$last
$lt
$lte
$ltrim
$max
$min
$millisecond
$minute
$mod
$month
$multiply
$ne
$nin
$not
$or
$pow
$replaceOne
$replaceAll
$round
$rtrim
$second
$split
$sqrt
$strcasecmp
$strLenCP
$substr
$substrCP
$subtract
$sum
$switch
$toBool
$toDate
$toDecimal
$toDouble
$toInt
$toLong
$toString
$toLower
$toUpper
$trim
$trunc
$week
$year
We’ve created a full blog detailing all the changes: