DMA daily, monthly, and yearly KPIs
The Daily KPI, Monthly KPI, and Yearly KPI panels consists of three separate tables that display daily, monthly, and yearly data for the DMA selected from the List of DMAs table (DMA ID column) on a Region page (see List of DMAs). These KPIs provide the same information as the List of DMAs table on the Region page but are specific to the selected DMA.
Note: Each of these panels initially appears collapsed. Click the expand icon () to view the table in each panel.
Tip: To expand the panel for a larger display, click the maximize icon (). To restore the panel to its original size, click the minimize icon (
).
Each KPI table supports the following options:
-
Hover over any cell to reveal a tooltip with the complete text if the field is truncated due to width constraints.
-
To select a specific data, click the calendar icon (
) in the Date column and make your selection from the date picker. Use the filter function (
) to refine the date selection or to define a date range with the Between operator, and then click Apply.
-
To reorder the columns, drag a column header to the desired location in the table. The Date column cannot be reordered.
-
To adjust the width of any column, hover over the edge of the column header and drag the edge as needed.
-
To change the sort order, click any column header to sort by that attribute. An up arrow appears in the column header, indicating that the sort is in ascending order. Click the column header again to switch to descending order, indicated by a down arrow.
Note: Alternatively, you can click the menu icon (
) in any column header and select Sort Ascending or Sort Descending.
-
To hide any columns from the table, click the menu icon (
) in a column header and select Choose Columns. Deselect the check boxes for the columns to remove from view.
Tip: To quickly locate a column name, type all or part of a column name in the Search field. Only matching results appear in the list. To restore the full list, clear the Search field.
-
To reset all columns to their original order, widths, and sorting—and to restore any hidden columns—click the menu icon (
) in a column header and select Reset Columns.
-
Drag to select any section of the table to copy the text to your clipboard or to view a custom chart for the selected cells only. After selecting multiple cells, right-click on the selected area and then select Copy, Copy With Headers, Copy with Group Headers, or Chart Range.
If you select Chart Range, you can then select a chart type. A copied selection can be pasted into a spreadsheet or text editor. Select Export (
) and then CSV Export or Excel Export to download the selection as a spreadsheet.
-
To pin any column to the left or right side of the table, can click the menu icon (
) in the column header and select Pin Column. Then select Pin Left or Pin Right. To clear a column pin, select No Pin.
-
To export the data represented in the table, click the Actions menu icon (
) and select Export to CSV or Export to Excel. A .csv or .xlxs file is saved to your browser's configured download location.
Note: The export file includes all available rows and columns, regardless of column visibility options.