-
公开(公告)号:US11698903B2
公开(公告)日:2023-07-11
申请号:US17409717
申请日:2021-08-23
发明人: Clark Wildenradt , Arthur Gyldenege
IPC分类号: G06F16/242 , G06F16/22 , G06F16/28
CPC分类号: G06F16/244 , G06F16/221 , G06F16/2282 , G06F16/287
摘要: A method executes at a computing device that includes a display. The device displays a user interface that includes a data flow pane and a calculation pane, the data flow pane including a node/link diagram for a data prep flow. A user selects a node in the diagram, and the device populates affordances in the calculation pane according to data fields of a data set associated with the selected node. A first user input specifies grouping on a first data field, and a second user input specifies an aggregation function on a second data field. In response to the user inputs, for each distinct value of the first data field, the device aggregates corresponding values of the second data field according to the aggregation function. Calculated data values are displayed in the calculation pane. The device saves rows of data displayed in the calculation pane as a new data source.
-
公开(公告)号:US20230014484A1
公开(公告)日:2023-01-19
申请号:US17947027
申请日:2022-09-16
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
摘要: A computer system concurrently displays a plurality of panes in a user interface. The panes include a first pane that displays a flow diagram having one or more nodes. Each node contains one or more icons. Each icon represents a respective data transformation operation. The panes include a second pane that displays a plurality of data rows and/or data columns for an intermediate dataset corresponding to a user-selected node. The computer system receives a user input, in the first pane, to perform a first data transformation operation at a selected node. In response to receiving the user input, the computer system performs the first data transformation operation. The computer system displays, in the first pane, an additional icon corresponding to the first data transformation operation at the selected node. The computer system updates the second pane in accordance with the first data transformation operation.
-
公开(公告)号:US20210271354A1
公开(公告)日:2021-09-02
申请号:US17325124
申请日:2021-05-19
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
摘要: A method that prepares data for analysis includes displaying a user interface that includes a data a data flow pane that displays a flow diagram having a plurality of nodes, each node specifying a respective primary operation, a change list pane corresponding to a user-selected node in the data flow pane, and a data pane that displays a plurality of rows for an intermediate dataset of the user-selected node. The method also includes, in response to receiving a user input to perform a secondary operation at the user-selected node: (i) displaying, in the change list pane, an ordered list of secondary operations performed at the user-selected node, including displaying the secondary operation, and (ii) updating the data pane in accordance with the secondary operation, including updating the plurality of rows for the intermediate dataset.
-
公开(公告)号:US11100097B1
公开(公告)日:2021-08-24
申请号:US16681753
申请日:2019-11-12
发明人: Clark Wildenradt , Arthur Gyldenege
IPC分类号: G06F16/242 , G06F16/22 , G06F16/28
摘要: A method executes at a computing device that includes a display, one or more processors, and memory. The device displays a user interface that includes a data pane and a calculation pane. The data pane comprises data rows and data columns. Each of the data columns corresponds to a data field from a data source. The device receives a first user input to specify a grouping on a first data field. The device receives a second user input to specify an aggregation function on a second data field. In response to the first and second user inputs, for each distinct value of the first data field, the device aggregates corresponding values of the second data field according to the aggregation function. A plurality of first data rows are displayed in the calculation pane. The device saves the rows of data displayed in the calculation pane as a new data source.
-
公开(公告)号:US20210382879A1
公开(公告)日:2021-12-09
申请号:US17409717
申请日:2021-08-23
发明人: Clark Wildenradt , Arthur Gyldenege
IPC分类号: G06F16/242 , G06F16/22 , G06F16/28
摘要: A method executes at a computing device that includes a display. The device displays a user interface that includes a data flow pane and a calculation pane, the data flow pane including a node/link diagram for a data prep flow. A user selects a node in the diagram, and the device populates affordances in the calculation pane according to data fields of a data set associated with the selected node. A first user input specifies grouping on a first data field, and a second user input specifies an aggregation function on a second data field. In response to the user inputs, for each distinct value of the first data field, the device aggregates corresponding values of the second data field according to the aggregation function. Calculated data values are displayed in the calculation pane. The device saves rows of data displayed in the calculation pane as a new data source.
-
公开(公告)号:US10691304B1
公开(公告)日:2020-06-23
申请号:US16167313
申请日:2018-10-22
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
摘要: A method prepares data for analysis. The method displays a user interface, which includes multiple panes, including a data flow pane. The data flow pane includes a flow diagram having multiple nodes, each specifying a primary operation and/or multiple secondary operations. Each primary operation retrieves data from a data source, transforms data, or builds an output data set. When a user selects a node, the user interface displays a change list pane, which is an ordered list of secondary operations performed at the node. When the user provides input to perform a secondary operation at the selected node, the user interface (i) performs the secondary operation, (ii) updates the selected node with an indicator that the node includes secondary operations, (iii) determines a logical ordering for the secondary operation based on the primary operation, and (iv) adds the secondary operation to the change list pane according to the logical ordering.
-
公开(公告)号:US12073065B2
公开(公告)日:2024-08-27
申请号:US17307402
申请日:2021-05-04
发明人: Arthur Gyldenege , Anushka Anand
IPC分类号: G06F3/04845 , G06F3/0482 , G06F40/177
CPC分类号: G06F3/04845 , G06F3/0482 , G06F40/177 , G06F2203/04803
摘要: A computer user interface displays a two-dimensional grid of data values. A user selects a first set of two or more columns of data values from the grid, and the computer performs a first pivot on the first set of two or more columns to form a modified grid having a plurality of new rows and a first set of two or more new columns. The user selects a second set of two or more columns of data values from the grid. The second set is distinct from the first set. The computer performs a second pivot on the second set of two or more columns to form a second new column added to the modified grid. Each data value from the second set of two or more columns is added to the second new column in a respective row of the new rows. The computer redisplays the modified grid.
-
公开(公告)号:US11921979B2
公开(公告)日:2024-03-05
申请号:US17947027
申请日:2022-09-16
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
CPC分类号: G06F3/0482 , G06F3/0484
摘要: A computer system concurrently displays a plurality of panes in a user interface. The panes include a first pane that displays a flow diagram having one or more nodes. Each node contains one or more icons. Each icon represents a respective data transformation operation. The panes include a second pane that displays a plurality of data rows and/or data columns for an intermediate dataset corresponding to a user-selected node. The computer system receives a user input, in the first pane, to perform a first data transformation operation at a selected node. In response to receiving the user input, the computer system performs the first data transformation operation. The computer system displays, in the first pane, an additional icon corresponding to the first data transformation operation at the selected node. The computer system updates the second pane in accordance with the first data transformation operation.
-
公开(公告)号:US11460977B2
公开(公告)日:2022-10-04
申请号:US17325124
申请日:2021-05-19
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
摘要: A method that prepares data for analysis includes displaying a user interface that includes a data a data flow pane that displays a flow diagram having a plurality of nodes, each node specifying a respective primary operation, a change list pane corresponding to a user-selected node in the data flow pane, and a data pane that displays a plurality of rows for an intermediate dataset of the user-selected node. The method also includes, in response to receiving a user input to perform a secondary operation at the user-selected node: (i) displaying, in the change list pane, an ordered list of secondary operations performed at the user-selected node, including displaying the secondary operation, and (ii) updating the data pane in accordance with the secondary operation, including updating the plurality of rows for the intermediate dataset.
-
公开(公告)号:US11061538B2
公开(公告)日:2021-07-13
申请号:US16908700
申请日:2020-06-22
发明人: Anushka Anand , Arthur Gyldenege , Brice Johnson
IPC分类号: G06F3/0482 , G06F3/0484
摘要: A method prepares data for analysis. The method displays a user interface including a data flow pane. The data flow pane includes a flow diagram having a plurality of nodes, each node having an intermediate set and specifying a primary operation. When a user selects a node, the user interface displays a change list pane with an ordered list of secondary operations performed at the node and a data pane with rows from an intermediate dataset of the node. When the user provides input to perform an additional secondary operation at the node, the user interface (i) performs the additional secondary operation, (ii) determines a logical ordering for the additional secondary operation based on the primary operation of the node, (iii) adds the additional secondary operation to the change list pane according to the logical ordering, and (iv) updates the data pane in accordance with the additional secondary operation.
-
-
-
-
-
-
-
-
-