An example method of displaying a data visualization includes displaying a plurality of selectable fields and receiving user selections of two different fields from the plurality of selectable fields. The method also includes generating, in accordance with the received user selections, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple and (ii) each data mark has a y-position defined according to data for a second field in the respective tuple. The method also includes displaying the data visualization that includes the generated data marks.

A method and system for accurately estimating a result size of a Group-By operation in a relational database. The estimate utilizes the probability of union of the columns involved in the operation, as well as the relative cardinality of each column with respect to the other columns in the operation. In addition, the estimate incorporates the use of table filters when indicated such that table filters are applied prior to determining the size of the tables in the operation, as well as including equivalent columns into the list of columns that are a part of the Group-By operation. Accordingly, the estimate of the result size of the operation includes influencing factors that provide an accurate estimation of system memory requirements.

An example method of displaying a data visualization includes displaying a graphical user interface that includes three distinct regions, and receiving user actions to associate two different fields with two different shelves. The method also includes generating, in accordance with the received user actions, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple and (ii) each data mark has a y-position defined according to data for a second field in the respective tuple. The method also includes displaying a data visualization that includes the generated data marks.

An exemplary method of displaying a data visualization includes retrieving a dataset that includes a plurality of fields and displaying a graphical user interface with a plurality of shelves. The method further includes receiving user actions to: (i) associate a first field with a first shelf, and (ii) associate a second field with a second shelf; displaying, in accordance with the received user actions, a data visualization, where each data mark has a first size defined according to a default position of a displayed slidable affordance; and receiving an additional user action that moves the slidable affordance from the default position to a user-defined position. In response to receiving the additional user action, the method further includes updating the data visualization, where each data mark included in the updated data visualization has a second size, different from the first size, defined according to the user-defined position of the slidable affordance.

An exemplary method of displaying a data visualization includes displaying a graphical user interface that includes three distinct regions, and receiving user actions to associate three different fields with three different shelves, including a shelf that defines colors of data marks. The method also includes generating, in accordance with the received user actions, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple, (ii) each data mark has a y-position defined according to data for a second field in the respective tuple, and (iii) each data mark has a color assigned according to data for a third field in the respective tuple. The method also includes displaying a data visualization that includes the generated data marks.

A method is performed at a computer. The computer retrieves a dataset having a plurality of fields, including a first field and a second field. The computer displays a graphical user interface, including a first region displaying the plurality of fields from the dataset, a second region having a plurality of shelves determined according to a user-selected data visualization type, and a third region for displaying one or more data visualizations. The computer receives user actions to drop the first field on a first shelf and to drop the second field on a second shelf. The first and second shelves define positional attributes of data marks. The computer displays a data visualization in the third region. Each data mark has a position in the data visualization determined according to the first shelf, a data value for the first field, the second shelf, and a data value for the second field.

An example method of displaying a data visualization includes displaying a graphical user interface that includes three distinct regions, and receiving user actions to associate two different fields with two different shelves. The method also includes generating, in accordance with the received user actions, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple and (ii) each data mark has a y-position defined according to data for a second field in the respective tuple. The method also includes displaying a data visualization that includes the generated data marks.

An example method of displaying a data visualization includes displaying a plurality of selectable fields and receiving user selections of two different fields from the plurality of selectable fields. The method also includes generating, in accordance with the received user selections, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple and (ii) each data mark has a y-position defined according to data for a second field in the respective tuple. The method also includes displaying the data visualization that includes the generated data marks.

A method of displaying data visualizations includes retrieving a dataset from a multidimensional database, where the dataset includes a plurality of fields, including first and second fields, and the first field is a data hierarchy that includes multiple subfields. The method further includes displaying a GUI with a first region displaying the plurality of fields (with the first field in a collapsed state), a second region with a plurality of shelves, and a third region. In response to receiving a user action to display the first field in an expanded state, the method displays the first field and the multiple subfields in a hierarchical structure. The method receives additional user actions to: (i) associate a first subfield of the plurality with a first shelf, and (ii) associate the second field with a second shelf, and then displays, in accordance with the user actions, a data visualization in the third region.

An example method of displaying a data visualization includes displaying a graphical user interface that includes three distinct regions, and receiving user actions to associate two different fields with two different shelves. The method also includes generating, in accordance with the received user actions, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple and (ii) each data mark has a y-position defined according to data for a second field in the respective tuple. The method also includes displaying a data visualization that includes the generated data marks.