Abstract: A computing device receives user input specifying a first dimension data field and a second dimension data field. The device constructs a dimension subquery according to characteristics of the first dimension data field, the second dimension data field, a first object to which the first dimension data field belongs, and/or a second object to which the second dimension data field belongs, including determining a join type for combining (i) first data rows that include data values of the first dimension data field and (ii) second data rows that include data values of the second dimension data field. The device constructs the dimension subquery according to the determined join type, and executes the dimension subquery to retrieve first tuples. The device constructs measure subqueries and executes the measure subqueries to retrieve second tuples. The device forms extended tuples, and generates and displays the data visualization according to the extended tuples.

Abstract: A server system is communicatively connected to a plurality of computing devices and one or more databases. The server system receives one or more queries from a computing device. The one or more queries specify a data source. The server system determines a level of security applicable to a user of the computing device. The server system translates the one or more queries into one or more logical queries according to semantics of the data source, and transmits the logical queries to a query pipeline of the server system. The server system executes the one or more queries against a first database of the one or more databases to retrieve query results from the data source. The server system applies the determined level of security to the query results to obtain one or more data sets, and returns the one or more data sets to the computing device.

Abstract: A computing device generates and displays a data visualization in a data visualization user interface. The data visualization includes a plurality of visual data marks representing data from a data source. The computing device detects a first user input to select a visual data mark of the plurality of visual data marks. In response to detecting the first user input, the computing device identifies a first aggregated data value, for the visual data mark, corresponding to a first data field in the data source. The computing device retrieves a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field. The computing device displays, in the data visualization user interface, a plurality of data rows from the first disaggregated set of data rows.

Abstract: A computer system receives, from a programmatic interface of a client device via one or more external API calls, a query that specifies a data source and one or more data fields of the data source. The computer system, in accordance with receiving the query, generates a query specification according to the one or more data fields of the data source, wherein the query specification is an extended version of the API calls. The computer system transmits the query specification to a data service and causes the data service to execute one or more database queries to retrieve data against a database to retrieve query results from the data source, according to the query specification. The computer system receives the query results from the data service, configures the query results to obtain configured data, and transmits the configured data to the client device for display in the programmatic interface.

Abstract: A client device receives one or more inputs for generating a data visualization according to a data source. The device determines one or more requirements for generating the data visualization. The device sends a request to a network gateway that is communicatively connected to the client device and a plurality of data servers, and receives, from the network gateway, capabilities of each data server. The device determines, according to the received capabilities, that a first data server of the plurality of data servers includes a first set of capabilities that satisfies the requirements for generating the data visualization. The device sends, via the network gateway, one or more queries to the first data server and receives, from the first data server, one or more data sets from the data source. The device generates the data visualization according to the retrieved data sets and displays the data visualization.

Abstract: A computing device receives user input specifying a first dimension data field and a second dimension data field. The device constructs a dimension subquery according to characteristics of the first dimension data field, the second dimension data field, a first object to which the first dimension data field belongs, and/or a second object to which the second dimension data field belongs, including determining a join type for combining (i) first data rows that include data values of the first dimension data field and (ii) second data rows that include data values of the second dimension data field. The device constructs the dimension subquery according to the determined join type, and executes the dimension subquery to retrieve first tuples. The device constructs measure subqueries and executes the measure subqueries to retrieve second tuples. The device forms extended tuples, and generates and displays the data visualization according to the extended tuples.

Abstract: A computing device displays a first object icon representing a first object of a first data source and a second object icon, representing a second object of the first data source. The first object icon is connected to the second object icon via a first connector representing a relationship between the first object and the second object. In response to receiving a first user input to add a third object, the computing device displays a third object icon representing the third object. In response to receiving a second user input on the third object icon, in accordance with a determination that the second object and the third object include at least one common data field, the computing device displays a second connector, connecting the third object icon to the second object icon.

Abstract: A computing device displays, in a user interface, data field icons corresponding to a plurality of data fields. Each of the data fields is associated with a respective object in an object model. In response to receiving (i) user selection of a first data field icon corresponding to a first data field, and (ii) placement of the first data field icon in a shelf region of the user interface, where the first data field is associated with a first object of the object model, the computing device generates a first data visualization and updates a visual characteristic of a subset of the data field icons from a first visual characteristic to a second visual characteristic. Each data field icon in the subset is associated with a second object of the object model. The data field icons in the subset are user-selectable independently of the first or second visual characteristic.

Abstract: A method for generating data visualizations includes receiving user selection of a data source, and receiving user input to define a dynamic set according to: (i) user selection of visual marks in a visualization region and/or (ii) user specification of a parameter corresponding to data fields in the data source. The method also includes receiving user input to define a calculation to compare data values for a data field from the data source to data values in the dynamic set. The method further includes identifying a set of rows from the data source whose data values are included in the dynamic set. The method also includes receiving user input to place a data field from the data source in a shelf region, and displaying a data visualization that includes a plurality of visual marks corresponding to data values, of the data field, in the set of rows.

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 computing device displays a data visualization user interface that includes a schema region. Each data field displayed in the schema region is visually associated with a respective data object of a plurality of data objects in an object model. The device receives user input to specify a mathematical expression that includes a first data field from a first object and a second data field from a second object. The first object and the second object are distinct objects in the object model. The device generates a calculated data field based on the mathematical expression. The device assigns the calculated data field as a member of a third object in the object model according to relations in the object model connecting the first object to the second object. The device displays the calculated data field, in the schema region, visually associated with the third object.

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: A computing device generates and displays a data visualization in a data visualization user interface. The data visualization includes a plurality of visual data marks representing data from a data source. The computing device detects a first user input to select a visual data mark of the plurality of visual data marks. In response to detecting the first user input, the computing device identifies a first aggregated data value, for the visual data mark, corresponding to a first data field in the data source. The computing device retrieves a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field. The computing device displays, in the data visualization user interface, a plurality of data rows from the first disaggregated set of data rows.

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: A method for analyzing data from data sources includes receiving user selection of a data source and displaying an interface that includes a schema region and a plurality of shelf regions. Each data field in the schema region is associated with a respective system-defined object from the data source. In a first display mode, each data field is displayed as associated with a respective system-defined object. In a second display mode, each data field is displayed in a respective user-defined folder. The method also includes displaying a data visualization according to a user placement of first and second data fields into the first and second shelf regions.

Abstract: A computer generates and displays a data visualization in a data visualization user interface according to placement of data fields, from a data source. The data visualization includes visual data marks representing data from the data source. The computer detects a user input to select a visual data mark. In response to detecting the user input, the computer obtains a data model encoding the data source as a tree of logical tables. The computer identifies one or more aggregated data values for the visual data mark, each of the aggregated data values corresponding to a respective data field in the data model. For each of the aggregated data values, the computer retrieves a respective disaggregated set of data rows from a respective logical table containing the respective data field. The computer displays a summary grid, with a respective tab corresponding to each of the retrieved disaggregated sets of data rows.

Abstract: A computing device displays a data visualization user interface that includes a schema region. Each data field displayed in the schema region is visually associated with a respective data object of a plurality of data objects in an object model. The device receives user input to specify a mathematical expression that includes a first data field from a first object and a second data field from a second object. The first object and the second object are distinct objects in the object model. The device generates a calculated data field based on the mathematical expression. The device assigns the calculated data field as a member of a third object in the object model according to relations in the object model connecting the first object to the second object. The device displays the calculated data field, in the schema region, visually associated with the third 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: A method for analyzing data from data sources includes receiving user input to specify a mathematical expression. The mathematical expression includes a first data field from a first object and a second data field from a second object. The first object and the second object are distinct objects of an object model that includes a tree in which each relation between objects represents a respective many-to-one relationship between respective objects. The method further includes generating a calculated data field based on the mathematical expression, and assigning the calculated data field as a member of a third object in the object model according to relations in the tree connecting the first object to the second object.

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.