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) |
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 colors and add units to both the axes.
Following unit options are available
Second=sec
Minutes=mins
Hours=hrs
Days=days
Week=week
View Chart
Click on View Chart to preview it before adding it to the dashboard.
Last updated