Mapping measures to date columns

Date Mapping lets you bind each metric to the correct date column so relative date filters (e.g., Today, Last 30 days, MTD, QTD, “this month”) are evaluated against the right timestamp for that metric. Example: signup metrics use reg_date; sales metrics use order_date. If sales is only current through January but calls are current through February, filtering “this month” on a sales metric correctly lands on January instead of showing blanks.

• Filters reflect each metric’s real-world time context (e.g., signups on reg_date, deliveries on delivery_date)

• Timelines stay “in-bounds”: signup lines/bars honor reg_date; order lines/bars honor order_date—on the same Vizpad—under the same “Last 30 days” or “This month” filter.

Setting up Date Mapping

1. Under Data → Business View → Date Mapping, click on Create New Mapping to align measures to date columns.

2. The following window will be displayed. Under Select measure, select as many measures as you want. Under Date column, select the date field for which you want to map the measures.

1. Click on Add Mapping and the newly created mappings will be added to the table as follows. Each "Measure → Date" mapping will be added as a new row.

1. To edit or delete a mapping, click on the three-dot menu of each mapping. Click on Publish. The mapping will be saved.

2. Navigate to Kaiya, Search or Vizpads. Here, for example, let's navigate to Vizpads and create a chart using the same Business View where the measure → date mappings have been applied.

3. Click on Add filter and the following window will be displayed. Enable the toggles for Date filter and Use Alignment Mapping.

1. Click on the Select Time Period dropdown and choose the required date range. Click on Apply.

1. The date range will be applied to the selected chart/table/tab.