US Patent 11360991 Blending and visualizing data from multiple data sources

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.