Apxor
IntegrationProduct Guides
  • Introduction to Apxor
  • Getting Started with Apxor
    • Adding a New App
    • Firebase Credentials (optional)
    • SDK
      • Android (x)
      • iOS SDK
      • iOS SDK (Swift UI)
      • iOS SDK (Manual)
      • Web npm based
        • Tracking Events and Pages for Web
      • Web URL based
        • Tracking Events and Pages for Web
      • React Native
      • Cordova
      • Flutter
      • Jetpack Compose
    • API Guides
      • iOS
      • Web
      • React Native
      • Cordova
      • Flutter
    • Release Notes
    • Performance
    • Troubleshooting
  • Product Guides
    • Integration Checklist
    • Create a Campaign
      • Mobile
        • Target
        • Trigger
        • Schedule and Limit
        • Review and Test
        • Set Priority and Publish
        • A/B Testing
        • Campaign Listings Page
        • Campaign Analytics
        • Campaign Designs
          • Tooltips
          • In-App Messages
          • Coachmarks
          • Badges
      • Web
        • Target
        • Trigger
        • Schedule and Limit
        • Review and Test
        • Set Priority and Publish
        • A/B Testing
        • Campaign Listings Page
        • Campaign Analytics
        • Web Templates
    • Create a Survey
      • Legacy
        • Target
        • Trigger
        • Schedule and Limit
        • Review and Test
        • Publish
        • Survey Listings Page
        • Survey Analytics
        • Survey Designs
          • Request for Survey
          • Single Response
          • Multi Response
          • Rating
          • Short Answer
          • Success Message
      • Latest
        • Survey Stop Conditions
        • Target
        • Trigger
        • Schedule and Limit
        • Review and Test
        • Publish
        • Survey Listings Page
    • Custom Reports
    • Analytics
      • Custom Dashboards
      • Uninstalls
      • Retention
      • Funnels
      • Paths
      • Event Analysis
    • BI Dashboard
      • Frequency
      • Aggregates
      • Trends
      • Pie Chart/Advanced Pie Chart
      • Table
    • Insights
      • Activation Analysis
      • Correlation Analysis
    • Adding a Test Device
    • Preview vs. Test vs. Publish
    • Dynamic Script
  • Partner Integrations
    • Mixpanel
    • MoEngage
    • Amplitude
    • CleverTap
  • Glossary of Terms
  • Video Gallery
  • Beta Features
    • Create Embedded Cards Campaign
    • Create Stories Campaign
Powered by GitBook
On this page
  • Data Visualization
  • Name of Visualization
  • Alias for Metric
  • Granularity
  • Metrics
  • Expression Builder
  • Custom Filters
  • Customize
  • View Chart
  1. Product Guides
  2. BI Dashboard

Trends

PreviousAggregatesNextPie Chart/Advanced Pie Chart

Last updated 10 months ago

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)

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

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.

Customize

Color: You can customize the color for the graph.

Graph Type: You can select between area and line graph.

Font Size: You can customize the font size for Value and Unit.

Font Color: You can customize the font color for Value and Unit.

Trend value type: You can select one of the following trend value types.

  1. Average

  2. Median

  3. Min

  4. Max

  5. Sum

Dimension Units:

Select the unit from the dropdown 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

View Chart

Click on View Chart to preview it before adding it to the dashboard.