US 12,073,065 B2
Data preparation user interface with coordinated pivots
Arthur Gyldenege, Seattle, WA (US); and Anushka Anand, Seattle, WA (US)
Assigned to Tableau Software, Inc., Seattle, WA (US)
Filed by Tableau Software, Inc., Seattle, WA (US)
Filed on May 4, 2021, as Appl. No. 17/307,402.
Application 17/307,402 is a continuation of application No. 16/221,413, filed on Dec. 14, 2018, granted, now 10,996,835.
Prior Publication US 2021/0255760 A1, Aug. 19, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 3/04845 (2022.01); G06F 3/0482 (2013.01); G06F 40/177 (2020.01)
CPC G06F 3/04845 (2013.01) [G06F 3/0482 (2013.01); G06F 40/177 (2020.01); G06F 2203/04803 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method for generating coordinated pivot tables, comprising:
at a computer system having one or more processors and memory storing one or more programs configured for execution by the one or more processors:
displaying, in a user interface, a plurality of data field icons, each of the plurality of data field icons corresponding to a respective data field of a data source;
receiving a first user input in the user interface to select a first set of two or more data field icons from the plurality of data field icons;
in response to receiving the first user input, performing a first pivot on a first set of two or more data fields, corresponding to the first set of two or more data field icons, to form a data table having (i) a plurality of new rows that are created by converting data columns of the first set of two or more data fields into the plurality of new rows and (ii) a first set of two or more new columns, and displaying the data table in the user interface;
receiving a second user input in the user interface to select a second set of two or more data field icons from the plurality of data field icons, wherein the second set of data field icons is distinct from the first set of data field icons; and
in response to receiving the second user input:
performing a second pivot on a second set of two or more data fields, corresponding to the second set of two or more data field icons, to form a second new column;
adding the second new column to the data table formed by the first pivot, each data value from the second set of two or more data fields added to the second new column in a respective row of the plurality of new rows (1) without creating additional new rows and (2) without modifying existing data values in the first set of two or more columns formed by the first pivot; and
redisplaying the data table in the user interface.