Tableau Software, Inc.

Microsoft Technology Licensing, LLC

Bea Systems, Inc.

Ross Thomas Bunker

Jock Douglas Mackinlay

Justin Talbot

Christopher Richard Stolte

Bora Beran

Jun Ho Kim

Goetz Graefe

Milind Madhukar Joshi

Cesar Alejandro Galindo-Legaria

Britta Claire Nielsen

Daniel Cory

Michael John Arvold

Pawel Terlecki

Marianne Shaw

Vivek Anup Maharajh

Robert Morton

Robin Stewart

Austin David Dahl

Douglas Alan Thomae

Roger B Weber

Daniel William DeKlotz

Lawrence A Jones

Cesar A Galinda-Legaria

Richard Michael Grantham Wesley

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.

User interface for generating data visualizations that use table calculations

Embodiments are directed to managing event information. A plurality of events associated with entities may be provided. A plurality of state types may be determined based on the plurality of events such that each state type is associated with a state. State keys associated with each entity may be determined based on events associated with each entity and the state types. A state stream for each entity may be provided based on their state keys such that each state stream may be an ordered sequence of the keys associated with each entity. In response to a query that includes a pattern filter, the pattern filter may be employed to determine a portion of the entities based on the state stream for each entity such that the pattern filter matches the state stream for each of the portion of the entities.

Event sequence analysis

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.

Embodiments are directed to managing data models. A data source that includes records may be provided. Source fields may be determined based on the records and the source fields may be displayed in a source panel. A data model that includes a source data object may be displayed. Relationships between the source fields may be determined based on values in the records. In response to providing a relationship between the source fields, a data object that includes a key field and one or more data fields that correspond to the relationship may be generated. The data model may be modified to include the data object and to remove the source fields that correspond to the data fields.

Interactive data modeling

A method dynamically combines multiple data sources. A user selects a first group of fields that specify primary aggregation for a data visualization. When a field in the first group is not a data field in one of the data sources, the process creates a second group of fields that specifies an intermediate aggregation for joining data sets that is more granular than the primary aggregation. For each data source, the process aggregates measure fields according to the second group to form a respective intermediate data set. The process forms a single combined data set from the intermediate data sets, including the fields specified in the first group, and aggregates each measure field in the combined data set using the primary aggregation to form a final data set based on the fields from the first group. The process then displays the data visualization using the final data set.

Blending and visualizing data from multiple data sources

A method displays a graphical user interface for a data visualization application. The user interface includes a schema information region that includes fields from a database. A user specifies a first aggregation using the interface. The first aggregation groups by a first set of fields and specifies an aggregated output field. The user also specifies a second aggregation. The second aggregation references the first aggregation and groups by a second set of fields. The set may include the aggregated output field. The second set is different from the first set. The method builds a visual specification based on the first and second aggregations. The method may retrieve tuples of data from the database using database queries generated from the visual specification, where each tuple includes data calculated based on the second aggregation. The method may display a data visualization, including the data calculated based on the second aggregation.

Systems and methods for using multiple aggregation levels in a single data visualization

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 a type of calculation and a 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 a type of calculation and a first selected option for a type of data partitioning. The device detects an input that selects a second option for a type of data partitioning, and, in response, visually distinguishes visual marks in a second set of visual marks in accordance with the selection.

Devices and methods for selecting and displaying chart calculation options

A method dynamically combines data from multiple data sources. A visual specification for a data visualization requires data from a primary data source and one or more secondary data sources. The primary data source is independent of the secondary data sources. The visual specification includes a first set of dimension fields that specify a hierarchical level for the data visualization. A second set of dimension fields specify a hierarchical level for joining data sets from the data sources. The hierarchical level for joining data sets is more granular than the hierarchical level for the data visualization. For each data source, a query is generated, and a data set is retrieved from the data source using the query. A single combined data set is formed that includes the dimension fields in the first set. The combined data set is rolled-up and a data visualization is displayed using the rolled-up data.

A computer-implemented method of generating a map view includes accessing a dataset having multiple records and multiple fields. One or more of the multiple fields are identified as geographical fields. Geographical codes are automatically associated with a first one of the identified geographical fields. A geographical map is generated for the dataset. Generating the geographical map includes generating a first plurality of marks on the geographical map. The first plurality of marks is positioned on the geographical map in accordance with the geographical codes associated with the first one of the identified geographical fields.

Methods and systems of automatically geocoding a dataset for visual analysis

A system and method to update a patch index such that one or more properties in the patch index are associated with the patch, wherein the patch includes one or more components for the target software system; updating a class path at run-time for the target software system such that the patch associated with each one of the one or more properties supersedes prior patches for the same property; and wherein a component can include a class.

Systems and methods for dynamic application patching

A method of satisfying a database query includes evaluating certain joins on a per-segment basis. An expression tree is produced for the query, and the expression tree is evaluated to identify joins whose operands are two instances of the same relation and whose join predicate conjunctively includes an equality comparison between two instances of the same column. When such a join is identified, it may be evaluated by segmenting the operand relation according to the columns that are compared for equality in the predicate. The join is then evaluated by performing the join operation separately on each segment. Segments may be spooled separately, thereby exploiting the efficiencies obtained by spooling even where the entire relation is too large to fit in the spool. Execution iterators are provided for spooling successive segments and for applying the join to the spooled segment.

Growing community of inventors

Seattle, WA, United States of America

Ross Thomas Bunker