Frequency

This visualization is used to visualize how often each category occur, highlighting patterns and anomalies in the dataset.

Name of Visualization

Enter the name of your Visualization widget, which will appear on your dashboard.

X-Axis Property

Select your preferred column name from the dropdown. The data from this column will populate the x-axis values to create a frequency visualization.

Alias for X-Axis

Enter the alias you want to display for the X-axis on the visualization graph.

Y-Axis Property

Click on the + icon next to Y-Axis Properties to add properties for calculating values on the Y-axis. You can add more than one property here.

Alias for Y-Axis

Enter the alias you want to display for the Y-axis on the visualization graph.

Expression Builder

You can write an expression here to calculate the value for Y-Axis.

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 Y-Axis Properties as the function attribute for calculations.

The following options are available in the Expression Builder. Ci represents the attributes/properties selected by you

Function	Attribute Structure	Usage
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)

Function

Attribute Structure

Usage

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)

Operator	Action	Example Usage
+	Addition	uniq(C1) + uniq(C2)
-	Subtraction	uniq(C1) - uniq(C2)
/	Division	uniq(C1) / uniq(C2)
*	Multiplication	uniq(C1) * uniq(C2)

Function	Description	Usage
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)

Function

Description

Usage

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)

Function	Description	Usage
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)

Function

Description

Usage

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)

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.