Table creation method and device, computer equipment, storage medium and program product

Abstract

The invention provides a table creation method and device, computer equipment, a storage medium and a program product. The method comprises the steps of displaying a table configuration page in response to a component creation instruction received in a component page of a data table; wherein the table configuration page comprises a field selection list used for configuring rows, columns and values, the field selection list is generated based on the data table and comprises a plurality of fields, and the component page is used for configuring components associated with the data table; receiving first configuration information of a plurality of target fields in the field selection list; generating a table component based on the first configuration information and the field values of the plurality of target fields in the data table; wherein the table component comprises a target row, a target column and a target value corresponding to the plurality of target fields. The data analysis component can be generated based on the data of the data table, and the table data analysis capability is improved.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical field of computer, and particularly relates to a table creation method and device, computer equipment, storage medium and program product. BACKGROUND

[0002] With the continuous development of Internet technology, many work can be completed intelligently. For example, information management can be completed by entering information in a table.

[0003] In the related art, the presentation of a table is usually implemented in units of data.

[0004] However, the present inventors have found that this table presentation method is not convenient for data analysis. SUMMARY

[0005] The present disclosure provides a table creation method and device, computer equipment, storage medium and program product to solve or partially solve the above problems.

[0006] In a first aspect, the present disclosure provides a table creation method, comprising:

[0007] In response to receiving a component creation instruction in a component page of a data table, a table configuration page is displayed; wherein the table configuration page includes a field selection list for configuring rows, columns and values, the field selection list is generated based on the data table and includes a plurality of fields, and the component page is used to configure a component associated with the data table;

[0008] The first configuration information of a plurality of target fields in the field selection list is received.

[0009] A table component is generated based on the first configuration information and the field values of the plurality of target fields in the data table; wherein the table component includes target rows, target columns and target values corresponding to the plurality of target fields.

[0010] In a second aspect, the present disclosure provides a table creation device, comprising:

[0011] The display module is configured to display a table configuration page in response to receiving a component creation instruction in a component page of a data table; wherein the table configuration page includes a field selection list for configuring rows, columns and values, the field selection list is generated based on the data table and includes a plurality of fields, and the component page is used to configure a component associated with the data table.

[0012] The receiving module is configured to receive the first configuration information of a plurality of target fields in the field selection list.

[0013] The generating module is configured to generate a table component based on the first configuration information and field values of the plurality of target fields in the data table, wherein the table component comprises target rows, target columns and target values corresponding to the plurality of target fields.

[0014] In a third aspect, the present disclosure provides a computer device, comprising one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and executed by the one or more processors, and the one or more programs comprise instructions for performing the method of the first aspect.

[0015] In a fourth aspect, the present disclosure provides a non-transitory computer-readable storage medium containing a computer program, which, when executed by one or more processors, causes the one or more processors to perform the method of the first aspect.

[0016] In a fifth aspect, the present disclosure provides a computer program product comprising one or more computer programs, which, when executed by one or more processors, implement the method of the first aspect.

[0017] The table creation method and device, the computer device, the storage medium, and the program product provided by the embodiments of the present disclosure can generate a data analysis component based on data of a data table, and improve the analysis capability of table data. Further, a field selection list is generated based on the data table, and a table component is generated by selecting target fields from the field selection list, so that a table component containing rows, columns and values can be generated based on field information corresponding to the target fields in the data table, without creating an intermediate table of data, thereby improving the table component creation efficiency. BRIEF DESCRIPTION OF DRAWINGS

[0018] In order to more clearly illustrate the technical solutions in the present disclosure or the related art, the following will briefly introduce the drawings needed to be used in the embodiments or the related art descriptions. Obviously, the drawings in the following description are only embodiments of the present disclosure, and for those skilled in the art, other drawings can also be obtained without creative labor based on these drawings.

[0019] Figure 1A A schematic diagram of an exemplary system provided by the embodiments of the present disclosure is shown.

[0020] Figure 1A A schematic diagram of an exemplary data table is shown.

[0021] Figure 2A A schematic diagram of an exemplary configuration page according to the embodiments of the present disclosure is shown.

[0022] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0023] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0024] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0025] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0026] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0027] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0028] Figure 2A Another schematic diagram of an example configuration page according to an embodiment of the present disclosure is shown.

[0029] Figure 3 A schematic diagram of an example chart page according to an embodiment of the present disclosure is shown.

[0030] Figure 4 A flowchart of an example method provided by an embodiment of the present disclosure is shown.

[0031] Figure 5 A hardware structure schematic diagram of an example computer device provided by an embodiment of the present disclosure is shown.

[0032] Figure 6 A schematic diagram of an example apparatus provided by an embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0033] In order to make the purpose, technical solutions and advantages of the present disclosure clearer, the present disclosure is further described in detail below with reference to specific embodiments and the accompanying drawings.

[0034] It should be noted that, unless otherwise defined, technical terms or scientific terms used in the embodiments of the present disclosure shall have the common meaning understood by one of ordinary skill in the art to which the present disclosure pertains. The terms "first", "second", and similar terms used in the embodiments of the present disclosure do not denote any order, quantity, or importance, but are merely used to distinguish different components. The terms "include", "contain", and similar terms mean that the elements or objects before the terms encompass the elements or objects listed after the terms and their equivalents, and do not exclude other elements or objects. The terms "connect" or "connected" or similar terms are not limited to physical or mechanical connections, but can include electrical connections, whether direct or indirect. The terms "upper", "lower", "left", "right", and the like are merely used to represent relative positional relationships, and when the absolute positions of the described objects are changed, the relative positional relationships can also be changed accordingly.

[0035] It can be understood that, before using the technical solutions of the various embodiments of the present disclosure, the user will be informed of the type, scope of use, use scenario, and the like of the personal information involved in a proper manner, and the authorization of the user will be obtained.

[0036] For example, in response to receiving the active request of the user, prompt information is sent to the user to explicitly prompt the user that the operation requested to be performed will require the acquisition and use of personal information of the user. Thus, the user can voluntarily choose whether to provide personal information to the software or hardware, such as an electronic device, an application program, a server, or a storage medium, that performs the operation of the technical solutions of the present disclosure according to the prompt information.

[0037] As an optional but non-limiting implementation manner, in response to accepting the active request of the user, the manner of sending prompt information to the user may, for example, be a pop-up window manner, and the prompt information may, for example, be presented in the form of text in the pop-up window. In addition, the pop-up window may, for example, carry a selection control for the user to select "agree" or "disagree" to provide personal information to the electronic device.

[0038] It can be understood that the above notification and user authorization process is only illustrative, and does not limit the implementation manners of the present disclosure, and other manners that meet the relevant laws and regulations can also be applied to the implementation manners of the present disclosure.

[0039] Figure 1A A schematic diagram of an exemplary system 100 provided by an embodiment of the present disclosure is shown.

[0040] As Figure 1AAs shown, the system 100 can include terminal devices 102A, 102B, a server 106 and a database server 108, for example. The terminal devices 102A, 102B and the server 106 and the database server 108 can include a medium (e.g., a network) that provides a communication link therebetween. The network can include various connection types, such as wired, wireless communication links or fiber optic cables, etc.

[0041] The terminal devices 102A, 102B can have various applications (APPs) or software installed thereon, such as collaborative office applications or software, image processing applications or software, video conferencing applications or software, reading applications or software, video applications or software, social applications or software, payment applications or software, web browsers and instant messaging tools, etc.

[0042] The terminal devices 102A, 102B herein can be hardware or software. When the terminal devices 102A, 102B are hardware, they can be various electronic devices or computer devices with display screens, including but not limited to smartphones, tablet computers, e-book readers, MP3 players, laptops and desktop computers, etc. When the terminal devices 102A, 102B are software, they can be installed in the above-listed electronic devices. They can be implemented as multiple software or software modules (e.g., for providing distributed services) or as a single software or software module. No specific limitation is made herein.

[0043] The server 106 can be a server that provides various services, such as a background server that provides support for various applications or software displayed on the terminal devices 102A, 102B. The database server 108 can also be a database server that provides various services. It can be understood that, in the case where the server 106 can implement the relevant functions of the database server 108, the database server 108 can not be provided in the system 100.

[0044] The server 106 and the database server 108 herein can also be hardware or software. When they are hardware, they can be implemented as a distributed server cluster composed of multiple servers or as a single server. When they are software, they can be implemented as multiple software or software modules (e.g., for providing distributed services) or as a single software or software module. No specific limitation is made herein.

[0045] It should be noted that the table creation method provided by the embodiments of the present disclosure can be executed by the terminal devices 102A, 102B or by the devices in the system 100 to be executed interactively. It should be understood that, Figure 1AThe number of terminal devices, users, servers and database servers in the system is merely illustrative. Any number of terminal devices, users, servers and database servers can be provided according to implementation needs.

[0046] In some example scenarios, the user 104A can create a data table through the collaborative office software or application installed in the terminal device 102A.

[0047] Figure 1B A schematic diagram of an example data table is shown.

[0048] As shown in Figure 1B , for example, the user 104A and / or the user 104B can enter data rows in the data table to record sales information. Each row of data corresponds to a sales record.

[0049] However, the inventors of the present disclosure found that in some scenarios, the user wishes to quickly organize, aggregate and analyze a large amount of data. However, Figure 1B the data table presentation is not convenient for data analysis. In order to perform data analysis on the basis of the data table, Figure 1B the user needs to construct a large number of data intermediate tables through formulas.

[0050] In view of this, a first aspect of the embodiments of the present disclosure provides a table creation method, which can solve or partially solve the above problems to some extent.

[0051] As an example scenario, the user 104A can create and configure a table component using the collaborative office software or application installed in the terminal device 102A. The user 104B can view the table component created and configured by the user 104A using the collaborative office software or application installed in the terminal device 102B.

[0052] For example, in the initial state, the user 104A can open the collaborative office software or application using the terminal device 102A and enter his own workspace. The workspace can include at least one data table created and / or managed by the user 104A. The format of the data table is shown in Figure 1B . In some embodiments, the user 104A can create a visual chart based on the at least one data table. The visual chart can include, for example, a column chart, a pie chart, a line chart, etc. As an optional embodiment, the user 104A finds the table creation function in the chart creation module of the collaborative office software or application (for example, generates component creation instructions by triggering a table creation control) and enters the page 200, as shown in Figure 2AAs shown. The page 200 can be used to create and configure a table component containing rows, columns, and values, and can also be called a table configuration page. Optionally, a table creation function (for example, a table creation control for creating a table component) can also be found in the component page of the data table, and then page 200 can be opened by triggering the table creation function. Among them, the component page can be a page for configuring components associated with the data table, so that the configuration items in page 200 can be generated based on the data table, and the generated table component can also be generated based on the relevant information of the data table. In addition to the table component of the embodiment of the present disclosure, other components can be configured based on the data table on the component page, and these components can also be generated based on the information of the data table, so that the data table can be presented in different forms.

[0053] In some embodiments, as Figure 2A As shown, the table configuration page 200 may include a field selection list 202 for configuring rows, columns, and values. The field selection list 202 may include multiple fields. Optionally, the field selection list 202 may be generated based on a data table, for example, based on Figure 1B In this way, the field selection list 202 is automatically generated based on the data table, so that the table component can be created by using the data already in the data table without the user having to manually add data.

[0054] In some embodiments, as Figure 2A As shown, the table configuration page 200 may further include a data source configuration item 204 and a data range configuration item 206. The data source configuration item 204 may be used to configure the data table used when creating the table component, and the data range configuration item 206 may be used to configure the data range in the data table used when creating the table component.

[0055] Optionally, a drop-down menu can be displayed at the associated position (e.g., below) of the configuration item 204 by triggering the drop-down arrow in the data source configuration item 204, and the drop-down menu can include at least one optional data table option. Optionally, the data table options in the drop-down menu can be generated based on the data tables in the workspace of the user 104A, so that the user 104A can see the options corresponding to the data tables created and / or managed by himself in the drop-down menu, and can select one or more from them as the data source for creating the table component. Optionally, the arrangement order of the data table options in the drop-down menu can be generated based on the arrangement order of the data tables in the workspace of the user 104A, so as to facilitate the user to make a selection. In some embodiments, the data source configuration item 204 can be configured by default to use the data table with the largest number of records (number of rows of data rows) in the workspace of the user 104A as the default data source, so as to better conform to the user's usage habits of using the data analysis function and enhance the user experience. Optionally, if all data tables in the workspace of the user 104A have no data records, the data table ranked first can be selected by default as the default data source.

[0056] In some embodiments, user 104A can create different types of views based on any data table, for example, a table view (see Figure 1B ), Gantt view (presenting all or part of the data in the data table in the form of a Gantt chart), and user 104A can select different data in the data table to create a table view, a Gantt view, etc. Therefore, the options of the data range configuration item 206 can be options corresponding to any view, and the corresponding data range is the range of data used by the corresponding view. In some embodiments, the data range configuration item 206 also includes a filter control, and by triggering the filter control, the user 104A can set the filter condition to set the data range. For example, the filter condition can be "Department is equal to Sales Department 1", thereby limiting the data range to data whose field value of the department field is Sales Department 1.

[0057] In some embodiments, when the user 104A selects the option corresponding to the target data table in the data source configuration item 204, the terminal device 102A may correspondingly receive the second configuration information of the data source configuration item 204, and then determine the target data table (for example, Figure 1B The data table shown in FIG) is the configured data source, and then the field selection list 202 is generated based on the information of the target data table, such as Figure 2A In this way, the field selection list 202 is generated based on the existing fields in the target data table, so that the final generated table component can automatically generate and fill in the corresponding information based on the data in the target data table, without the user having to organize the intermediate data table by himself or build a formula.

[0058] In some embodiments, if the user 104A selects the option corresponding to a specific view or sets a filtering condition in the data range configuration item 206, or sets the data range as the entire data of the target data table, the terminal device 102A can receive the third configuration information of the data range configuration item 206 accordingly, and then determine the data range based on the target data table, and then generate the field selection list 202 in combination with the target data table and the target data range in the target data table, as shown in Figure 2A . In this way, the user 104A can filter the data range of the target data table according to the needs, so that the finally generated table component is more targeted.

[0059] Referring back to Figure 2A , the user 104A can configure the fields included in the table component to be generated based on the field selection list 202. Since the finally generated table component can further include rows, columns and values, the field configuration of the rows, columns and values of the table component can be performed based on the field selection list 202, that is, the corresponding fields in the data table are selected as the rows, columns and / or values in the target table component. Alternatively, as shown in Figure 2A , the arrangement order of the multiple fields in the field selection list 202 can be consistent with the arrangement order of the fields in the data table, so as to be more suitable for user operation and more in line with user habits. In some scenarios, the data table can further include fields such as automatic numbering, attachments and buttons, which are usually not used for data analysis, so these fields can not be presented when the field selection list 202 is generated.

[0060] In some embodiments, as shown in Figure 2A , the table configuration page 200 can further include a first configuration area 208A, a second configuration area 208B and a third configuration area 208C corresponding to the rows, columns and values respectively. The first configuration area 208A is used to configure the rows of the table component, the second configuration area 208B is used to configure the columns of the table component, and the third configuration area 208C is used to configure the values of the table component. When the user 104A configures the rows, columns and / or values, the configured fields can be displayed in the corresponding configuration area, so that the user 104A can intuitively see which row, column and / or value the configured field is configured for, and can make timely adjustments when the configuration is wrong. Alternatively, when no field configuration is performed, the first configuration area 208A, the second configuration area 208B and the third configuration area 208C are in an empty state, and a default picture and / or prompt information (for example, “no field available for calculation”) can be displayed in the configuration area to prompt the user 104A that no field is currently configured.

[0061] In some embodiments, in the default state, the rows, columns and values can be configured based on default rules. Specifically, the first target field, the second target field and the third target field corresponding to the target row, the target column and the target value in the table component can be determined according to the field arrangement order and the field types in the data table, and then the first target field, the second target field and the third target field can be added in the first configuration area 208A, the second configuration area 208B and the third configuration area 208C respectively, so as to realize the default automatic configuration of the fields and improve the configuration efficiency.

[0062] Optionally, determining the first target field, the second target field and the third target field corresponding to the target row, the target column and the target value in the table component according to the field arrangement order and the field types in the data table can further include: determining the first target field, the second target field and the third target field in turn according to the order of row, column and value. Specifically, the first target field, the second target field and the third target field can be determined in turn according to the field arrangement order. The first non-numeric type field can be selected as the first target field corresponding to the row, the second non-numeric type field can be selected as the second target field corresponding to the column, and the first numeric type field can be selected as the third target field corresponding to the value. As a more specific embodiment, the first non-numeric type field and the second non-numeric type field can be determined by matching the field types of the fields in turn according to the field type order. The field type order can be: date type, multi-line text type, single selection type, multi-selection type, result of formula is the above types (i.e. date type, multi-line text type, single selection type, multi-selection type), result of lookup reference is the above types (i.e. date type, multi-line text type, single selection type, multi-selection type). If the above type fields cannot be found after traversing the multiple fields, the index field can be used as the target field.

[0063] Referring to Figure 2A , for example, in the field order shown in Figure 2A , without considering the field type order, the first non-numeric type field is department, the second non-numeric type field is number, and the first numeric type field is sales, so that the department, the number and the sales can be determined as the first target field, the second target field and the third target field respectively. For another example, in the field order shown in Figure 2A , considering the field type order, the first non-numeric type field is sales date, the second non-numeric type field is department, and the first numeric type field is sales, so that the sales date, the department and the sales can be determined as the first target field, the second target field and the third target field respectively.

[0064] In this way, by setting the default rules to determine the first target field, the second target field and the third target field, the configuration efficiency can be improved to a certain extent on the premise of meeting the user demand.

[0065] In some embodiments, as shown in FIG. 2B, the associated position (e.g., left side) of each field in the field selection list 202 is provided with a check box, and the user 104A can select (i.e., generate a selection instruction) the field by checking the check box corresponding to the field. Figure 2A Alternatively, as shown in FIG. 2C, when the fields in the field selection list 202 have been configured as rows, columns and / or values, the check box corresponding to the field in the field selection list 202 is displayed in a checked state, thereby prompting the user that the field has been configured. Figure 2A

[0066] One possible implementation manner can be to sequentially fill the first configuration area 208A, the second configuration area 208B and the third configuration area 208C in the checking order of the user 104A. For example, as shown in FIG. 2D, when the user 104A sequentially checks the department, sales date and sales amount fields, the first configuration area 208A, the second configuration area 208B and the third configuration area 208C can be sequentially filled with the department, sales date and sales amount. Figure 2A Figure 2A In this way, the user 104A can achieve the sequential configuration of rows, columns and values by sequentially checking the fields, and the operation is simple and convenient.

[0067] ​​In some cases, in order to make the fields checked by the user 104A better match with the rows, columns, values, the first configuration area 208A, the second configuration area 208B and / or the third configuration area 208C can also be automatically filled according to the type of the field checked by the user 104A and the field value thereof. Specifically, in some embodiments, in response to the selection instruction of the fourth target field in the field selection list 202, the field type and the field value of the fourth target field can be determined first; in response to the field type of the fourth target field being a numerical type or a formula type and the field value being a number, the fourth target field can be added to the third configuration area 208C; in response to the field type of the fourth target field being a non-numerical type and a non-formula type or the field value of the fourth target field being a non-number, the fourth target field can be added to the first configuration area 208A and / or the second configuration area 208B. In this way, when the field type of the fourth target field is a numerical type or a formula type and the field value is a number (for example, a sales field), it can be added to the third configuration area 208C for configuring the value of the table component. When the field type of the fourth target field is a non-numerical type and a non-formula type or the field value of the fourth target field is a non-number, the fourth target field can be added to the first configuration area 208A and / or the second configuration area 208B for configuring the row and / or column of the table component. In this way, by judging the type and field value of the checked field, the differentiated configuration is realized, which can improve the accuracy of the configuration and improve the user experience.

[0068] In some embodiments, in order to further simplify the operation of the user, the field configuration can also be realized through a drag operation. Specifically, in response to the fifth target field in the field selection list 202 being dragged to the first configuration area 208A, the second configuration area 208B or the third configuration area 208C, the fifth target field is added in the first configuration area 208A, the second configuration area 208B or the third configuration area 208C. For example, taking the fifth target field being a personnel field as an example, the user 104A can drag the personnel field from the field selection list 202 to the first configuration area 208A, and the personnel field can be displayed in the first configuration area 208A, as shown in Figure 2B In this way, the personnel field is configured for the row of the table component through the drag operation, and then the personnel field information can be presented in the table component.

[0069] In some embodiments, the user 104A can also delete the configured field by a drag operation. For example, in response to the first target field being dragged from the first configuration area 208A to outside of the first configuration area 208A (e.g., in the field selection list 202), the first target field can be deleted from the first configuration area 208A, thus facilitating the field deletion. It can be understood that the configured target field (e.g., the second target field, the third target field, the fourth target field, the fifth target field, etc.) can be deleted in the same way, which will not be described herein.

[0070] In some embodiments, the user 104A can also adjust the configured field among rows, columns, and values by a drag operation. Specifically, in response to the first target field being dragged from the first configuration area 208A to the second configuration area 208B or the third configuration area 208C, the first target field is deleted from the first configuration area 208A and added to the second configuration area 208B or the third configuration area 208C. For example, the user 104 drags the department field from the first configuration area 208A to the second configuration area 208B, and the department field is deleted from the first configuration area 208A and added to the second configuration area 208B, as shown in Figure 2C , thus facilitating the adjustment of the configured field among rows, columns, and values by a drag operation. Alternatively, the user 104A can also drag the first target field from the first configuration area 208A to the third configuration area 208C by a similar operation, thus configuring the first target field to the value of the table component. In this case, if the field value corresponding to the first target field is not a number, the summary calculation can be implemented by counting.

[0071] As shown in Figure 2B , when the number of fields in the data table is large, the display area of the field selection list 202 can not be able to display all the selectable fields, thus in some embodiments, the search bar is provided at the associated position (e.g., the top) of the field selection list 202, and the user 104A can search for the field to be configured by inputting the keyword. Alternatively, the search can be a fuzzy search. For example, when “sales” is input, the fields containing “sales” can be searched out, for example, when “a” is searched, the fields containing the letter “a” in the word can be searched out. Alternatively, when the search result includes multiple fields, the order of the fields in the search result is consistent with the order of the fields in the field selection list 202 without searching. Alternatively, the search keyword can be cleared by one key, thus facilitating the user operation. When the search result is empty, the data is empty, and a prompt information (e.g., “no matching result”) can be displayed.

[0072] In some embodiments, as shown in FIG. 2B, the first configuration area 208A, the second configuration area 208B and the third configuration area 208C are further provided with an adding control 2088 respectively, through which the user 104A can add a target field in the corresponding configuration area. Figure 2A

[0073] As an optional implementation, in response to a triggering instruction of the adding control 2088 in the first configuration area 208A or the second configuration area 208B, a field selection menu is displayed at the associated position (e.g., below) of the adding control 2088; wherein the field selection menu includes a plurality of selectable fields, wherein the plurality of selectable fields are generated based on the data table and do not include the fields that have been configured in the first configuration area 208A and the second configuration area 208B (e.g., the department field and the sales date field, for example). Figure 2A As an example, the adding control 2088 is the adding control of the first configuration area 208A or the second configuration area 208B, and the field selection menu does not include the department field and the sales date field); in response to a selection instruction of a sixth target field in the plurality of selectable fields, the sixth target field is added in the first configuration area 208A or the second configuration area 208B. In this way, the flexible configuration of the fields is realized through the adding control 2088, and when the fields are configured in the rows and / or columns, the same field is avoided from being repeatedly added in the rows and / or columns, causing field conflicts.

[0074] As another optional implementation, in response to a triggering instruction of the adding control 2088 in the third configuration area 208C, a field selection menu is displayed at the associated position (e.g., below) of the adding control 2088; wherein the field selection menu includes a plurality of selectable fields, wherein the plurality of selectable fields are generated based on the data table and include all the fields in the field selection list 202; in response to a selection instruction of a seventh target field in the plurality of selectable fields, the seventh target field is added in the third configuration area 208C. In this way, the flexible configuration of the fields is realized through the adding control 2088. At the same time, since some embodiments of the present disclosure support different aggregation calculation methods for values, the same field can be allowed to be configured in the values and different aggregation calculation methods are adopted, so as to be presented in the table component in different aggregation calculation methods, thereby realizing more complex data analysis effects. Related embodiments of the aggregation calculation method will be described in detail later.

[0075] Optionally, similar to the field selection list 202, the selectable fields in the field selection menu can also be searched through a search manner, and the specific implementation manner is similar to that of the field selection list 202, which will not be described here again.​

[0076] like Figure 2B As shown, in some embodiments of the present disclosure, rows, columns, and values ​​can be configured with multiple fields, and then the table component can be presented based on multiple rows, multiple columns, and / or multiple values, further enriching the information that the table component can present, which is conducive to users to perform more complex data analysis. Optionally, the number of fields that rows, columns, and values ​​support configuration can be an upper limit (for example, a maximum of 10 fields), so as to avoid the final generated table component being too complicated. On this basis, when adding or dragging to the corresponding area, if the number of fields configured for the rows, columns, and values ​​corresponding to the area exceeds the upper limit, a prompt message can be displayed, for example, "the row area only supports a maximum of 10 fields."

[0077] Optionally, when adding fields by checking fields, if the checked field is a non-numeric type field or the calculation result of the formula type field is a non-numeric type field, it can be automatically added to the first configuration area 208A first. If the first configuration area 208A reaches the upper limit of the number of fields, it will continue to be added to the second configuration area 208B. If the second configuration area 208B reaches the upper limit of the number of fields, it will continue to be added to the third configuration area 208C. If the third configuration area 208C reaches the upper limit of the number of fields, it will be checked to be disabled (for example, all check boxes are grayed out). When the cursor hovers over the field selection list 202, a prompt message can be displayed, such as "The number of fields in the row, column, and value areas has reached the upper limit and cannot be added." If a numeric type field or a formula type field whose calculation result is a numeric type field is checked, it can be automatically added to the third configuration area 208C first. If the third configuration area 208C reaches the upper limit of the number of fields, it can continue to be added to the first configuration area 208A. If the first configuration area 208A reaches the upper limit of the number of fields, it can continue to be added to the second configuration area 208B. If the second configuration area 208B reaches the upper limit of the number of fields, it will be checked to be disabled (for example, all check boxes are grayed out). When the cursor hovers over the field selection list 202, a prompt message can be displayed, such as "The number of fields in the row, column, and value areas has reached the upper limit and cannot be added."

[0078] In addition to the above configuration methods, other methods can also be used to configure the field. Figure 2B As shown, an operation control (e.g., a drop-down arrow) is also provided at the associated position (e.g., the right side) of each target field. In response to a trigger instruction of the operation control, an operation menu 2082 may be displayed at the associated position (e.g., the lower left side) of the operation control, as shown in FIG. Figure 2D Optionally, the operation menu 2082 may further include a rename option and a remove option.

[0079] The renaming option can be used to rename the target field, so that the field name in the finally generated table component can be named and displayed with the renamed name, so that the user 104A can customize the field name displayed in the table component. In addition to triggering the renaming mechanism through the renaming option, the user 104A can also trigger the renaming mechanism by double-clicking the target field. It can be understood that the field renaming for rows, columns, and values does not rename the field name corresponding to the target field in the data table, avoiding affecting the data information statistics and management, and also does not affect the display of the field in the field selection list 202, avoiding affecting the user's 104A understanding of the actual field. Optionally, if the data table is switched by using the data source configuration item 202, the renaming of the field is reset to the initial state, avoiding mutual influence between data tables. Optionally, if the data table is not switched, the previous renaming result can be retained after the field is unchecked and checked again after renaming, so that the user does not need to perform the renaming operation again. Optionally, for the same data table, the priority of the renaming operation can be the highest, that is, after the user renames a specific field, if the summary calculation method is modified or the field is date grouped, the display of the field name after renaming will not be affected. And for the same data table, the field name after renaming will not be changed if the field is adjusted between rows, columns, and values. Optionally, the number of characters of the renamed name can have an upper limit (for example, 15 Chinese characters), and if the upper limit is exceeded, the name is truncated according to the upper limit value (for example, 16 Chinese characters are input, and the renamed name only includes the first 15 Chinese characters), avoiding that the field name is too long and affects the presentation effect. Optionally, if the user 104A performs a delete operation on the text input during renaming, when it is deleted to blank, the field returns to the original state when the enter key is pressed for saving operation, and the user does not need to input the original name. Optionally, the renamed field in the rows, columns, and values can be renamed with other fields (including the fields in the field selection list 202 and the fields in the configuration area 208A-208C), thereby improving the flexibility of renaming.

[0080] Optionally, the remove option in the operation menu 2082 can be used to remove the target field, and when the user triggers the remove option, the target field is removed from the configuration area, and then will not be used to create a table component.

[0081] Back to Figure 1B It can be seen that the date entered in each row of data in the data table is usually entered in the form of year, month, and day, which will result in that the data can only be counted in units of days. However, the inventors of the present disclosure found that when it is necessary to date group the data in the data table (for example, counting the date in units of weeks, months, and years), it is necessary to complete by writing a formula, which is not convenient for data analysis.

[0082] Thus, in some embodiments, as shown in Figure 2D When the target field is a date type field (e.g., sales date), the operation menu 2082 can further include a date grouping configuration item 2084 for grouping the date type field by date, so as to facilitate data analysis by date grouping.

[0083] Optionally, in response to a triggering instruction (e.g., clicking) of the date grouping configuration item 2084, a grouping selection menu 2086 can be displayed at an associated position (e.g., right side) of the date grouping configuration item 2084, as shown in Figure 2E The grouping selection menu 2086 can further include multiple grouping options for grouping by different date intervals. Further, in response to a selection instruction of a target grouping option (e.g., year-month) in the multiple grouping options, a target grouping field is generated and replaces the target field, as shown in Figure 2F The target grouping field can be the target field + grouping information. For example, if the sales date field is grouped by year-month, the target grouping field can be “sales date-year-month”, and the subsequently generated table component can use a target aggregation method (e.g., summation) to aggregate the multiple values (e.g., sales amount) corresponding to the field of a certain year and month.

[0084] In this way, when the user 104A selects a certain date grouping, the date type field (e.g., sales date) is grouped by the specified grouping (e.g., year-month) to generate a new field (the original field becomes a new date grouping field), so that the table component can be generated based on the new date grouping field and aggregated.

[0085] Exemplarily, when the selected date grouping is year, the date field can be grouped by year, the date field in the configuration area becomes “[date field name]-year”, such as “sales date-year”, and correspondingly, when the target table component is generated, the field value corresponding to the field can be displayed by year, in the format of: [year], for example, “2024”, “2025”, and the like. When the selected date grouping is year-quarter, the date field can be grouped by year-quarter, the date field in the configuration area becomes “[date field name]-year-quarter”, such as “sales date-year-quarter”, and correspondingly, when the target table component is generated, the field value corresponding to the field can be displayed by quarter of the year, in the format of: [year]-[quarter], for example, “2025-Q1”, “2025-Q2”, and the like. When the selected date grouping is year-month, the date field can be grouped by year-month, the date field in the configuration area becomes “[date field name]-year-month”, such as “sales date-year-month”, and correspondingly, when the target table component is generated, the field value corresponding to the field can be displayed by month of the year, in the format of: [year]-[month], for example, “2025-01”, “2025-02”, and the like. When the selected date grouping is year-week, the date field can be grouped by year-week, the date field in the configuration area becomes “[date field name]-week”, such as “sales date-week”, and correspondingly, when the target table component is generated, the field value corresponding to the field can be displayed by week of the year, in the format of: [year]-W[week number]([start date of the week]-[end date of the week]), for example, “2017-W44(10 / 30-11 / 05)”. The calculation logic of the week is that Monday is the first day of a week, the first week of the year is the week in which January 1 of the new year falls, and the week in which December 31 of the old year falls is not counted in the first week of the new year. When the selected date grouping is year-month-day, the date field can be grouped by year-month-day, the date field in the configuration area becomes “[date field name]-year-month-day”, such as “sales date-year-month-day”, and correspondingly, when the target table component is generated, the field value corresponding to the field can be displayed by day of the month of the year, in the format of: [year]-[month]-[day], for example, “2017-10-01”. When the selected date grouping is month-day, the date field can be grouped by month-day, the date field in the configuration area becomes “[date field name]-month-day”, such as “sales date-month-day”, and correspondingly, when the target table component is generated, the field value corresponding to the field can be displayed by day of the month, in the format of: [month]-[day], for example, “10-01”.When the selected date grouping is quarter, the date field can be grouped by quarter, and the date field in the configuration area becomes "[date field name]-quarter", such as "sales date-quarter", and correspondingly, when the target table component is generated, the field value corresponding to this field can be displayed by quarter, and the display format is: [quarter], such as "Q2". When the selected date grouping is month, the date field can be grouped by month, and the date field in the configuration area becomes "[date field name]-month", such as "sales date-month", and correspondingly, when the target table component is generated, the field value corresponding to this field can be displayed by month, and the display format is: [month], where 1-9 are prefixed with 0, such as "01" and "10". When the selected date grouping is week, the date field can be grouped by day of the week, and the date field in the configuration area becomes "[date field name]-week", such as "sales date-week", and correspondingly, when the target table component is generated, the field value corresponding to this field can be displayed by day of the week, and the display format is: [day of the week], such as "Friday" and "Monday". When the user selects no corresponding option, the date grouping can be canceled.

[0086] In some embodiments, when performing the summary calculation, if the date type field is not date grouped, the summary calculation can be performed according to the original value of the data table. If the date grouping is a month-day, quarter, month, week, or week grouping that does not include years, when performing the summary calculation, the values of the data of the selected target data table and its target data range for all years can be summarized and calculated, so that the table component presented can show the overall performance of the data of all years in each month-day, quarter, month, week, and day of the week, achieving more complex data analysis capabilities.

[0087] Optionally, the field name generated automatically by the date grouping can be renamed, thereby improving flexibility. Optionally, after the date grouping has been configured, the user can also switch it to other groupings, further improving configuration flexibility.

[0088] Returning to Figure 1B It can be seen that the number of data rows corresponding to a single field value of some fields can be multiple, for example, the number of data rows corresponding to the sales department in the department field can be multiple, and at this time, when the target row or target column selected in the target table component includes the department field, the corresponding cell in the table component needs to be summarized and calculated based on the target value in multiple data rows. However, the inventors of the present disclosure found that if the target value is to be summarized and calculated, a large number of data intermediate tables need to be constructed through formulas, and the summary calculation method usually only includes summation.

[0089] Therefore, in some embodiments of the present disclosure, various aggregation manners are provided for the user to configure, so that the aggregation calculation can be more flexible, and more complex data analysis capabilities can be achieved.

[0090] In some embodiments, as shown in Figure 2B The third configuration area 208C can include an aggregation control 2090 for configuring the aggregation manner of the value, as shown in

[0091] As a more specific implementation, as shown in Figure 2B The aggregation control 2090 can be displayed at the associated position (e.g., below) of the target field (e.g., the sales field), so that the aggregation manner can be configured only for the target field. In this way, different target fields can select different aggregation manners, thereby achieving more complex data analysis capabilities. In some embodiments, when a target field is added in the third configuration area 208C, the corresponding aggregation control 2090 can be displayed at the associated position of the target field for configuring the aggregation manner for the target field. Optionally, according to the field type of the added target field, the aggregation control 2090 can have a default configuration, thereby improving the configuration efficiency. For example, when the field type of the target field is a numerical type, or the field type of the target field is a formula type and the calculation result is a number, the default configuration of the aggregation control 2090 can be summation, and the aggregation control 2090 can display the word “summation”, so that the user 104A can know that the current aggregation manner is summation. For another example, when the type of the target field is a non-numerical type, the default configuration of the aggregation control 2090 can be count, and the aggregation control 2090 can display the word “count”, so that the user 104A can know that the current aggregation manner is count.

[0092] In some embodiments, as shown in Figure 2B In response to the triggering instruction (e.g., clicking) of the aggregation control 2090, the aggregation menu 2092 can be displayed at the associated position (e.g., left side) of the aggregation control, as shown in Figure 2GThe aggregation menu 2092 includes a plurality of aggregation options in different aggregation manners, which can include summation, counting, count distinct, average, median, maximum, and minimum. In response to a selection instruction of a target aggregation option (e.g., summation option) in the plurality of aggregation options, a target aggregation manner (e.g., summation) corresponding to the target aggregation option is configured for the target field (e.g., sales field) in the third configuration area 208C, so that the target value in the table component is aggregated and calculated according to the target aggregation manner.

[0093] For example, summation can be applied to a numerical type field or a formula type field with a numerical result, and the aggregation calculation logic is summation (sum). In the table component, the format of the corresponding displayed field name is summation: [value field name], for example, summation: sales. Counting can be applied to all field types, and the aggregation calculation logic is counting (count). In the table component, the format of the corresponding displayed field name is counting: [value field name], for example, counting: sales. Count distinct can be applied to all field types, and the aggregation calculation logic is count distinct. In the table component, the format of the corresponding displayed field name is count distinct: [value field name], for example, count distinct: sales. Average can be applied to a numerical type field or a formula type field with a numerical result, and the aggregation calculation logic is average (avg). In the table component, the format of the corresponding displayed field name is average: [value field name], for example, average: sales. Median can be applied to a numerical type field or a formula type field with a numerical result, and the aggregation calculation logic is median. In the table component, the format of the corresponding displayed field name is median: [value field name], for example, median: sales. Maximum can be applied to a numerical type field or a formula type field with a numerical result, and the aggregation calculation logic is maximum (max). In the table component, the format of the corresponding displayed field name is maximum: [value field name], for example, maximum: sales. Minimum can be applied to a numerical type field or a formula type field with a numerical result, and the aggregation calculation logic is minimum (min). In the table component, the format of the corresponding displayed field name is minimum: [value field name], for example, minimum: sales.

[0094] Back to Figure 2AIn some embodiments, page 200 may further include a first area 200A and a second area 200B. First area 200A may be used for configuration. The aforementioned field selection list, first configuration area 208A, second configuration area 208B, third configuration area 208C, data source configuration item 202, data range configuration item 204, etc. may all be set in first area 200A. Second area 200B may be used to display a preview of a table component. After user 104A has configured the table component accordingly, second area 200B may present a preview of the table component.

[0095] For example, Figure 2A As shown, the target fields configured for the current target row, target column, and target value are the department field, sales date field, and sales amount field. The table preview can be filled with the target data table set as the target data range in the first column (reference Figure 1B ) in the target row (e.g., Sales Department 1, Sales Department 2, Sales Department 3). The table preview can be filled with the target data table set as the target data range in the first row (refer to Figure 1B ) in the target column (the target data range includes as many specific sales date field values ​​as the target data table contains, and as many columns as are created in the table component. Figure 2A The cells in the middle area of ​​the table preview can be used to fill in the target data table set as the target data range (see Figure 1B ) in the target data table. For each cell, the row field value and column field value of the target row and target column corresponding to the cell can be determined first, and then, based on the row field value and the column field value, the value field value of the target value corresponding to the row field value and the column field value is searched in the target data table set as the target data range, and then, based on the value field value, the cell is filled. For example, taking the cell in the first column of the row corresponding to Sales Department 1 (i.e., the column corresponding to January 1, 2025) as an example, the row field value (Sales Department 1) and column field value (January 1, 2025) of the target row and target column corresponding to the cell can be determined first, and then, in the target data table set as the target data range, the value field value (specific sales volume) corresponding to the sales field in the data corresponding to Sales Department 1 and January 1, 2025 is found, and then the cell is filled based on the found value field value. Combined with Figure 1BIt can be known that there are many corresponding data of sales, so there can be multiple data corresponding to January 1, 2025, at this time, since the target aggregation mode is summation, the specific sales of these data can be summed up to obtain an aggregated value, and then the aggregated value is used to fill the cell and displayed in the table preview diagram. It can be understood that other cells can be determined in the same way and filled with their corresponding values, which will not be described here.

[0096] In some embodiments, the table preview diagram can be only a schematic diagram, in which the filled field values can be exemplary, so that the user can only see some schematic effects through the table preview diagram, and the generated table component is presented in the chart page. In this way, the calculation resources consumed by the drawing of the preview diagram can be reduced under the premise of ensuring the preview effect.

[0097] In some embodiments, each configuration operation of the user 104A in the first area 200A can trigger the redrawing of the table preview diagram, and the table preview diagram can be updated and displayed in the page 200. As shown in Figure 2B , when the user 104A adds the personnel field as the target row in the first configuration area 208A, the table preview diagram can be updated, in which the second column can display the field value corresponding to the personnel field. As shown in Figure 2C , when the user 104A moves the department field from the first configuration area 208A to the second configuration area 208B, the table preview diagram can be updated again, in which the second row can display the field value corresponding to the department field, and Figure 2B , the first column in the Figure 2B , the second column in the Figure 2C , the first column in the Figure 2F , as shown in , when the user 104A performs date grouping on the sales date field according to year-month, the field value of the first row is displayed as the field value corresponding to the date grouping.

[0098] Figure 2B In some embodiments, when there are multiple fields configured by rows, columns and / or values, the fields can be arranged in order in the table preview diagram according to the field addition order, the field arrangement order in the configuration area, or the preset order. For example, the fields corresponding to the rows include the department field and the personnel field, wherein the department field is added first and the personnel field is added later, and if the addition order is followed, the field value of the department field can be displayed in the first column of the table preview diagram and the field value of the personnel field can be displayed in the second column. In some embodiments, if the fields have a membership relationship, the upper-level field can also be arranged in front. For example, the department field is the upper-level field of the personnel field, and the field value of the department field can be displayed in the first column of the table preview diagram and the field value of the personnel field can be displayed in the second column. Alternatively, as shown in Figure 2BAs shown, if multiple field values of the upper level field have the same value, the cells can be merged and displayed in the center, making the table component more beautiful. In some embodiments, the top of the column corresponding to the row field value can be blank or can display the row field name, as shown in Figure 2A , Figure 2B , Figure 2C As shown, for the columns of the table component, if the fields include multiple, they can also be arranged in the manner described above, and when there are multiple fields, if multiple field values of the upper level have the same value, the cells can be merged and displayed in the center, as shown in Figure 2C As shown, when the target value corresponds to only one field, the field name corresponding to the target value can not be displayed in the table preview, as shown in Figure 2A-C Figure 3 As shown, when the target value corresponds to multiple fields, the value field name (e.g., sum: sales, sum: quantity) can be displayed below the column field value in the table preview, as shown in

[0099] In some embodiments, as shown in Figure 2A , Figure 2B , Figure 2C The last row and the last column of the table preview can be total columns for calculating the total of the values of the corresponding row or column. The total calculation is the same as the calculation of the values in the cells. In this way, the user can further understand the overall data situation through the total information.

[0100] In addition, when there are no corresponding fields for the row, column, and value, the second area can display a table diagram, which only includes the frame diagram of the corresponding area of the row, column, and value, indicating that the fields are not currently configured, and the table diagram can also display prompt information (e.g., “add fields to the corresponding area from the right panel to build the table”). If the row is not empty, the column is empty, and the value is not empty, the table preview can display the row field name and the value field name, and the total of the last column will not be displayed, and the total of the last row can be displayed. If the row is empty, the column has a field, the table preview can display the column field name, the column field value, and the value field name, the total of the last row will not be displayed, and the total of the last column will be displayed.

[0101] In some embodiments, the column width in the table preview defaults to adapt to the content (i.e., to ensure that the longest content in the column can be fully displayed). To avoid extreme length, the longest number of characters that can be supported by the cell (e.g., 256) is used. The part exceeding the length is displayed with an ellipsis (e.g., “...”), and the full content can be displayed by hovering the mouse over the cell. In some embodiments, the user 104A can adjust the column width of the table component in the configuration page 200 by dragging the vertical line to the right of a column in the table preview, or in the table page (refer to Figure 3 ​) in the table component, drag the vertical line on the right side of a column of the table component to adjust the column width. After saving, it will be used as the default column width of the column and will take effect permanently. The modification of the column width is saved but does not trigger collaboration. When user 104B refreshes the table page, the latest column width configured by user 104A can be displayed. Optionally, if user 104A adjusts the column width of a column of the table component on the table page, terminal device 102A can remember the path corresponding to the adjusted column. Even if the data is updated, the column width of the column will be displayed according to the column width manually set by user 104A, thereby improving the user experience.

[0102] Optionally, when viewing a table component, user 104B can Figure 3 ) Drag the vertical line on the right side of a column to adjust the width, and it will take effect immediately. However, the column width data is temporarily saved. If user 104B refreshes the page, the default state will be restored, that is, the column width configured by user 104A.

[0103] In some embodiments, the table preview may further include a horizontal scroll bar and a vertical scroll bar, so that when there is a lot of data, the undisplayed portion can be viewed through the scroll bars.

[0104] Based on the above embodiment, by displaying a table preview during the configuration process, the user 104A can view the effect of the final generated table component at any time, so as to change the configuration at any time in order to generate a table component that better meets the requirements.

[0105] In some embodiments, assuming that the user 104A completes the configuration of the field configuration items corresponding to the field selection list 202, a table component can be generated based on the existing configuration information (first configuration information). Figure 2B As shown, page 200 includes a confirmation button 212, and user 104A triggering (for example, clicking) the confirmation button 212 can trigger the process of generating a table component. Specifically, in response to receiving the confirmation instruction, the terminal device 102A can receive the first configuration information of multiple target fields in the field selection list 202, and then generate a table component based on the first configuration information and the field values ​​of the multiple target fields in the data table; wherein, the table component includes target rows, target columns and target values ​​corresponding to the multiple target fields. In this way, based on the target field selected from the field selection list 202 to generate a table component containing rows, columns, and values, it is possible to generate a table component containing rows, columns, and values ​​based on the field information corresponding to the target field in the data table, without creating a data intermediate table, thereby improving the efficiency of creating the table component. Moreover, based on the table component, more complex data analysis can be performed, further improving the user's work efficiency.

[0106] In some embodiments, receiving first configuration information for multiple target fields in the field selection list may further include: determining the first configuration information based on the multiple target fields configured in the first configuration area 208A, the second configuration area 208B, and the third configuration area 208C. In this way, the first configuration information corresponding to the target row, target column, and target value can be determined based on the configuration information in the first configuration area 208A, the second configuration area 208B, and the third configuration area 208C, thereby completing the generation of the table component. It will be understood that the method of configuring the rows, columns, and values ​​of the table component using the first configuration area 208A, the second configuration area 208B, and the third configuration area 208C is merely exemplary. When other methods are used to configure the rows, columns, and values ​​of the table component, the first configuration information can be determined based on the other configuration method.

[0107] In some embodiments, based on the amount of data corresponding to the target data table within the target data range configured by user 104A, terminal device 104A may send a data request to server 106 based on a component creation request. Server 106 or database server 108 performs data calculations based on the data request, and terminal device 104A returns the data calculation results to generate a table component. When a calculation failure occurs, a split image (a cracked image) and a prompt message (e.g., "Drawing failed, cell limit exceeded") may be displayed on table page 300 or in second area 200B of configuration page 200. When user 104A is on configuration page 200, a corresponding prompt message (e.g., "The cell limit has been exceeded, please reduce the number of fields or narrow the data range") may be displayed at the top of page 200. In some embodiments, when the amount of data returned by server 106 exceeds the corresponding upper limit for drawing, the table preview and table component may be drawn according to the upper limit, and the data exceeding the upper limit will not be displayed. However, the summary calculation is still based on the original data, ensuring both display quality and data accuracy. When the user 104A is in the configuration page 200 , corresponding prompt information (eg, “Too many cells, only 10,000 cells are currently displayed”) may be displayed at the top of the page 200 .

[0108] Figure 3 A schematic diagram of an exemplary chart page 300 according to an embodiment of the present disclosure is shown.

[0109] like Figure 3 As shown, in some embodiments, when the user 104A clicks the OK button 212, the terminal device 102A generates the table component 302 and can display the table component 302 in the chart page 300. Figure 3As shown, the table component 302 can include multiple rows corresponding to the department field and the person field, multiple columns corresponding to the sales date-year-month field (date grouping field), and multiple cells corresponding to the sales amount field and the quantity field. These fields in the table component 302 can be considered as target fields configured based on the configuration page 200, the multiple rows can be target rows, the multiple columns can be target columns, and the values in the multiple cells can be target values. In addition, the table component 302 can present different contents according to different configured target fields, so that the user can configure the table component according to the needs, and then present the table component that meets the needs.

[0110] In some embodiments, as Figure 3 shown, the chart page 300 can also include other chart components (e.g., bar chart, line chart) created or viewable by the user 104A, and the positions, sizes, etc. of the chart components in the page 300 can be adjusted so that the page 300 is more in line with the user's usage habits. Alternatively, these chart components can also be configured and generated through the corresponding component creation controls in the component page of the data table. In other words, the component page of the data table can implement a variety of component configurations to meet the user's diversified data analysis needs.

[0111] Alternatively, as Figure 3 shown, the table component 302 can include multiple cells corresponding to the target values, and the value field values or summary values in the cells corresponding to the target values in the table component 302 can be implemented based on the aforementioned value filling manner for the table preview. Specifically, in some embodiments, for each of the cells, the following operations can be performed: determining the row field value and the column field value of the cell corresponding to the target row and the target column; based on the row field value and the column field value, searching for the value field values of the target values corresponding to the row field value and the column field value in the data table; and based on the value field values, filling the cell. At this time, when the number of found value field values is one, the value field value can be directly used to fill the cell.

[0112] In some embodiments, when the number of value field values is multiple, based on the value field values, filling the cell can further include: based on a target summary manner, performing summary calculation on the multiple value field values to obtain a summary value; and using the summary value to fill the cell. The target summary manner includes sum, count, de-duplication count, average, median, maximum, or minimum. In this way, when the number of found value field values is multiple, summary calculation can be performed based on multiple data, and the summary calculation can be performed according to the target summary manner configured by the user.

[0113] For example, taking the first cell with a value as an example, the corresponding row field value is Zhang Da of sales one, the column field value is January 2025 (the field is a date grouping field), and the corresponding value field name is the sum: sales. In the target data table set as the target data range, at least one target data can be found based on the row field value and the column field value, and the value field value corresponding to the sales can be found in the at least one target data. If the number of the at least one target data is one, the value field value is filled into the cell. If the number of the at least one target data is more than one, the sum can be calculated and the summary value is filled into the cell.

[0114] It can be understood that when no data record can be found, the cell has no value to be filled in, and therefore, the cell in the table component 302 can be displayed as empty. In some cases, the data in the data source can be set as invisible, and therefore, even if the data can be found, it cannot be displayed in the table component 302.

[0115] In some embodiments, when any value field value corresponding to a cell in the table component 302 is updated, the cell can be filled based on the updated value field value. For example, when the cell is directly filled with the value field value, the update is directly performed, and when the cell is filled based on a summary value, the summary value can be recalculated based on the updated value field value and the cell is filled. In this way, even if the data in the data table is updated, the data in the table component 302 can be updated synchronously without manual modification by the user.

[0116] In some embodiments, when the cursor is hovered over a cell in the value area of the table component 302, the detailed data corresponding to the cell can also be displayed, so that the user can obtain more information from the table component 302. The detailed data is found in a manner similar to that of finding the data when filling in the value in the cell, and will not be described herein again.

[0117] Optionally, as shown in Figure 3 The associated position (for example, the upper right corner) of the table component 302 is also provided with an operation control 304. By triggering the operation control 304, an operation menu can be displayed, and the operation menu can include configuration, rename, title setting, copy, copy to, delete and the like. The options are used to operate the table component 302. When the configuration option is triggered, the table configuration page 200 can be displayed again, so that the user 104A can continue to configure, and then the table component is regenerated based on the new configuration. The update configuration is similar to the foregoing embodiments and will not be described herein again.

[0118] Returning to Figure 2BIn some embodiments, the table configuration page 200 further includes a sorting condition configuration item 210 for configuring the sorting order of the field values ​​in the table component 302, so that the user 104A can configure the sorting order so that the table component 302 is presented in the desired arrangement. Specifically, in response to a trigger instruction of the sorting condition configuration item 210, a condition configuration window 2102 may be displayed at a location associated with the sorting condition configuration item 210 (e.g., above the top). Figure 2H As shown. Figure 2H As shown, the condition configuration window 2102 may include a sort field configuration item, a sort basis configuration item, and a sort mode configuration item. The sort field configuration item includes multiple field options corresponding to the multiple target fields. The target sort field can be selected in the drop-down menu. The sort basis configuration item includes at least one basis option corresponding to the target value (for example, Figure 3 For example, the basis can be based on sales or sales volume), or you can select the target sorting basis in the drop-down menu. The sorting method includes ascending order and descending order options, which can be selected directly. Figure 2H As shown, in the initial state, the condition configuration window 2102 may not include a sort field configuration item, a sort basis configuration item, and a sort method configuration item, but only include a configuration control 2104. When the user 104A triggers the control 2104, a row of sort field configuration items, sort basis configuration items, and sort method configuration items may be displayed, such as Figure 2H As shown. Then, the user 104A can make configurations based on the displayed sorting field configuration item, sorting basis configuration item and sorting mode configuration item. After the configuration is completed, clicking the Apply button can generate the corresponding target sorting condition as the fourth configuration information. At this time, the terminal device 102A receives the fourth configuration information of the sorting field configuration item, the sorting basis configuration item and the sorting mode configuration item; wherein, the fourth configuration information includes the target sorting condition, and the target sorting condition includes the target sorting field, the target sorting basis and the target sorting mode; then, based on the target sorting basis (for example, sales), the target sorting field (for example, department field) in the table component 302 can be sorted according to the target sorting mode (for example, positive order). Finally, the table component 302 can be displayed based on the sorted field value, so that the field value in the table component 302 can be sorted based on the configured sorting condition.

[0119] In some embodiments, if the sorting is based on a value field, it means that the sorting can be based on the total value of the value field. Specifically, if the sorting field is a row field, the sorting is based on the data in the total column (the last column of the table component 302) of the value field. Conversely, if the sorting field is a column field, the sorting is based on the data in the total row (the last row of the table component 302) of the value field. The sorting in ascending order and descending order can be based on the pinyin or alphabetical order of the text, for example, the ascending order corresponds to "A->Z" and the descending order corresponds to "Z->A". For numerical values or dates, the ascending order corresponds to "0->9" and the descending order corresponds to "9->0".

[0120] Reference Figure 2H As shown, it can be understood that the user 104A can generate multiple configuration items and configure different sorting conditions by continuously triggering the configuration control 2104, so that the final sorting condition can have multiple sorting conditions.

[0121] Specifically, when the user 104A clicks the configuration control 2104, a configuration item of the sorting condition is added under the existing sorting condition. The drop-down menu of the sorting field configuration item can display the fields in the row and column fields that are not involved in sorting. The priority order of field selection is: the first row field > the second row field >... > the Nth row field > the first column field > the second column field >... > the Nth column field. When all row and column fields have been involved in sorting, the configuration control 2104 is no longer displayed.

[0122] When the sorting condition corresponds to multiple row fields or multiple column fields, the sorting condition can be matched according to the arrangement order of the row fields or column fields in the table component 302. Specifically, the sorting condition can be executed in order according to the order of the sorting effective fields: the first row field > the second row field >... > the Nth row field > the first column field > the second column field >... > the Nth column field. When a field has a superior field, it is only sorted internally. For example, Figure 3 For example, the sales department 1, 2 and 3 can be sorted based on the total sales of the corresponding departments, and then the personnel in the sales department 1 can be sorted according to their respective total sales in the sales department 1, without being mixed with the personnel in the sales department 2 and 3. The row field and the value field are the same. Of course, if the sorting basis of the personnel is not the sales but the personnel name, the internal sorting can be performed in the order of the ascending order corresponding to "A->Z" and the descending order corresponding to "Z->A".

[0123] As can be seen from the above embodiments, the table creation method provided by the embodiments of the present disclosure generates a field selection list based on a data table, generates a table component by selecting a target field from the field selection list, and can generate a table component containing rows, columns and values based on field information corresponding to the target field in the data table, without creating an intermediate data table, thereby improving the table component creation efficiency. The generated table component can serve as a powerful data analysis tool to help users quickly organize, aggregate and analyze a large amount of data. In some embodiments, by dragging and recombining data fields, users can dynamically adjust the display mode of the data, view the aggregation results of the data under different dimensions, and compare the performance of different dimensions. In some embodiments, the table creation method provided by the embodiments of the present disclosure supports date grouping, which can be grouped by years, year-months, year-month-days, months, etc. without the need for users to group dates by writing formulas. In some embodiments, the table creation method provided by the embodiments of the present disclosure supports sorting of field text and numerical values of row and column fields, and some embodiments also support different value aggregation calculation methods such as counting, de-duplication counting, median, etc., further enriching the data analysis capabilities.

[0124] It should be noted that the method of the embodiments of the present disclosure can be executed by a single device, such as a computer or a server, etc. The method of the present embodiment can also be applied to a distributed scenario, and completed by multiple devices cooperating with each other. In this distributed scenario, one of the multiple devices can only execute one or more steps in the method of the embodiments of the present disclosure, and the multiple devices can interact with each other to complete the method.

[0125] It should be noted that some embodiments of the present disclosure have been described above. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be performed in a different order than the order described above and still achieve desirable results. In addition, the processes depicted in the figures do not necessarily require the particular order shown, or sequential order, to achieve the desired results. In certain implementations, multitasking and parallel processing can be advantageous.

[0126] Figure 4 A flowchart of an exemplary table creation method 400 provided by the embodiments of the present disclosure is shown. The method 400 can be used to configure a template. Alternatively, the method 400 can be implemented by the terminal device 102A of Figure 1A , or can be implemented by interaction of devices in the system 100 of Figure 1A .

[0127] As shown in Figure 4 , the method 400 can further include the following steps.

[0128] At step 402, in response to receiving a component creation instruction in a component page of a data table, a table configuration page (e.g., the page 200 of FIG. 2) is displayed. Figures 2A-H

[0129] As an optional embodiment, a table creation function (e.g., a table creation control for creating a table component) can be found in a component page of the data table, and the table configuration page can be opened by triggering the table creation function. The component page can be a page for configuring components associated with the data table, so that the configuration items in the table configuration page can be generated based on the data table, and the generated table component can also be generated based on the information of the data table. In addition to the table component of the embodiments of the present disclosure, other components can also be configured in the component page based on the data table, and these components can also be generated based on the information of the data table, so that different forms of presentation of the data table can be performed.

[0130] The table configuration page can include a field selection list (e.g., the field selection list 202 of FIG. 2) for configuring rows, columns, and values, and the field selection list is generated based on the data table (e.g., the data table of FIG. 2) and includes a plurality of fields. In this way, the field selection list is automatically generated based on the data table, so that the table component can be created by using the existing data in the data table without manual addition of data by the user. Figures 2A-H Figure 1B In some embodiments, the table configuration page further includes a data source configuration item (e.g., the data source configuration item 204 of FIG. 2) and / or a data range configuration item (e.g., the data range configuration item 206 of FIG. 2).

[0131] In some embodiments, the table configuration page further includes a data source configuration item (e.g., the data source configuration item 204 of FIG. 2) and / or a data range configuration item (e.g., the data range configuration item 206 of FIG. 2). Figures 2A-H Figures 2A-H The method further includes:

[0132] receiving second configuration information of the data source configuration item and / or third configuration information of the data range configuration item;

[0133] determining a target data table and / or a target data range in the target data table based on the second configuration information and / or the third configuration information;

[0134] generating the field selection list based on the target data table and / or the target data range.

[0135] generating the field selection list based on the target data table and / or the target data range.

[0136] ​​​Optionally, a drop-down menu can be displayed in the associated position (e.g., below) of the data source configuration item by triggering the drop-down arrow in the data source configuration item, and the drop-down menu can include at least one selectable data table option. Optionally, the data table options in the drop-down menu can be generated based on the data tables in the user's workspace, so that the user can see the options corresponding to the data tables created and / or managed by the user in the drop-down menu, and can select one or more of them as the data source for creating the table component. Optionally, the arrangement order of the data table options in the drop-down menu can be generated according to the arrangement order of the data tables in the user's workspace, so as to facilitate the user's selection. In some embodiments, the data source configuration item can be configured to use the data table with the largest number of records (number of rows of data rows) in the user's workspace as the default data source in the default state, so as to be more in line with the user's usage habits of using the data analysis function and improve the user experience. Optionally, if all the data tables in the user's workspace have no data records, the data table ranked first can be selected as the default data source by default.

[0137] In some embodiments, the user can create different types of views based on any data table, such as a table view, a Gantt view (to present all or part of the data in the data table in a Gantt chart), and the user can select different data in the data table to create a table view, a Gantt view, etc. Therefore, the options of the data range configuration item can be the options corresponding to any view, and the corresponding data range is the range of data used by the corresponding view. In some embodiments, the data range configuration item further includes a filtering control. By triggering the filtering control, the user can set a filtering condition to set the data range. For example, the filtering condition can be "department equals sales department 1", so as to limit the data range to the data whose field value of the department field is sales department 1.

[0138] In some embodiments, when the user selects the option corresponding to the target data table in the data source configuration item, the terminal device can accordingly receive the second configuration information of the data source configuration item, and then determine that the target data table is the configured data source, and then generate the field selection list based on the information of the target data table. In this way, the field selection list is generated based on the existing fields in the target data table, so that the final generated table component can automatically generate and fill in the corresponding information based on the data in the target data table, without the user having to arrange the intermediate data table by himself / herself or build a formula.

[0139] In some embodiments, if the user selects the option corresponding to a specific view in the data range configuration item or sets a filtering condition, or sets the data range as all data of the target data table, the terminal device can receive third configuration information of the data range configuration item accordingly, and then determine the data range based on the target data table, and further generate the field selection list in combination with the target data table and the target data range in the target data table. In this way, the user can filter the data range of the target data table according to the needs, so that the finally generated table component is more targeted.

[0140] In some embodiments, the table configuration page further includes a first configuration area (for example, the first configuration area 208A of Figures 2A-H ), a second configuration area (for example, the second configuration area 208B of Figures 2A-H ) and a third configuration area (for example, the third configuration area 208C of Figures 2A-H ) corresponding to the row, the column and the value respectively. Optionally, when the user configures the row, the column and / or the value, the configured fields can be displayed in the corresponding configuration area, so that the user can intuitively see which one or more of the row, the column and the value the configured fields are configured for, and can make timely adjustments when the configuration is wrong.

[0141] In some embodiments, the method further includes: determining first target fields, second target fields and third target fields corresponding to the target row, the target column and the target value according to the field arrangement order and the field type in the data table; and adding the first target fields, the second target fields and the third target fields in the first configuration area, the second configuration area and the third configuration area respectively, so as to realize the default automatic configuration of the fields and improve the configuration efficiency, as shown in Figure 2A . In this way, by setting the default rules to determine the first target fields, the second target fields and the third target fields, the configuration efficiency can be improved to a certain extent under the premise of meeting the user's needs.

[0142] In some embodiments, the method further includes:

[0143] In response to a selection instruction of a fourth target field in the field selection list, determining the field type and the field value of the fourth target field;

[0144] In response to the field type of the fourth target field being a numerical type or a formula type and the field value being a number, adding the fourth target field to the third configuration area;

[0145] In response to the field type of the fourth target field being a non-numeric type and a non-formula type or the field value of the fourth target field being a non-numeric, the fourth target field is added to the first configuration area and / or the second configuration area.

[0146] In this way, by judging the type and field value of the checked field, the differentiated configuration is realized, which can improve the accuracy of the configuration and enhance the user experience.

[0147] In some embodiments, the method further includes, in response to a fifth target field in the field selection list being dragged to the first configuration area, the second configuration area, or the third configuration area, adding the fifth target field in the first configuration area, the second configuration area, or the third configuration area. In this way, the target field is configured for the row of the table component through the dragging operation, which is more convenient to operate.

[0148] In some embodiments, the method further includes, in response to the first target field being dragged from the first configuration area to the second configuration area or the third configuration area, deleting the first target field from the first configuration area and adding the first target field in the second configuration area or the third configuration area, thereby conveniently realizing the adjustment of the configured field among the row, the column, and the value through the dragging operation.

[0149] In some embodiments, the operation control of the associated position of the target field is set (refer to the drop-down arrow on the right side of the target field in Figures 2A-H );

[0150] The method further includes:

[0151] In response to the triggering instruction of the operation control, an operation menu (for example, the operation menu 2082 in Figure 2D , Figure 2E ) is displayed at the associated position of the operation control; wherein when the target field is a date type field, the operation menu includes a date grouping configuration item (for example, the date grouping configuration item 2084 in Figure 2E );

[0152] In response to the triggering instruction of the date grouping configuration item, a grouping selection menu (for example, the grouping selection menu 2086 in Figure 2E ) is displayed at the associated position of the date grouping configuration item; wherein the grouping selection menu includes a plurality of grouping options for grouping according to different date intervals;

[0153] In response to the selection instruction of a target grouping option in the plurality of grouping options, a target grouping field is generated and the target grouping field is used to replace the target field, as shown in Figure 2F .

[0154] In this way, when a user selects a date grouping, the date type field (e.g., the sales date) is grouped according to the specified grouping (e.g., year-month) to generate a new field (the original field becomes a new date grouping field), so that a table component can be generated based on the new date grouping field and summary calculation can be performed.

[0155] In some embodiments, the third configuration area includes a summary control (e.g., the summary control 2090 in the third configuration area 2003) for configuring a summary manner. Figures 2A-D

[0156] The method further includes:

[0157] In response to a triggering instruction of the summary control, displaying a summary menu at an associated position of the summary control; wherein the summary menu includes a plurality of summary options in different summary manners.

[0158] In response to a selection instruction of a target summary option in the plurality of summary options, configuring the target field in the third configuration area with a target summary manner corresponding to the target summary option, so that the target value in the table component is summarized according to the target summary manner.

[0159] In this way, by providing multiple summary manners for user configuration, the summary calculation of the table component can be more flexible, and more complex data analysis capabilities can be achieved.

[0160] At step 404, first configuration information of a plurality of target fields in the field selection list is received.

[0161] In some embodiments, receiving the first configuration information of the plurality of target fields in the field selection list includes determining the first configuration information according to the plurality of target fields configured in the first configuration area, the second configuration area, and the third configuration area. In this way, the first configuration information corresponding to the target row, the target column, and the target value can be determined according to the configuration information in the first configuration area, the second configuration area, and the third configuration area, and the generation of the table component can be completed. It can be understood that the way of configuring the row, the column, and the value of the table component by using the first configuration area, the second configuration area, and the third configuration area is only exemplary, and when other ways are used to configure the row, the column, and the value of the table component, the first configuration information can be determined based on the other configuration manner.

[0162] At step 406, a table component is generated based on the first configuration information and field values of the plurality of target fields in the data table; wherein the table component includes a target row, a target column, and a target value corresponding to the plurality of target fields.​

[0163] The table creation method provided by the embodiments of the present disclosure generates a field selection list based on a data table, generates a table component by selecting a target field from the field selection list, and can generate a table component containing rows, columns and values based on field information corresponding to the target field in the data table, without creating an intermediate data table, thereby improving the table component creation efficiency.

[0164] In some embodiments, the table component (e.g., the table component 302 of the table component 300) includes a plurality of cells corresponding to the target values; Figure 3

[0165] Based on the first configuration information and the field values of the plurality of target fields in the data table, generating a table component, including:

[0166] For each of the cells, the following operations are performed:

[0167] Determining the row field value and the column field value of the cell corresponding to the target row and the target column;

[0168] Based on the row field value and the column field value, searching for the value field value of the target value corresponding to the row field value and the column field value in the data table;

[0169] Based on the value field value, filling the cell.

[0170] At this time, when the number of found value field values is one, the value field value can be directly used to fill the cell.

[0171] In some embodiments, the number of value field values is a plurality;

[0172] Based on the value field value, filling the cell, including:

[0173] Based on a target summary method, performing summary calculation on the plurality of value field values to obtain a summary value;

[0174] Filling the cell with the summary value;

[0175] The target summary method includes summation, counting, de-duplication counting, average value, median, maximum value or minimum value.

[0176] In this way, when the number of found value field values is a plurality, summary calculation can be performed based on a plurality of data, and summary calculation can be performed according to the target summary method configured by the user.

[0177] ​In some embodiments, the method further includes: in response to the value field value being updated, populating the cell based on the updated value field value. For example, when the cell is populated directly with the value field value, the update is performed directly; when the cell is populated based on a summary value, the summary value can be recalculated based on the updated value field value and the cell is populated. In this way, even if the data in the data table is updated, the data of the table component can be updated synchronously without the user manually modifying.

[0178] In some embodiments, the table configuration page further includes a sorting condition configuration item (for example, the sorting condition configuration item 210 of FIG. 2B). Figures 2A-H

[0179] The method further includes:

[0180] In response to the triggering instruction of the sorting condition configuration item, displaying a condition configuration window (for example, the condition configuration window 2102 of FIG. 2B) at the associated position of the sorting condition configuration item; wherein the condition configuration window includes a sorting field configuration item, a sorting basis configuration item, and a sorting manner configuration item, the sorting field configuration item includes a plurality of field options corresponding to the plurality of target fields, the sorting basis configuration item includes at least one basis option corresponding to the target value, and the sorting manner includes a positive order option and a reverse order option. Figure 2H

[0181] Receiving fourth configuration information of the sorting field configuration item, the sorting basis configuration item, and the sorting manner configuration item; wherein the fourth configuration information includes a target sorting field, a target sorting basis, and a target sorting manner.

[0182] Based on the target sorting basis, sorting the target sorting field in the table component in the target sorting manner.

[0183] In this way, by setting the sorting condition, the sorting of the field values in the table component can be realized, and the data analysis capability can be further enriched.

[0184] It should be noted that the method of the embodiments of the present disclosure can be executed by a single device, such as a computer or a server. The method of the embodiments can also be applied to a distributed scenario, and be completed by multiple devices cooperating with each other. In the distributed scenario, one of the multiple devices can only execute one or more steps in the method of the embodiments of the present disclosure, and the multiple devices can interact with each other to complete the method.

[0185] ​​It is noted that some embodiments of the present disclosure have been described. Other embodiments are within the scope of the appended claims. In some cases, actions or steps recited in the claims can be performed in an order other than that described above and still achieve desirable results. Additionally, the process depicted in the figures can not necessarily require the particular order shown or sequential order to achieve the desired results. In certain implementations, multitasking and parallel processing can be advantageous or necessary.

[0186] The embodiments of the present disclosure further provide a computer device for implementing the table creation method described above. Figure 5 A hardware structure schematic diagram of an exemplary computer device 500 provided by the embodiments of the present disclosure is shown. The computer device 500 can be used to implement the server 106, and can also be used to implement the terminal device 102A, 102B. In some scenarios, the computer device 500 can also be used to implement the database server 108. Figure 1A Figure 1A The computer device 500 can be used to implement the server 106, and can also be used to implement the terminal device 102A, 102B. In some scenarios, the computer device 500 can also be used to implement the database server 108. Figure 1A

[0187] As shown in Figure 5 , the computer device 500 can include a processor 502, a memory 504, a network interface 506, a peripheral interface 508, and a bus 510. Among them, the processor 502, the memory 504, the network interface 506, and the peripheral interface 508 are connected to each other through the bus 510 for internal communication connection in the computer device 500.

[0188] The processor 502 can be a central processing unit (CPU), an image processor, a neural network processor (NPU), a microcontroller (MCU), a programmable logic device, a digital signal processor (DSP), an application specific integrated circuit (ASIC), or one or more integrated circuits. The processor 502 can be used to perform functions related to the technologies described in the present disclosure. In some embodiments, the processor 502 can also include multiple processors integrated as a single logical component. For example, as shown in Figure 5 , the processor 502 can include multiple processors 502a, 502b, and 502c.

[0189] The memory 504 can be configured to store data (e.g., instructions, computer code, etc.). As Figure 5 ​​As shown, the data stored by the memory 504 can include program instructions (e.g., one or more programs for implementing the table creation method of the embodiments of the present disclosure) and data to be processed (e.g., the memory can store configuration files of other modules, etc.). The processor 502 can also access the program instructions and data stored by the memory 504, and execute the program instructions to operate on the data to be processed. The memory 504 can include volatile storage or non-volatile storage. In some embodiments, the memory 504 can include random access memory (RAM), read only memory (ROM), optical disk, magnetic disk, hard disk, solid state disk (SSD), flash memory, memory stick, etc.

[0190] The network interface 506 can be configured to provide communication with other external devices to the computer device 500 via a network. The network can be any wired or wireless network capable of transmitting and receiving data. For example, the network can be a wired network, a local wireless network (e.g., Bluetooth, WiFi, near field communication (NFC), etc.), a cellular network, the Internet, or a combination thereof. It can be understood that the type of network is not limited to the specific examples described above.

[0191] The peripheral interface 508 can be configured to connect the computer device 500 with one or more peripheral devices to enable information input and output. For example, the peripheral devices can include input devices such as keyboards, mice, touchpads, touchscreens, microphones, various sensors, etc., and output devices such as displays, speakers, vibrators, indicator lights, etc.

[0192] The bus 510 can be configured to transmit information between various components (e.g., the processor 502, the memory 504, the network interface 506, and the peripheral interface 508) of the computer device 500, such as an internal bus (e.g., a processor-memory bus), an external bus (a USB port, a PCI-E bus), etc.

[0193] It should be noted that although the architecture of the computer device 500 described above only shows the processor 502, the memory 504, the network interface 506, the peripheral interface 508, and the bus 510, in actual implementation, the architecture of the computer device 500 can also include other components necessary for normal operation. In addition, those skilled in the art can understand that the architecture of the computer device 500 described above can also only include components necessary for implementing the embodiments of the present disclosure, and does not necessarily include all the components shown in the figure.

[0194] The embodiments of the present disclosure also provide a table creation device. Figure 6 A schematic diagram of an exemplary device 600 provided by the embodiments of the present disclosure is shown. As shown, the device 600 can be used to implement the table creation method, and can further include the following modules. Figure 6 As shown, the device 600 can be used to implement the table creation method, and can further include the following modules.

[0195] The display module 602 is configured to display a table configuration page in response to receiving a component creation instruction in a component page of a data table, wherein the table configuration page includes a field selection list for configuring rows, columns and values, the field selection list is generated based on the data table and includes a plurality of fields, and the component page is used for configuring a component associated with the data table.

[0196] The receiving module 604 is configured to receive first configuration information of a plurality of target fields in the field selection list.

[0197] The generating module 606 is configured to generate a table component based on the first configuration information and field values of the plurality of target fields in the data table, wherein the table component includes target rows, target columns and target values corresponding to the plurality of target fields.

[0198] In some embodiments, the table configuration page further includes a data source configuration item and / or a data range configuration item.

[0199] The receiving module 604 is configured to receive second configuration information of the data source configuration item and / or third configuration information of the data range configuration item, determine a target data table and / or a target data range in the target data table based on the second configuration information and / or the third configuration information, and generate the field selection list based on the target data table and / or the target data range.

[0200] In some embodiments, the table configuration page further includes a first configuration area, a second configuration area and a third configuration area corresponding to the rows, the columns and the values, respectively.

[0201] The receiving module 604 is configured to determine the first configuration information according to the plurality of target fields configured in the first configuration area, the second configuration area and the third configuration area.

[0202] In some embodiments, the receiving module 604 is configured to determine first target fields, second target fields and third target fields corresponding to the target rows, the target columns and the target values according to a field arrangement order and a field type in the data table, and add the first target fields, the second target fields and the third target fields in the first configuration area, the second configuration area and the third configuration area, respectively.

[0203] In some embodiments, the receiving module 604 is configured to: in response to a selection instruction of a fourth target field in the field selection list, determine a field type and a field value of the fourth target field; in response to the field type of the fourth target field being a number type or a formula type and the field value being a number, add the fourth target field to the third configuration area; in response to the field type of the fourth target field being a non-number type and a non-formula type or the field value of the fourth target field being a non-number, add the fourth target field to the first configuration area and / or the second configuration area.

[0204] In some embodiments, the receiving module 604 is configured to: in response to a fifth target field in the field selection list being dragged to the first configuration area, the second configuration area or the third configuration area, add the fifth target field in the first configuration area, the second configuration area or the third configuration area.

[0205] In some embodiments, the receiving module 604 is configured to: in response to the first target field being dragged from the first configuration area to the second configuration area or the third configuration area, delete the first target field from the first configuration area and add the first target field in the second configuration area or the third configuration area.

[0206] In some embodiments, the target field is provided with an associated position setting operation control; the receiving module 604 is configured to: in response to a trigger instruction of the operation control, display an operation menu at an associated position of the operation control; wherein when the target field is a date type field, the operation menu comprises a date grouping configuration item; in response to a trigger instruction of the date grouping configuration item, display a grouping selection menu at an associated position of the date grouping configuration item; wherein the grouping selection menu comprises a plurality of grouping options for grouping according to different date intervals; in response to a selection instruction of a target grouping option in the plurality of grouping options, generate a target grouping field and replace the target field with the target grouping field.

[0207] In some embodiments, the third configuration area comprises a summary control for configuring a summary manner; the receiving module 604 is configured to: in response to a trigger instruction of the summary control, display a summary menu at an associated position of the summary control; wherein the summary menu comprises a plurality of summary options in different summary manners; in response to a selection instruction of a target summary option in the plurality of summary options, configure a target summary manner corresponding to the target summary option for the target field in the third configuration area, so that the target value in the table component is calculated in the target summary manner.

[0208] In some embodiments, the table configuration page further includes a sorting condition configuration item; the receiving module 604 is configured to: in response to a triggering instruction of the sorting condition configuration item, display a condition configuration window at an associated position of the sorting condition configuration item; wherein the condition configuration window includes a sorting field configuration item, a sorting basis configuration item, and a sorting manner configuration item, the sorting field configuration item includes a plurality of field options corresponding to the plurality of target fields, the sorting basis configuration item includes at least one basis option corresponding to the target value, and the sorting manner includes a positive sequence option and a reverse sequence option; receive fourth configuration information of the sorting field configuration item, the sorting basis configuration item, and the sorting manner configuration item; wherein the fourth configuration information includes a target sorting field, a target sorting basis, and a target sorting manner; and sort the target sorting field in the table component according to the target sorting manner based on the target sorting basis.

[0209] In some embodiments, the table component includes a plurality of cells corresponding to the target value; the generating module 606 is configured to: for each of the cells, perform the following operations: determine a row field value and a column field value corresponding to the target row and the target column of the cell; based on the row field value and the column field value, find a value field value of the target value corresponding to the row field value and the column field value in the data table; and fill the cell based on the value field value.

[0210] In some embodiments, the number of value field values is a plurality; the generating module 606 is configured to: based on a target summary manner, perform summary calculation on the plurality of value field values to obtain a summary value; and fill the cell with the summary value; wherein the target summary manner includes summation, counting, de-duplication counting, average value, median, maximum value, or minimum value.

[0211] In some embodiments, the generating module 606 is configured to: in response to the value field value being updated, fill the cell based on the updated value field value.

[0212] For the convenience of description, the above apparatus is described in various modules according to functions. Of course, the functions of each module can be implemented in one or more software and / or hardware in the implementation of the present disclosure.

[0213] The apparatus of the above embodiments is used to implement the corresponding table creation method in any of the preceding embodiments, and has the beneficial effects of the corresponding method embodiments, which are not described here again.

[0214] Based on the same inventive concept, the disclosure also provides a non-transitory computer-readable storage medium containing a computer program, which, when executed by one or more processors, causes the one or more processors to perform the table creation method.

[0215] The computer-readable medium of the embodiments can include permanent and non-permanent, removable and non-removable media, which can be implemented by any method or technology to store information. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technologies, compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassette, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information accessible by a computing device.

[0216] The computer program stored in the storage medium of the above embodiments is used to make the one or more processors execute the table creation method as described in any of the above embodiments, and has the beneficial effects of the corresponding method embodiments, which are not repeated here.

[0217] Based on the same inventive concept, the disclosure also provides a computer program product including one or more computer programs. In some embodiments, the one or more computer programs are executable by one or more processors to cause the one or more processors to perform the table creation method. Corresponding to the execution subject of each step in each embodiment of the table creation method, the processor executing the corresponding step can belong to the corresponding execution subject.

[0218] The computer program product of the above embodiments is used to make the processor execute the table creation method as described in any of the above embodiments, and has the beneficial effects of the corresponding method embodiments, which are not repeated here.

[0219] Those skilled in the art should understand that the discussion of any of the above embodiments is only exemplary and is not intended to imply that the scope of the disclosure (including claims) is limited to these examples; under the idea of the disclosure, the above embodiments or technical features between different embodiments can also be combined, the steps can be implemented in any order, and there are many other changes of different aspects of the embodiments of the disclosure as described above. In order to be brief, they are not provided in detail.

[0220] In addition, to simplify the description and discussion, and so as not to make the embodiments of the disclosure difficult to understand, the well-known power / ground connections to integrated circuit (IC) chips and other components can or can not be shown in the provided drawings. Further, devices can be shown in block diagram form in order to avoid making the embodiments of the disclosure difficult to understand, and this also takes into account the fact that details regarding implementation of these block diagram devices are highly dependent on the platform to which the embodiments of the disclosure are to be implemented (i.e., these details should be well within the understanding of one of skill in the art). Where specific details (e.g., circuitry) are set forth in order to describe an illustrative embodiment of the disclosure, it will be apparent to one of skill in the art that the embodiments of the disclosure can be practiced without, or with variation of, these specific details. Thus, these descriptions are to be considered in all respects only as illustrative and not restrictive.

[0221] While the disclosure has been described in connection with specific embodiments thereof, many alternatives, modifications, and variations will be apparent to those of ordinary skill in the art in light of the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) can use the embodiments discussed.

[0222] The embodiments of the disclosure are intended to cover all such alternatives, modifications, and variations as come within the scope of the broadest possible interpretation of the appended claims. Accordingly, any and all such modifications, variations, and equivalents that fall within the spirit and scope of the embodiments of the disclosure are intended to be embraced herein.

Claims

1. A table creation method, comprising: In response to receiving a component creation instruction in a component page of a data table, displaying a table configuration page; wherein the table configuration page includes a field selection list for configuring rows, columns, and values, the field selection list being generated based on the data table and including a plurality of fields, and the component page being used to configure a component associated with the data table; receiving first configuration information of a plurality of target fields in the field selection list; Based on the first configuration information and the field values ​​of the multiple target fields in the data table, a table component is generated; wherein the table component includes target rows, target columns and target values ​​corresponding to the multiple target fields.

2. The method according to claim 1, wherein The table configuration page also includes a data source configuration item and / or a data range configuration item; The method further comprises: Receive second configuration information of the data source configuration item and / or third configuration information of the data range configuration item; Determine a target data table and / or a target data range in the target data table based on the second configuration information and / or the third configuration information; The field selection list is generated based on the target data table and / or the target data range.

3. The method according to claim 1, wherein The table configuration page further includes a first configuration area, a second configuration area, and a third configuration area corresponding to the row, the column, and the value, respectively; Receiving first configuration information of a plurality of target fields in the field selection list includes: The first configuration information is determined according to the multiple target fields configured in the first configuration area, the second configuration area, and the third configuration area.

4. The method of claim 3, further comprising: Determine, according to the order of fields and field types in the data table, a first target field, a second target field, and a third target field corresponding to the target row, the target column, and the target value; The first target field, the second target field, and the third target field are added in the first configuration area, the second configuration area, and the third configuration area, respectively.

5. The method of claim 3, further comprising: In response to a selection instruction of a fourth target field in the field selection list, determining a field type and a field value of the fourth target field; In response to the field type of the fourth target field being a number type or a formula type and the field value being a number, adding the fourth target field to the third configuration area; In response to the field type of the fourth target field being a non-numeric type and a non-formula type or the field value of the fourth target field being a non-numeric number, the fourth target field is added to the first configuration area and / or the second configuration area.

6. The method of claim 3, further comprising: In response to a fifth target field in the field selection list being dragged to the first configuration area, the second configuration area, or the third configuration area, the fifth target field is added to the first configuration area, the second configuration area, or the third configuration area.

7. The method of claim 4, further comprising: In response to the first target field being dragged from the first configuration area to the second configuration area or the third configuration area, the first target field is deleted from the first configuration area, and the first target field is added to the second configuration area or the third configuration area.

8. The method of claim 3, wherein: An operation control is set at the associated position of the target field; The method further comprises: In response to a trigger instruction of the operation control, an operation menu is displayed at a position associated with the operation control; wherein, when the target field is a date type field, the operation menu includes a date grouping configuration item; In response to a trigger instruction of the date grouping configuration item, a group selection menu is displayed at a position associated with the date grouping configuration item; wherein the group selection menu includes a plurality of grouping options for grouping according to different date intervals; In response to a selection instruction of a target grouping option among the plurality of grouping options, a target grouping field is generated and the target field is replaced by the target grouping field.

9. The method of claim 3, wherein: The third configuration area includes a summary control for configuring a summary mode; The method further comprises: In response to a trigger instruction of the summary control, a summary menu is displayed at a position associated with the summary control; wherein the summary menu includes a plurality of summary options using different summary methods; In response to a selection instruction of a target summary option among the multiple summary options, a target summary method corresponding to the target summary option is configured for the target field in the third configuration area, so that the target value in the table component is summarized and calculated according to the target summary method.

10. The method of claim 1, wherein: The table configuration page also includes sorting condition configuration items; The method further comprises: In response to a trigger instruction of the sorting condition configuration item, a condition configuration window is displayed at a position associated with the sorting condition configuration item; wherein the condition configuration window includes a sorting field configuration item, a sorting basis configuration item, and a sorting mode configuration item, the sorting field configuration item includes a plurality of field options corresponding to the plurality of target fields, the sorting basis configuration item includes at least one basis option corresponding to the target value, and the sorting mode includes an ascending order option and a descending order option; Receive fourth configuration information of the sorting field configuration item, the sorting basis configuration item, and the sorting mode configuration item; wherein the fourth configuration information includes a target sorting field, a target sorting basis, and a target sorting mode; Based on the target sorting basis, the target sorting fields in the table component are sorted according to the target sorting method.

11. The method of claim 1, wherein: The table component includes a plurality of cells corresponding to the target value; Generating a table component based on the first configuration information and the field values ​​of the multiple target fields in the data table includes: For each of the cells, perform the following operations: Determine a row field value and a column field value of the cell corresponding to the target row and the target column; Based on the row field value and the column field value, searching the data table for a value field value of the target value corresponding to the row field value and the column field value; Based on the value field value, the cell is populated.

12. The method of claim 11, wherein: The number of the value field values ​​is multiple; Filling the cell based on the value field value includes: Based on the target aggregation method, the values ​​of the multiple value fields are aggregated and calculated to obtain an aggregate value; Filling the cells with the summary value; The target aggregation method includes sum, count, deduplication count, average, median, maximum or minimum value.

13. The method of claim 11, further comprising: In response to the value field value being updated, the cell is populated based on the updated value field value.

14. A table creation device, comprising: A display module is configured to: in response to receiving a component creation instruction in a component page of a data table, display a table configuration page; wherein the table configuration page includes a field selection list for configuring rows, columns, and values, the field selection list is generated based on the data table and includes a plurality of fields, and the component page is used to configure a component associated with the data table; A receiving module is configured to: receive first configuration information of a plurality of target fields in the field selection list; The generation module is configured to: generate a table component based on the first configuration information and the field values ​​of the multiple target fields in the data table; wherein the table component includes target rows, target columns and target values ​​corresponding to the multiple target fields.

15. A computer device comprising one or more processors, a memory; and one or more programs, wherein the one or more programs are stored in the memory and executed by the one or more processors, and the one or more programs include instructions for executing the method according to any one of claims 1 to 13.

16. A non-transitory computer-readable storage medium containing a computer program, which, when executed by one or more processors, causes the one or more processors to perform the method according to any one of claims 1 to 13.

17. A computer program product, comprising one or more computer programs, wherein when the one or more computer programs are executed by one or more processors, the method according to any one of claims 1 to 13 is implemented.

Images