Trends

This visualization displays changes over time, helping to identify patterns and forecast future values.

Data Visualization

Enter the following values as required to plot the trend.

Name of Visualization

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

Alias for Metric

Enter the name for each metric, which will appear on your dashboard.

Granularity

You can choose the granularity for plotting the trend graph as either Day or Hour.

Metrics

Select the column name from the dropdown for which you want to get the trend.

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

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.