Creating widgets with a date range filter

This guide explains how to create widgets with a date range filter.

Introduction

Filter data in widgets and dashboards to display only the information that you find relevant.

This guide explains how to filter the date range of the data displayed in the widgets. For information on how to create simple widgets with filters, see Creating widgets with filters.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

• Load your collected data into Adverity Data Storage.

• Add data to the widget in Data Explorer.

Adding a date range filter to a widget

To add a date range filter to a widget, follow these steps:

1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Data Explorer.

2. At the top of the page, select the View tab that contains the widget.

3. In the Date Range section, click the drop-down menu on the left.

4. In the drop-down list, select one of the following options:

   Fixed

   Select this option to display data in the widgets for a fixed date range that does not depend on the current date. The current date is the date on which the widgets are viewed.

   After selecting this option, click the date picker on the right and select a date range. To display data for the current date, in the date picker, select the current date as the start and end of the date range.

   Moving end

   Select this option to display data in the widgets from the start date to the current date.

   After selecting this option, click the date picker on the right and select the start date.

   This option does not display future data such as planned values for the campaign.

   Open end

   Select this option to display data in the widgets from the start date to the last date when data is available.

   After selecting this option, click the date picker on the right and select the start date.

   This option displays future data, if available, such as planned values for the campaign.

   Last x days/weeks/months/quarters/years

   Select this option to display data in the widgets for a specific amount of time before the current date.

   After selecting this option, in the field that appears next to the drop-down menu, enter the number of days/weeks/months/quarters/years before the current date for which to display data.

   For example, to display data for the two weeks before the current date, select Last x weeks and enter 2.

   Next week/month/quarter/year

   Select this option to display data in the widgets from the first day to the last day of the week/month/quarter/year after the current week/month/quarter/year if this data is available.

   This week/month/quarter/year

   Select this option to display data in the widgets from the first day of the current week/month/quarter/year to the current date.

   (Optional) After selecting this option, select the Limit until yesterday checkbox on the right to display data until the day before the current date.

   Last week/month/quarter/year

   Select this option to display data in the widgets from the first day to the last day of the week/month/quarter/year before the current week/month/quarter/year.

   All time

   Select this option to display all available data in the widgets, from the first to the last date when data is available. This option is heavy on performance and may increase load times.

As a result, a data range filter has been added to your widget.