Methods and user interfaces for visually analyzing data visualizations with multi-row calculations

A computer system for displaying object models for data sources, comprising:

• a display;
• one or more processors;
• and
• memory;
• wherein the memory stores one or more programs configured for execution by the one or more processors, and the one or more programs comprise instructions for:
• receiving user selection of a data source;
• displaying a data visualization in a data visualization user interface, according to placement of data fields, from the data source, in shelves of the user interface, wherein the data visualization comprises a plurality of visual data marks representing data from the data source;
• detecting a first user input to select a subset of the visual data marks;
• in response to detecting the first user input:
• displaying a view data window including a summary of the selected subset of visual data marks;
• obtaining a data model encoding the data source as a tree of logical tables, each logical table having its own physical representation and including a respective one or more logical fields, each logical field corresponding to either a data field or a calculation that spans one or more logical tables, wherein each edge of the tree connects two logical tables that are related, and each data field is either a measure or a dimension;
• determining, based on the data model, one or more aggregate measures that are measures corresponding to the selected subset of visual data marks, wherein each aggregate measure is aggregated from a plurality of logical tables of the data model;
• displaying each aggregate measure of the one or more aggregate measures in the view data window;
• and
• in accordance with a determination that a plurality of aggregate measures is aggregated from a same set of logical tables, displaying a single instance of the plurality of aggregate measures in the view data window.

A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors, and memory, the one or more programs comprising instructions for:

• receiving user selection of a data source;
• displaying a data visualization in a data visualization user interface, according to placement of data fields, from the data source, in shelves of the user interface, wherein the data visualization comprises a plurality of visual data marks representing data from the data source;
• detecting a first user input to select a subset of the visual data marks;
• in response to detecting the first user input:
• displaying a view data window including a summary of the selected subset of visual data marks;
• obtaining a data model encoding the data source as a tree of logical tables, each logical table having its own physical representation and including a respective one or more logical fields, each logical field corresponding to either a data field or a calculation that spans one or more logical tables, wherein each edge of the tree connects two logical tables that are related, and each data field is either a measure or a dimension;
• determining, based on the data model, one or more aggregate measures corresponding to the selected subset of visual data marks, wherein each aggregate measure is aggregated from a plurality of logical tables of the data model;
• displaying each aggregate measure of the one or more aggregate measures in the view data window;
• and
• in accordance with a determination that a plurality of aggregate measures is aggregated from a first logical table:
• (i) ceasing to display the plurality of aggregate measures, and (ii) displaying the first logical table, in the view data window.