CPC G06F 16/24554 (2019.01) [G06F 16/248 (2019.01); G06F 16/2452 (2019.01)] | 20 Claims |
1. A method, comprising:
at a computing device including a display, one or more processors, and memory storing one or more programs configured for execution by the one or more processors:
receiving user selection of a data source;
receiving a user input to specify a level of detail (LOD) expression that includes a first keyword, a SORT keyword, and an analytic expression, wherein:
the first keyword specifies how a dimensionality expression corresponding to the first keyword is used in the LOD expression; and
the analytic expression includes an analytic function that partitions data rows from the data source into groups and computes a respective distinct value for each data row in a respective group using values from other data rows in the respective group;
in response to the user input:
identifying one or more data fields from the data source;
translating the LOD expression into one or more executable database queries referencing the identified data fields;
executing the one or more queries to retrieve data from the data source; and
generating and displaying a data visualization using the retrieved data.
|