Period Analysis#

Period Analysis helps you compare metrics across different time intervals to identify trends and changes in performance over time. You can configure comparisons by using period-over-period and by choosing a frequency that fits your analysis needs.

Follow the steps below to run a Period Analysis Query:

Step 1: Navigate to the Explorer page and click on the Period Analysis option available in the query panel.

../../../../_images/Period_Analysis.png

Period Analysis#

Step 2: Choose the analysis period by selecting either Period over Period or choose from Frequent Template.

Period-Over-Period comparison options such as Month-over-Month (MoM), Year-over-Year (YoY), Week-over-Week (WoW), or Quarter-over-Quarter (QoQ).

../../../../_images/Period_Over_Period.png

Period Over Period#

After selecting the Period-over-Period comparison, users can enable Growth Percentage, by enabling the Toggle, to view the percentage change between the selected periods. Automatically calculate the growth or decline of the selected metric, helping you quickly understand performance trends without manual calculations.

../../../../_images/Period_Over_Period_Growth.png

Growth Percentage#

Use a Frequent Template, which includes commonly used time comparisons.

../../../../_images/Period_Template.png

Choose Template#

A Customized Template enables users to define reporting periods by either selecting a specific start and end date or choosing from predefined options.

../../../../_images/Period_customize.png

Customize Template#

Additionally, it supports comparative analysis through a Period 1 vs Period 2 format. There is no limit to the number of periods that can be configured—users can compare multiple timeframes for in-depth trend evaluation. This mode also supports comparing multiple dimensions across multiple periods, making it ideal for advanced, customized reporting needs.

../../../../_images/Period_custom.png

Custom Period#

../../../../_images/Period_vs.png

Period Comparison#

Step 3: To configure a Period Analysis, select exactly One Date field and At Least One Metric. There is no restriction on Dimensions - you may select as many as needed.

../../../../_images/Period_Columns.png

Choose Columns#

NOTE
The Run button remains disabled until both a Date and at least one Metric are selected. Only one date can be selected — choosing a new one will replace the existing selection.

Step 4: Aggregation is supported for the selected Metric and Dimension column. For metrics, aggregations include Sum and Average while, Dimension supports Count; additional aggregation options will be added in a future release. Filtering is supported for Date columns, allowing you to narrow down data based on specific time ranges.

../../../../_images/Period_Aggregation.png

Aggregation#

Step 5: Once the fields are selected, click Run to execute the query and view the analysis results.

../../../../_images/Period_Run.png

Run Button#

Restrictions in Explorer

There are certain limitations to be aware of:

  • External Sharing is Restricted: To preserve data security and context, chat-based queries stay within the platform.

  • Smart Columns Limitation: Smart Columns are not currently applied within Athena Threads. However, upcoming improvements will begin enabling them — with single-table queries only — allowing for more contextual insights while keeping performance optimized.