Aggregates
This visualization summarizes data by categories, showing totals, averages, and other key metrics.
Name of Visualization
Enter the name of your Visualization widget, which will appear on your dashboard.
Aggregate Type
You can choose between grouped and single aggregate. In grouped aggregate, you can view multiple metrics within a single widget.
Aggregates
Enter the following values for each of the metric required.
Alias
Enter the name for each metric, which will appear on your dashboard.
Properties
Select the column name from the dropdown for which you want to get the aggregate.
Expression Builder
Start typing the function you want to use and select it from the suggestions. Then, place the cursor inside the brackets and type the property name you selected in Properties as the function parameter for calculations. The aggregate function will be applied on the output of this expression builder.
The following options are available in the Expression Builder. Ci represents the attributes/properties selected by you
sum()
(attribute)
sum(C1)
sumIf()
(attribute, filter)
sumIf(C1, conditions)
avg()
(attribute)
avg(C1)
avgIf()
(attribute, filter)
avgIf(C1, conditions)
count()
(attribute)
count(C1)
countIf()
(attribute, filter)
countIf(C1, conditions)
uniq()
(attribute)
uniq(C1)
uniqIf()
(attribute, filter)
uniqIf(C1, conditions)
min()
(attribute)
min(C1)
max()
(attribute)
max(C1)
least()
(attribute1, attribute2)
least(C1, C2)
greatest()
(attribute1, attribute2)
greatest(C1, C2)
date_diff()
(return type, attribute1, attribute2)
date_diff('second', C1, C2)
+
Addition
uniq(C1) + uniq(C2)
-
Subtraction
uniq(C1) - uniq(C2)
/
Division
uniq(C1) / uniq(C2)
*
Multiplication
uniq(C1) * uniq(C2)
abs()
Return the absolute value of a number
abs(C1)
toInt8()
Converts a value to an 8-bit integer
toInt8(C1)
toInt16()
Converts a value to an 16-bit integer
toInt16(C1)
toInt32()
Converts a value to an 32-bit integer
toInt32(C1)
toInt64()
Converts a value to an 64-bit integer
toInt64(C1)
toString()
Converts a value to a string
toString(C1)
toTimeStamp()
Converts a value to timestamp
toTimeStamp(C1)
toWeekDay()
Converts a date to the corresponding day of the week
toWeekDay(C1)
toUTCHour()
Converts a time to its UTC Hour
toUTCHour(C1)
toMonth()
Converts a date to its corresponding month
toMonth(C1)
toDate()
Converts a value to a date format
toDate(C1)
Units
Select the unit from the dropdown for your aggregate value to be displayed on the dashboard.
Following unit options are available
Second = sec
Minutes = mins
Hours = hrs
Days = days
Week = week
Thousand = K
Lakh = L
Million = M
Billion = B
Final Transformation
Select whether you want to convert seconds or milliseconds to timestamp format on the dashboard.
Custom Filters
You can filter the data in the final output on the dashboard according to your needs.
Choose whether to include data using the = operator or exclude it using the != operator. You can also use the regex operator and provide the regex formula.
Customize
You can customize the font size and text color for Alias, Value and the Unit displayed on the dashboard.
View Chart
Click on View Chart to preview it before adding it to the dashboard.
Last updated