Skip to content

Home Metric Query Logic

This document explains the query logic for metric cards in the My Favorites section on the Home page. It covers how non-derived metrics and derived metrics, including share and ranking analyses, are processed and displayed.

Non-Derived Metrics

  • Chart type: area chart

  • Base metrics: show the trend for the last 7 days, using yesterday as the reference date

  • Derived metrics:

    • No time limit: show the trend for the last 7 days, using yesterday as the reference date

    • With a time limit:

      • Seconds or minutes: show the latest 30 units

      • Hours: show the latest 12 units

      • Days: show the last 7 days, using yesterday as the reference date

      • Weeks: show the last 7 weeks

      • Months: show the last 6 months

      • Years: show the last 3 years

  • Mixed cases: if the system cannot identify the case, it shows the trend for the last 7 days by default

Derived Metrics

Share Analysis

  • Chart type: pie chart

  • Derived metrics:

    • Single time-value filter:

      • No time limit: use yesterday's data

      • With a time limit: use the value from the previous time granularity, such as the previous month for monthly granularity

    • Share scope:

      • Randomly select a dimension-value combination for filtering, excluding null values

      • If no value is selected, no filter is applied

    • Share dimension:

      • Group by the share dimension

      • If it is empty, randomly select a dimension for grouping. The metric date and share scope dimensions cannot be selected.

    • Sorting: sort share dimension values by metric value in descending order and select the first result

Ranking Analysis

  • Chart type: bar chart

  • Derived metrics:

    • Single time-value filter:

      • No time limit: use yesterday's data

      • With a time limit: use the value from the previous time granularity, such as the previous month for monthly granularity

    • Ranking scope:

      • Randomly select a dimension-value combination for filtering, excluding null values

      • If no value is selected, no filter is applied

    • Ranking dimension:

      • Group by the ranking dimension

      • If it is empty, randomly select a dimension for grouping. The metric date and ranking scope dimensions cannot be selected.

    • Sorting: sort ranking dimension values by metric value in ascending order and select the first result