Time Comparison
  • 06 Jul 2022
  • 2 Minutes to read
  • Contributors
  • Dark
    Light

Time Comparison

  • Dark
    Light

Animated Walkthrough

aa_timecomparation


Overview

Time Comparison advanced analytics are used to compare data points from a date on the x-axis with a specified Time Shift.


Time Shift

It compares the same series of data with a time shift. Default options include:

  • 1 day
  • 1 week
  • 28 days
  • 30 days
  • 52 weeks
  • 1 year

Other valid options can be added, to a limit of 10, and invalid options will be ignored.

Calculated Type

Represent the time series using one of the following options:

  • Actual Values: Displays two time series — the value of the x-axis (based on a Metric or Rolling Window) and a dotted time series that represents the real value for the selected time shift.

  • Absolute Difference: Displays one time series that represents the difference between the actual value (Metric or Rolling Window) and the value of shifted time.

  • Percentage Change: Displays one time series that represents the percentile difference between the actual value (Metric or Rolling Window) and the last shift value.

  • Ratio: Shows one time series that represents the difference between actual value (Metric or Rolling Window) and the value of shifted time (i.e., ratio of metric value for period time vs. the time-shifted value).


Actual Values Example

When Actual Values are used, a second dotted line of the same color will be added that represents the actual value of the metrics for the selected time period to the date of the previous time shift.

In this example the time shift period is 10 days, so the dotted line represents the metrics for 10 days ago to the date in the x-axis. For example, on Thursday April 9th the number of new cases reported in the U.S. was 32.4K — 10 days earlier, on March 30th, the cases reported where 20.9K.

Time_Comparison_Actual_Values

Raw Data for Verification

Time_Comparison_Actual_Values_Raw_Data


Absolute Difference Example

Absolute Difference shows the difference between the dates on the x-axis vs. the specified time shift period. In the example below, Monday April 20th has 2.48K cases than April 10th and, in the U.S., there are 9.86 cases less on April 20th compared to April 10th.

Absolute_Difference_Example

Raw Data for Verification

Absolute_Difference_Example_Raw_Data


Percentage Change Example

As the name specifies, this option shows the percentage change in a specified time shift period. For example, in Chile on June 17th there are 464% of new cases reported compared to 10 days ago on June 7th. But, in Russia, there was a decrease in the number of cases by 12.8% between June 17th and June 7th.

Percentage_Change_Example

Raw Data for Verification

Percentage_Change_Example_Raw_Data1


Ratio Example

Ratio Example shows the difference between time periods. For example, in Pakistan on June 10th there were 4x times more new cases reported compared 10 days before on June 2nd.

Ratio_Example

Raw Data for Verification

Ratio_Example_Raw_Data


Was this article helpful?

What's Next