Visually defining multi-row table calculations in a data preparation application

    公开(公告)号:US11698903B2

    公开(公告)日:2023-07-11

    申请号:US17409717

    申请日:2021-08-23

    摘要: 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.

    Data Preparation User Interface with Configurable Process Flow Elements

    公开(公告)号:US20230014484A1

    公开(公告)日:2023-01-19

    申请号:US17947027

    申请日:2022-09-16

    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.

    DATA PREPARATION USER INTERFACE WITH CONGLOMERATE HETEROGENEOUS PROCESS FLOW ELEMENTS

    公开(公告)号:US20210271354A1

    公开(公告)日:2021-09-02

    申请号:US17325124

    申请日:2021-05-19

    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.

    Visually defining multi-row table calculations in a data preparation application

    公开(公告)号:US11100097B1

    公开(公告)日:2021-08-24

    申请号:US16681753

    申请日:2019-11-12

    摘要: 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.

    Visually Defining Multi-Row Table Calculations in a Data Preparation Application

    公开(公告)号:US20210382879A1

    公开(公告)日:2021-12-09

    申请号:US17409717

    申请日:2021-08-23

    摘要: 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.

    Data preparation user interface with conglomerate heterogeneous process flow elements

    公开(公告)号:US10691304B1

    公开(公告)日:2020-06-23

    申请号:US16167313

    申请日:2018-10-22

    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.

    Data preparation user interface with coordinated pivots

    公开(公告)号:US12073065B2

    公开(公告)日:2024-08-27

    申请号:US17307402

    申请日:2021-05-04

    摘要: 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.

    Data preparation user interface with configurable process flow elements

    公开(公告)号:US11921979B2

    公开(公告)日:2024-03-05

    申请号:US17947027

    申请日:2022-09-16

    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.

    Data preparation user interface with conglomerate heterogeneous process flow elements

    公开(公告)号:US11460977B2

    公开(公告)日:2022-10-04

    申请号:US17325124

    申请日:2021-05-19

    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.

    Data preparation user interface with conglomerate heterogeneous process flow elements

    公开(公告)号:US11061538B2

    公开(公告)日:2021-07-13

    申请号:US16908700

    申请日:2020-06-22

    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.