Methods and User Interfaces for Generating Level of Detail Calculations for Data Visualizations

A computing device, comprising:

• a display;
• one or more processors;
• and
• memory coupled to the one or more processors, the memory storing one or more programs configured to be executed by the one or more processors, the one or more programs including instructions for:
• receiving user selection of a data source;
• displaying a data visualization interface, including:
• a data visualization region;
• a shelf region with a plurality of shelves, each shelf defining a respective characteristic of a data visualization based on placement of data fields onto the respective shelf;
• and
• a schema information region displaying a plurality of data objects, wherein each of the data objects has one or more selectable data fields from the data source and each of the data fields is designated as a dimension or a measure;
• receiving user input to select a measure data field and a dimension data field from the schema information region;
• in response to the user input:
• generating a custom calculation that aggregates data for the measure data field, grouped by distinct data values of the dimension data field;
• storing the custom calculation as a new selectable data field, associated with a first data object corresponding to the dimension data field;
• and
• displaying the new selectable data field as a data field for the first data object in the schema information region;
• receiving user selection of the new selectable data field from the schema information region and placement of the new selectable data field onto a first shelf in the shelf region, wherein the first shelf defines a first data visualization characteristic;
• and
• generating and displaying a data visualization in the data visualization region, wherein the first data visualization characteristic of the data visualization is determined according to data values of the custom calculation.

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 user selection of a data source;
• displaying a data visualization interface, including:
• a data visualization region;
• a shelf region with a plurality of shelves, each shelf defining a respective characteristic of a data visualization based on placement of data fields onto the respective shelf;
• and
• a schema information region displaying a plurality of data objects, wherein each of the data objects has one or more selectable data fields from the data source and each of the data fields is designated as a dimension or a measure;
• receiving user input to select a measure data field and a dimension data field from the schema information region;
• in response to the user input:
• generating a custom calculation that aggregates data for the measure data field, grouped by distinct data values of the dimension data field;
• storing the custom calculation as a new selectable data field, associated with a first data object corresponding to the dimension data field;
• and
• displaying the new selectable data field as a data field for the first data object in the schema information region;
• receiving user selection of the new selectable data field from the schema information region and placement of the new selectable data field onto a first shelf in the shelf region, wherein the first shelf defines a first data visualization characteristic;
• and
• generating and displaying a data visualization in the data visualization region, wherein the first data visualization characteristic of the data visualization is determined according to data values of the custom calculation.