Abstract: A computer receives a visual specification, which specifies a data source, visual variables, and data fields from the data source. Each visual variable is associated with either data fields (e.g., dimension and/or measures) or filters. The computer obtains a data model encoding the data source as a tree of related logical tables. Each logical table includes logical fields, each of which corresponds to either a data field or a calculation that spans logical tables. The computer generates a dimension subquery for the dimensions and the filters. The computer also generates, for each measure, an aggregated measure subquery grouped by the dimensions. The computer forms a final query by joining the dimension subquery to each of the aggregated measure subqueries. The computer subsequently executes the final query and displays a data visualization according to the results of the final query.

Abstract: The method receives a visual specification, which specifies a data source, visual variables, and data fields from the data source. Each visual variable is associated with data fields and each data field is either a dimension or a measure. From an object model of the data source, the method identifies a minimal subtree that includes all of the dimension data fields and constructs a query from the minimal subtree. The method executes the query against the data source to retrieve a set of tuples, each tuple comprising a unique ordered combination of data values for the dimension data fields. For each tuple, the method forms an extended tuple by appending aggregated data values corresponding to each measure data field. The method then builds and displays a data visualization according to the data fields in the extended tuples and according to the visual variables to which the data fields are associated.

Abstract: An electronic device displays a chart in accordance with contents of a plurality of shelf regions of a data visualization interface. The chart includes visual marks representing a set of data. The electronic device generates a visual analytic object by applying a first analytic operation to the set of data represented by the visual marks, and displays the visual analytic object superimposed over the chart. The device detects user input to select the displayed visual analytic object and place an icon representing the visual analytic object onto a first shelf region of the plurality of shelf regions. In response to the user input, the electronic device updates content of the first shelf region to include an association with the first analytic operation corresponding to the visual analytic object.

Abstract: A computer system displays a data visualization in a data visualization user interface. In response to detecting a user input that selects a subset of visual data marks from the data visualization, the computer system displays a summary of the selected subset of visual data marks in a summary tab of a view data window. When the computer system determines that the selected subset of visual marks (1) corresponds to a plurality of data fields and (2) references a row-level calculation that uses logical fields from at least two logical tables of a plurality of logical tables of a data model, the computer system (i) generates a representation of the row-level calculation and (ii) displays the representation of the row-level calculation as a first tab in the view data window, distinct from the summary tab.

Abstract: A user selects a data source, and a computer displays a data visualization in a data visualization user interface according to the data source. The data visualization includes visual data marks representing data from the data source. The user selects a subset of the visual data marks. In response, the computer displays a view data window having a summary of the selected data marks. The computer obtains a data model encoding the data source as a tree of logical tables. The computer identifies aggregate measures corresponding to the selected data marks, where each aggregate measure is aggregated from logical tables of the data model. The computer displays each aggregate measure in the view data window. The computer also displays, in the view data window, one or more level of detail calculations referenced in the selected subset of visual data marks.

Abstract: An electronic device displays a chart, which includes a first set of visual marks that represent values derived from a set of data. The device concurrently displays a chart-calculations-options area. The chart-calculations-options area displays a first plurality of options for type of calculation. The device detects user selection of (i) a first option, from the first plurality of options, for type of calculation and (ii) a second option corresponding to a parameter for the selected first option. In response to detecting the user selection, the device visually distinguishes visual marks in a second set of visual marks in the chart. The second set of visual marks is distinct from the first set of visual marks and corresponds to the first option for type of calculation and the second option corresponding to the parameter for the selected first option.

Abstract: An electronic device displays a chart in accordance with contents of a plurality of shelf regions of a data visualization interface. The chart includes visual marks representing a set of data. The electronic device generates a visual analytic object by applying a first analytic operation to the set of data represented by the visual marks, and displays the visual analytic object superimposed over the chart. The device detects user input to select the displayed visual analytic object and place an icon representing the visual analytic object onto a first shelf region of the plurality of shelf regions. In response to the user input, the electronic device updates content of the first shelf region to include an association with the first analytic operation corresponding to the visual analytic object.

Abstract: A computing device displays a data visualization interface that includes a shelf region and a schema information region. The device receives user input to select a measure data field and a dimension data field from the schema information region. The device generates a custom calculation that groups data values of the dimension data field according to respective distinct data values of the dimension data field and aggregates data values of the measure data field for each of the distinct data values of the dimension data field. The device stores the custom calculation as a new selectable data field and displays the new selectable data field in the schema information region. The device receives user selection of the new selectable data field from the schema information region and placement of the new selectable data field in the shelf region. The device generates and displays a data visualization.

Abstract: The process receives a visual specification, which specifies data sources, visual variables, and data fields from the data sources. Each visual variable is associated with one or more data fields and each data field is either a dimension or a measure. For each measure m, the process identifies a set R(m) consisting of dimensions that are reachable from the measure by a sequence of many-to-one relationships in an object model for the data sources. For each distinct set R, the process forms a data field set S, consisting of each dimension in R and each measure m for which R(m)=R. For each set S and for each measure in the set S, the process aggregates values of the measure according to the dimensions in S. The process builds a data visualization according to the data fields in the set S and the visual variables they are associated with.

Abstract: A method displays a chart including visual marks representing a dataset. The chart is based on content of displayed shelf regions, each determining a respective characteristic of the visual marks. The method generates a visual analytic object by applying a first analytic operation to the dataset, and displays the visual analytic object over the chart. The method detects user input to select the displayed visual analytic object and place an icon representing the visual analytic object onto a first shelf region. The first shelf region defines a first characteristic of the visual marks. In response to the user input, the method updates content of the first shelf region to specify association with the first analytic operation and updates the first characteristic of the visual marks in the chart based on values of the set of data represented by the visual marks relative to values computed by the first analytic operation.

Abstract: An electronic device displays a chart, which includes a first set of visual marks that represent values derived from a set of data. The device concurrently displays a chart-calculations-options area. The chart-calculations-options area displays a first plurality of options for type of calculation. The device detects user selection of (i) a first option, from the first plurality of options, for type of calculation and (ii) a second option corresponding to a parameter for the selected first option. In response to detecting the user selection, the device visually distinguishes visual marks in a second set of visual marks in the chart. The second set of visual marks is distinct from the first set of visual marks and corresponds to the first option for type of calculation and the second option corresponding to the parameter for the selected first option.

Abstract: The method receives a visual specification, which specifies a data source, visual variables, and data fields from the data source. Each visual variable is associated with data fields and each data field is a dimension or a measure. The method forms dimension tuples comprising distinct ordered combinations of data values for the dimensions D. For each measure, the method: forms a set S of the dimensions D plus dimensions from a primary key corresponding to the measure; retrieves intermediate tuples containing the fields in S and the measure, without aggregation; and aggregates the intermediate tuples according to the dimensions D. For each dimension tuple, the method forms an extended tuple by appending the aggregated data values corresponding to each measure field. The method then builds and displays a data visualization according to the extended tuples and the visual variables to which the data fields are associated.

Abstract: A computing device displays a data visualization interface that includes a shelf region and a schema information region. The device receives user input to select a measure data field and a dimension data field from the schema information region. The device generates a custom calculation that groups data values of the dimension data field according to respective distinct data values of the dimension data field and aggregates data values of the measure data field for each of the distinct data values of the dimension data field. The device stores the custom calculation as a new selectable data field and displays the new selectable data field in the schema information region. The device receives user selection of the new selectable data field from the schema information region and placement of the new selectable data field in the shelf region. The device generates and displays a data visualization.

Abstract: An electronic device displays a chart, which includes visual marks that represent calculated values derived from a set of data, and panes formed by intersection of rows and columns. A current focus is on a first visual mark at a first position. The device concurrently displays a chart-calculations-options area, which includes display options for the type of calculation and the type of data partitioning. Visual marks in a first set of visual marks are visually distinguished from other visual marks. The first set of visual marks includes the first visual mark, and corresponds to a first selected option for the type of calculation and a first selected option for the type of data partitioning. The device detects an input that selects a second option for the type of data partitioning. In response, the device visually distinguishes visual marks in a second set of visual marks in accordance with the selection.

Abstract: A computer system displays a graphical user interface that includes a data visualization region, a shelf region, and a schema information region. The computer system receives a first user input to place a first dimension data field from the schema information region into the shelf region. In accordance with the first user input, the computer system determines a visualization level of detail that is based on at least the first dimension data field. The computer system receives a second user input to specify a first aggregation. The first aggregation has a custom level of detail that is distinct from the visualization level of detail. The computer system builds a visual specification that includes the visualization and custom levels of detail. The computer system generates a data visualization corresponding to the visual specification and displays the data visualization in the data visualization region.

Abstract: A method generates a data source. A user selects a first data set from a displayed object model of a database. The object model includes data sets linked visually by many-to-one relationships to form a tree. The user selects a data field in the first data set and specifies a filter condition. The system identifies a second data set in the tree, and joins the first and second data sets. When the second data set is related to the first data set via one or more many-to-one relationships, rows of the second data set are joined to rows of the first data set that satisfy the first filter condition. When the second data does not satisfy the condition, the second data set is joined to rows of the first data set that satisfy the first filter condition, and all rows of the second data set are included in the generation.

Abstract: A computer displays data sources associated with tables of data. The computer also displays data object icons, each representing a logical combination of tables. While displaying the data sources and the data object icons, the computer detects a portion of an input on a table. In response, the computer generates a candidate data object icon corresponding to the table. The computer also detects another portion of the input on the candidate data object icon. In response, the computer moves the candidate object icon towards the data object icons, while providing a visual cue connecting the candidate object icon to a neighboring data object icon. The computer detects yet another portion of the input, and, in response, displays a connection between the candidate object icon and the neighboring data object icon, and updates the tree of the one or more data object icons to include the candidate data object icon.

Abstract: A computing device displays a data visualization interface and receives user selection of a data source. The computing device also receives user input to select a measure data field and a dimension data field. In response to the user input, the computing device: generates a custom calculation that aggregates data for the measure data field, grouped by distinct data values of the dimension data field; and stores the custom calculation as a new selectable data field, associated with a data object corresponding to the dimension data field. The computing device also receives user selection of the new selectable data field and placement of the new selectable data field onto a first shelf in a shelf region. The first shelf defines a first data visualization characteristic determined according to data values of the custom calculation. The computing device generates and displays a data visualization based on the first data visualization characteristic.

Abstract: A data visualization application receives user actions to (i) associate a first data field with a first shelf and (ii) associate second and third data fields with a second shelf. The method receives an additional user action to specify a nested sort according to data for the first and third data fields. The method generates and displays a data visualization in accordance with the received actions, including: (i) partitioning retrieved data into groups of tuples, each tuple including data for the data fields, and each group of tuples corresponding to a distinct value of the second data field, (ii) forming panes, each pane corresponding to a respective group of tuples, and (iii) within each pane, displaying data marks, each data mark corresponding to a respective tuple.

Abstract: An exemplary method receives user actions to (i) associate a first field with a first shelf and (ii) associate second and third fields with a second shelf. The second field is positioned at an outer-most position on the second shelf and the third field is positioned at an inner-most position on the second shelf. The method receives an additional user action to specify a nested sort according to data for the first and third fields. The method generates and displays a data visualization in accordance with the received actions, including: (i) partitioning retrieved data into groups of tuples, each tuple including data for the fields, and each group of tuples corresponding to a distinct value of the second field, (ii) forming panes, each pane corresponding to a respective group of tuples, and (iii) within each pane, displaying data marks, each data mark corresponding to a respective tuple.