Reset data

User permission: Query > Focus and Reset

During your analysis, you might want to stop what you are doing and start again. You can use the Reset tool to clear all the dimensions you are focusing on and all rows or cells you have selected. Most functions will revert to their default settings. Here is an overview of what the Reset tool does and does NOT do:

Resets

Does NOT reset

  • Everything you are focusing on

  • These functions:

    • Mode (back to the default)

    • Properties (back to the default)

    • Measures (back to the default)

    • Activity Filter (back to the default)

    • Format

  • Kind (back to the default, i.e. resetting from a chart or nested grid will revert to standard grid)

  • Search (basic and advanced)

  • Quick Filter

  • These options:

    • Show Average

    • Hide Status

    • Hide Dimensions

  • Favorites and alerts. That is, it doesn't take you back to the original favorite or alert - instead it removes the favorite /alert title and replaces it with the title of the relevant database, and then follows all the other rules in these lists.

  • These functions:

    • Period

    • Stream

  • Locked selections

  • Text in the search box

  • Dimension (i.e. reset leaves you in your current dimension and doesn't take you back to the summary dimension)

  • These options:

    • Monochrome Exports

    • Show Others

    • Show Sum

    • Month To Date

    • Hide Total

    • Show Net Zero

    • Totals as Average

  • Additional Transaction mode properties

Last updated