US 11,704,319 B1
Table calculations for visual analytics using concise level of detail semantics
Alvin Edward Jou, Seattle, WA (US); Bethany Meaghan Lyons, London (GB); and Jeffrey Mark Booth, Jr., Seattle, WA (US)
Assigned to Tableau Software, LLC, Seattle, WA (US)
Filed by Tableau Software, LLC, Seattle, WA (US)
Filed on Oct. 14, 2021, as Appl. No. 17/501,928.
Int. Cl. G06F 16/2455 (2019.01); G06F 16/248 (2019.01); G06F 16/2452 (2019.01)
CPC G06F 16/24554 (2019.01) [G06F 16/248 (2019.01); G06F 16/2452 (2019.01)] 20 Claims
OG exemplary drawing
 
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.