Utilizing appropriate measure aggregation for generating data visualizations of multi-fact datasets

A computer system for generating data visualizations, comprising:

• one or more processors;
• and
• memory;
• wherein the memory stores one or more programs configured for execution by the one or more processors, and the one or more programs comprising instructions for:
• receiving a visual specification, which specifies a data source, a plurality of visual variables, and a plurality of data fields from the data source, wherein each of the visual variables is associated with either (i) a respective one or more of the data fields or (ii) one or more filters, and each of the data fields is identified as either a dimension or a measure;
• obtaining a data model encoding the data source as a tree of logical tables, each logical table having its own physical representation and including a respective one or more logical fields, each logical field corresponding to either a data field or a calculation that spans one or more logical tables, wherein each edge of the tree connects two logical tables that are related;
• generating a dimension subquery based on logical tables that supply the data fields for the dimensions and the filters;
• generating, for each measure, based on the logical tables that supply the data fields for the respective measure and the filters, an aggregated measure subquery grouped by the dimensions;
• forming a final query by joining, using the dimensions, the dimension subquery to each of the aggregated measure subqueries;
• executing the final query against the data source to retrieve tuples that comprise distinct ordered combinations of data values for the data fields;
• and
• building and displaying a data visualization according to the data fields in the tuples and according to the visual variables to which each of the data fields is associated.

A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors, and memory, the one or more programs comprising instructions for:

• receiving a visual specification, which specifies a data source, a plurality of visual variables, and a plurality of data fields from the data source, wherein each of the visual variables is associated with either (i) a respective one or more of the data fields or (ii) one or more filters, and each of the data fields is identified as either a dimension or a measure;
• obtaining a data model encoding the data source as a tree of logical tables, each logical table having its own physical representation and including a respective one or more logical fields, each logical field corresponding to either a data field or a calculation that spans one or more logical tables, wherein each edge of the tree connects two logical tables that are related;
• generating a dimension subquery based on logical tables that supply the data fields for the dimensions and the filters;
• generating, for each measure, based on the logical tables that supply the data fields for the respective measure and the filters, an aggregated measure subquery grouped by the dimensions;
• forming a final query by joining, using the dimensions, the dimension subquery to each of the aggregated measure subqueries;
• executing the final query against the data source to retrieve tuples that comprise distinct ordered combinations of data values for the data fields;
• and
• building and displaying a data visualization according to the data fields in the tuples and according to the visual variables to which each of the data fields is associated.