Sometimes all you need to do is display overall aggregate numbers. The total count of datapoints for your datatype, for example, or the average score overall. This can be accomplished by performing aggregates on the datatype itself.


The code to generate overall aggregate numbers looks like this:

#display average score

{AVG(DATATYPES.SHOW_DATATYPE.SCORE)}


#display count of datapoints

{COUNT(DATATYPES.SHOW_DATATYPE)}


#display count of datapoints with a non-null percent score

{COUNT(DATATYPES.SHOW_DATATYPE.PERCENT_SCORE)}


#display count of locations with a shop

{COUNT(DATATYPES.SHOW_DATATYPE.CLIENT_10_LEVEL_1_ID)}


#display highest score for shops done in January

{MAX(DATATYPES.SHOW_DATATYPE(FILTER=MONTH_OF_YEAR_ID|eq|1).SCORE)}


Note that this type of data display does not currently support calculations.