A common issue that creators of dashboards often times struggle with, is getting the time filters on the report to update automatically as new data comes in. One Model has solved this issue by providing Time Models and recommends for any queries/ dashboards that are saved and will be used again that users use the Time Models. 

Time Models are located within the specific time dimensions available on the site. They will display correctly for either Calendar Year or Fiscal Year periods.

Time Models for One Model are available at the Yearly, Quarterly, Monthly, Weekly and Daily level. Time Models are used in combination with Time Functions at the Metrics Level to create robust methods of exploring data across time. 

Below are a list of common Time Models and how they work for a cumulative measure or a point in time measure. The examples all assume a date of September 12, 2017.

Yearly Time Models

This Year – This shows the current year. 

Unless the measure that you are using has a time function applied to it, this will be a partial year of data for cumulative metrics. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Last Year – This shows last year. 

Unless the measure that you are using has a time function applied to it, this will be a full year of data for the cumulative metrics. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Last Four Years – This shows the current year and the prior 3 years. 

Unless the measure that you are using has a time function applied to it, this will be a full year of data for last 3 years and partial year of data for the current year. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Quarterly Time Models

This Quarter – This shows the current quarter. 

Unless the measure that you are using has a time function applied to it, this will be a partial quarter of data for cumulative metrics. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists, which is September 12, 2017.

Last Four Quarters – This shows the current quarter and the prior 3 quarters. 

Unless the measure that you are using has a time function applied to it, this will be a full quarter of data for the last 3 quarters and partial quarter of data for the current quarter. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Monthly Time Models

This Month - This shows the current month. 

Unless the measure that you are using has a time function applied to it, this will be a partial month of data for cumulative metrics. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Last Month - This shows last month.

Unless the measure that you are using has a time function applied to it, this will be a full month of data for the cumulative metrics. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Last 12 Months - This shows the current month and the prior 12 months.

Unless the measure that you are using has a time function applied to it, this will be a full month of data for the last 11 quarters and partial month of data for the current month. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Last 12 Months - Last Year - This shows the 12 months for last year. This can be used as comparison for this years’ data.

Unless the measure that you are using has a time function applied to it, this will be a full month of data for these 12 historical months. For example, if today is currently September 12, 2017 and using a Calendar Year time period, Terminations (Total) would show the cumulative terminations:

For point in time metrics, it will show the data as of either the beginning or start of a period. For example, the EOP Headcount measure will show the data as of the last date data exists:

Did this answer your question?