公开(公告)号：US20220309066A1

公开(公告)日：2022-09-29

申请号：US17840546

申请日：2022-06-14

申请人： Tableau Software, Inc.

发明人： Robert Morton ,  Ross Bunker ,  Marianne Shaw ,  Pawel Terlecki

IPC分类号： G06F16/2453 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/28 ,  G06F16/9535

摘要： A user selects a first group of one or more dimension fields that specifies a primary aggregation for a data visualization, where the one or more dimension fields are in a first data source. When one or more first dimension fields in the first group are not dimension fields in a second data source, a client device joins the first data source with the second data source at a first level of detail that is more granular than the primary aggregation to form a single combined data set that includes the one or more dimension fields specified in the first group and one or more measure data fields aggregated according to the first group. The client device rolls up the combined data set, including the one or more measure data fields, to form a final data set and displays the data visualization using the data from the final data.

公开(公告)号：US11360991B1

公开(公告)日：2022-06-14

申请号：US15497130

申请日：2017-04-25

申请人： Tableau Software Inc.

发明人： Robert Morton ,  Ross Bunker ,  Marianne Shaw ,  Pawel Terlecki

IPC分类号： G06F16/248 ,  G06F16/28 ,  G06F16/9535 ,  G06F16/2455

摘要： 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.

公开(公告)号：US09633076B1

公开(公告)日：2017-04-25

申请号：US14054803

申请日：2013-10-15

申请人： Tableau Software Inc.

发明人： Robert Morton ,  Ross Bunker ,  Marianne Shaw ,  Pawel Terlecki

IPC分类号： G06F17/30

CPC分类号： G06F17/30466 ,  G06F17/30554

摘要： 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.