Chart configuration method and device, computer equipment, storage medium and program product

Abstract

The invention provides a chart configuration method and device, computer equipment, a storage medium and a program product. The method comprises the following steps: displaying a first chart on a component page of a data table; wherein the first chart is drawn based on a plurality of column fields of the data table and corresponding column field values, the plurality of column fields comprise a first column field and a second column field, and the first chart takes the first column field as a horizontal axis and takes the second column field as a longitudinal axis; the component page is a page independent of the data table; in response to a row-column switching instruction for the first chart, displaying a second chart; wherein the second chart is drawn based on the plurality of column fields and the corresponding column field values, and the second chart takes the second column field as a horizontal axis and takes the first column field as a longitudinal axis. According to the invention, row-column switching can be conveniently realized, and the efficiency is improved.

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular to a chart configuration method and apparatus, computer equipment, storage medium, and program product. Background Art

[0002] With the continuous development of Internet technology, many tasks can be completed intelligently. For example, collaborative office software can be used to configure charts based on data tables, so that the information in the data tables can be displayed in the form of charts.

[0003] However, the inventors of the present disclosure have found that in related technologies, the form of a chart generated based on a data table is closely related to the recording method of the data table. If the presentation form of the chart needs to be changed, the data table needs to be modified accordingly, which is inefficient. Summary of the Invention

[0004] The present disclosure proposes a chart configuration method and apparatus, computer equipment, storage medium, and program product to solve or partially solve the above-mentioned problems.

[0005] In a first aspect, the present disclosure provides a chart configuration method, comprising:

[0006] Displaying a first chart on a component page of a data table; wherein the first chart is drawn based on a plurality of column fields of the data table and corresponding column field values, the plurality of column fields including a first column field and a second column field, the first chart uses the first column field as a horizontal axis and the second column field as a vertical axis, and the component page is a page independent of the data table;

[0007] In response to a row and column switching instruction for the first chart, a second chart is displayed; wherein the second chart is drawn based on the multiple column fields and the corresponding column field values, and the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis.

[0008] In a second aspect of the present disclosure, a chart configuration device is provided, comprising:

[0009] A display module is configured to: display a first chart on a component page of a data table; wherein the first chart is drawn based on a plurality of column fields of the data table and corresponding column field values, the plurality of column fields including a first column field and a second column field, the first chart uses the first column field as a horizontal axis and the second column field as a vertical axis, and the component page is a page independent of the data table;

[0010] The switching module is configured to: display a second chart in response to a row and column switching instruction for the first chart; wherein the second chart is drawn based on the multiple column fields and the corresponding column field values, and the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis.

[0011] In a third aspect of the present disclosure, a computer device is provided, 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 described in the first aspect.

[0012] According to a fourth aspect of the present disclosure, a non-volatile computer-readable storage medium containing a computer program is provided. When the computer program is executed by one or more processors, the one or more processors execute the method described in the first aspect.

[0013] In a fifth aspect of the present disclosure, a computer program product is provided, comprising one or more computer programs, wherein the one or more computer programs implement the method described in the first aspect when executed by one or more processors.

[0014] The chart configuration method and apparatus, computer equipment, storage medium, and program product provided by the embodiments of the present disclosure implement convenient row and column switching operations through row and column switching instructions without modifying the data table. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] In order to more clearly illustrate the technical solutions in the present disclosure or related technologies, the following briefly introduces the drawings required for use in the embodiments or related technical descriptions. Obviously, the drawings described below are only embodiments of the present disclosure. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

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

[0017] Figure 1B A schematic diagram showing an exemplary data table is shown.

[0018] Figure 1C A schematic diagram of another exemplary data table is shown.

[0019] Figure 2A A schematic diagram of an exemplary component page according to an embodiment of the present disclosure is shown.

[0020] Figure 2B Another schematic diagram of an exemplary component page according to an embodiment of the present disclosure is shown.

[0021] Figure 2C A schematic diagram of a process for determining a target value according to an embodiment of the present disclosure is shown.

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

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

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

[0025] Figure 6 A schematic diagram showing an exemplary device provided by an embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0026] In order to make the objectives, technical solutions and advantages of the present disclosure more clearly understood, the present disclosure is further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0027] It should be noted that, unless otherwise defined, the technical terms or scientific terms used in the embodiments of the present disclosure should have the usual meanings understood by people with ordinary skills in the field to which the present disclosure belongs. The "first", "second" and similar words used in the embodiments of the present disclosure do not indicate any order, quantity or importance, but are only used to distinguish different components. "Include" or "comprise" and similar words mean that the elements or objects appearing before the word include the elements or objects listed after the word and their equivalents, without excluding other elements or objects. "Connect" or "connected" and similar words are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "Up", "down", "left", "right" and the like are only used to indicate relative position relationships. When the absolute position of the described object changes, the relative position relationship may also change accordingly.

[0028] It is understandable that before using the technical solutions of each embodiment of the present disclosure, the type, scope of use, usage scenarios, etc. of the personal information involved will be informed to the user in an appropriate manner, and the user's authorization will be obtained.

[0029] For example, in response to a user's active request, a prompt message is sent to the user to clearly inform the user that the requested operation will require the acquisition and use of the user's personal information. This allows the user to independently choose whether to provide personal information to the electronic device, application, server, storage medium, or other software or hardware that performs the operation of the disclosed technical solution based on the prompt message.

[0030] As an optional but non-limiting implementation, in response to a user's active request, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. Furthermore, the pop-up window may also contain a selection control for the user to select "agree" or "disagree" to provide personal information to the electronic device.

[0031] It is understandable that the above notification and user authorization process are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that comply with relevant laws and regulations may also be applied to the implementation of the present disclosure.

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

[0033] like Figure 1A As shown, the system 100 may include terminal devices 102A and 102B, a server 106, and a database server 108. A medium (e.g., a network) providing a communication link may be included between the terminal devices 102A and 102B and the server 106 and the database server 108. The network may include various connection types, such as wired or wireless communication links or fiber optic cables.

[0034] Various applications (APPs) or software can be installed on the terminal devices 102A and 102B, 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.

[0035] The terminal devices 102A and 102B herein can be either hardware or software. When the terminal devices 102A and 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, laptop computers, and desktop computers (PCs). When the terminal devices 102A and 102B are software, they can be installed in the electronic devices listed above. They can be implemented as multiple software programs or software modules (for example, to provide distributed services), or as a single software program or software module. This is not specifically limited here.

[0036] Server 106 may be a server that provides various services, such as a backend server that supports various applications or software displayed on terminal devices 102A and 102B. Database server 108 may also be a database server that provides various services. It is understood that if server 106 can perform the functions related to database server 108, database server 108 may not be provided in system 100.

[0037] Here, the server 106 and database server 108 can also be hardware or software. When they are hardware, they can be implemented as a distributed server cluster consisting of multiple servers, or as a single server. When they are software, they can be implemented as multiple software programs or software modules (for example, to provide distributed services), or as a single software program or software module. No specific limitations are given here.

[0038] It should be noted that the chart configuration method provided in the embodiment of the present disclosure can be executed by the terminal devices 102A and 102B or interactively executed by the devices in the system 100. It should be understood that Figure 1A The numbers of terminal devices, users, servers and database servers in the embodiment are merely illustrative. Any number of terminal devices, users, servers and database servers may be provided as required.

[0039] In some exemplary scenarios, the user 104A may create a data table through collaborative office software or applications installed in the terminal device 102A.

[0040] Figure 1B A schematic diagram showing an exemplary data table is shown.

[0041] like Figure 1B As shown, for example, user 104A and / or user 104B can enter data in a data table to record sales information. For example, the data table may include multiple column fields and corresponding column field values. For example, Figure 1BAs shown, the column field of the first column can be a department field, and the corresponding column field value can be Sales Department 1, Sales Department 2, and Sales Department 3. The column field of the second column can be Q1 (indicating the first quarter), and the corresponding column field value can be the specific sales value of Sales Department 1, Sales Department 2, and Sales Department 3 in Q1. The column field of the third column can be Q2 (indicating the second quarter), and the corresponding column field value can be the specific sales value of Sales Department 1, Sales Department 2, and Sales Department 3 in Q2. The column field of the fourth column can be Q3 (indicating the third quarter), and the corresponding column field value can be the specific sales value of Sales Department 1, Sales Department 2, and Sales Department 3 in Q3. The column field of the fifth column can be Q4 (indicating the fourth quarter), and the corresponding column field value can be the specific sales value of Sales Department 1, Sales Department 2, and Sales Department 3 in Q4.

[0042] However, the inventors of the present disclosure have discovered that when users Figure 1B When drawing a chart with a data table, you can only use the first column field as the horizontal axis and the other columns as the vertical axis. If you need to switch the other columns' fields to the horizontal axis and use the first column's fields as the vertical axis, you need to Figure 1B The data table is adjusted to Figure 1C or recreate one like Figure 1C The data table shown is then based on Figure 1C In order to switch the display of rows and columns of the chart, the chart needs to be redrawn by reusing the data table. This will cause a lot of workload for users and waste resources because it requires adjusting the existing data table or creating a new one.

[0043] In view of this, a first aspect of an embodiment of the present disclosure provides a chart configuration method, which can solve or partially solve the above problems to a certain extent.

[0044] As an exemplary scenario, user 104A may create and configure a chart using collaborative office software or applications installed on terminal device 102A, and user 104B may view the chart created and configured by user 104A using collaborative office software or applications installed on terminal device 102B.

[0045] For example, in the initial state, user 104A can use terminal device 102A to open collaborative office software or application and enter his / her own workspace. The workspace may include at least one data table created and / or managed by user 104A. The format of the data table is as follows: Figure 1BAs shown. In some embodiments, user 104A can create a visual chart component based on the at least one data table. The visual chart component may include, for example, a bar chart, a pie chart, a line chart, etc. As an optional embodiment, user 104A finds a chart creation function in a chart creation module of a collaborative office software or application (for example, by triggering a chart creation control to generate a chart configuration instruction) and enters page 200, as shown. Figure 2A As shown. This page 200 can create and configure a chart component based on a data table, and can also be called a component page of the data table. Optionally, the component page 200 is a page independent of the data table. In other words, the user can create and configure a chart in a page independent of the data table, and can display the chart in the component page.

[0046] In some embodiments, a first chart may be displayed on page 200, such as Figure 2A Optionally, the first chart may be based on Figure 1B The column fields of the data table and the corresponding column field values ​​are plotted. For example, Figure 2A As shown, the page 200 may include a data source configuration item 204. By configuring the data source configuration item 204 as Figure 1B The data table can be based on Figure 1B In this way, by using the data source configuration item 204 to select the data source for generating the chart, the user can flexibly configure the chart. Figure 2A As shown, page 200 may also include a data range configuration item 206. User 104A may configure the data range in data range configuration item 206, thereby reducing the amount of data used for drawing a chart based on the configured data table by configuring the data range. When data range configuration item 206 is configured to "all data," a chart may be drawn based on all data in the selected data table.

[0047] In some embodiments, page 200 may further include configuration items of column fields involved in drawing, so that corresponding column fields and corresponding column field values ​​may be selected as needed based on the selected data table to generate a chart.

[0048] For example, Figure 1B As shown in the figure, the column field values ​​of the first column of the data table include Sales Department 1, Sales Department 2, and Sales Department 3, and the column fields of other columns include Q1, Q2, Q3, and Q4. The corresponding column field values ​​include the corresponding specific sales values. The user can select all or part of the column fields and / or column field values ​​through the field configuration items to draw a chart. Figure 1BAs shown, for example, the current horizontal axis is configured as the department field, and the vertical axis is configured as the column fields corresponding to Q1, Q2, Q3, and Q4. When drawing a chart, you can draw a chart based on Sales Department 1, Sales Department 2, Sales Department 3, and Q1, Q2, Q3, Q4, and their corresponding values ​​(for example, sales). For another example, if you only select Sales Department 1, Sales Department 2, and Q1, Q2, Q3, when drawing a chart, you can draw a chart based only on Sales Department 1, Sales Department 2, and Q1, Q2, Q3, and their corresponding values ​​(for example, sales). Optionally, as Figure 2A As shown, various configuration items for configuring a chart can be displayed in the first area 200A of the page 200, so that the user can complete the configuration of the chart in a specific area of ​​the page, which is more convenient.

[0049] refer to Figure 2A As shown, assuming that the current user 104A has completed the configuration of the chart, the second area 200B of the page 200 can display a first chart drawn based on the current configuration information.

[0050] In some embodiments, the plurality of column fields used to draw the first chart may include a first column field and a second column field, and the first chart may use the first column field as the horizontal axis and the second column field as the vertical axis. Figure 2A As shown, the first column field can be a department field, and the second column field can be a Q1, Q2, Q3, or Q4 column field. Optionally, when displaying the first chart, the horizontal axis of the first chart can be displayed based on the first column field and the vertical axis of the first chart can be displayed based on the second column field, and a legend corresponding to the second column field can be displayed at the associated position of the first chart. For example, Figure 2A As shown in the figure, Sales Department 1, Sales Department 2, and Sales Department 3 displayed on the horizontal axis are the column field values ​​of the first column field. They can also be the coordinates on the horizontal axis, reflecting the arrangement order of the column field values ​​of the first column field along the horizontal axis. For example, Figure 2A As shown, multiple numerical values ​​and corresponding scale lines are displayed on the vertical axis, corresponding to the column field values ​​of the second column field (for example, sales), which are used as reference values ​​for drawing the graph of the chart, and can be drawn according to the maximum value in the data table. For example, the maximum value in the data table is about 2200000, and the maximum scale line of the vertical axis can be the scale line corresponding to 2200000. For another example, the associated position of the first chart (for example, the upper left corner) displays the legend corresponding to the second column field, so that according to the legend, the user can know what the second column field is corresponding to each graph in the first chart. Then, according to the horizontal axis, vertical axis and legend, the various graphics of the first chart can be drawn based on the corresponding values, so that according to the display of the graphics, the user can intuitively compare the data corresponding to each field value.

[0051] Optionally, in order to better compare and display the values ​​of each column field, the graphics of the first chart may have a first order based on the arrangement order of the column field values ​​of the first column field and a second order based on the arrangement order of the second column field. In the first chart, the first order has a higher priority than the second order. When arranging the graphics, they are first arranged according to the first order and then arranged according to the second order. In the first order, the column field values ​​of the first column field are used as a reference, so when the graphics are arranged according to the aforementioned sorting rules, the first chart can appear to be drawn based on the first column field.

[0052] In some embodiments, to better compare and display the values ​​of each column field, the graphics of the first chart may be divided into a first number of first graphic groups based on a first number of column field values ​​of the first column field (e.g., 3); wherein each first graphic group includes a second number (e.g., 4) of graphics, where the second number is the number of the second column field. Then, the first number of the first graphic groups are displayed in the first order, and the second number of graphics in each first graphic group are displayed in the second order.

[0053] by Figure 2A Taking the first chart shown as an example, the column field values ​​of the first column field can be Sales Department 1, Sales Department 2, and Sales Department 3, so the graph can be divided into three first graph groups, corresponding to Sales Department 1, Sales Department 2, and Sales Department 3, respectively. Then, since the second column field includes Q1, Q2, Q3, and Q4, each first graph group can further include four graphs, corresponding to Q1, Q2, Q3, and Q4, respectively. Then, the three first graph groups are arranged and displayed in sequence according to the first order (i.e., the order in which the column field values ​​of the first column field are arranged), wherein the four graphs in each first graph group are arranged and displayed in sequence according to the second order (i.e., the order in which the second column field is arranged). The shape of each graph (e.g., the height of the bar graph) is drawn based on its corresponding column field value (e.g., sales volume).

[0054] By using the above-mentioned method of drawing graphs, users can more intuitively compare the data corresponding to each field value.

[0055] As mentioned above, it is difficult to implement a simple row-column switching operation in the related art.

[0056] In view of this, in some embodiments, in response to the row and column switching instruction for the first chart, the second chart may be displayed, such as Figure 2BAs shown. Among them, the second chart is still drawn based on the multiple column fields and corresponding column field values ​​of the data table, and the second chart can be a chart after the row and column switching is performed on the first chart. In addition, in addition to implementing the row and column switching, the configuration information for the first chart is also effective for the second chart. In this way, a convenient row and column switching operation is achieved through the row and column switching instruction without modifying the data table, or in other words, the row and column switching of the chart is achieved without changing the data structure in the data table.

[0057] Optionally, the row and column switching instructions can be generated based on shortcut instructions, so that the row and column switching operation can be quickly triggered by the shortcut instructions. In addition to shortcut instructions, the row and column switching operation can also be triggered based on controls.

[0058] In some embodiments, as Figure 2A As shown, the component page 200 may include a row-column switching control 202. In response to a trigger instruction of the row-column switching control 202, it may be considered that a row-column switching instruction for the first chart has been received, and the second chart may be further displayed, such as Figure 2B In this way, by setting the row and column switching control 202, the row and column can be switched with one key, which makes the user operation easier.

[0059] Alternatively, as Figure 2A As shown, the row-column switching control 202 can be in the form of a switch. When the row-column switching function is turned off, the switch is in the closed state. When the row-column switching function is turned on, the switch is in the open state. Figure 2B As shown, the user can know whether the current row and column switching function is turned on according to the state of the switch. Optionally, when the switch is in the off state, it can also be grayed out, such as Figure 2A As shown, it indicates that the row and column switching function is not turned on. When the switch is in the off state, it can also be lit, such as Figure 2B As shown, it indicates that the row and column switching function has been turned on, further enhancing the visual effect of prompting the user.

[0060] Optionally, the row-column switching control 202 may not be in the form of a switch, for example, it may be in the form of a check box. When the check box is checked, the row-column switching function is turned on, and when it is unchecked, the row-column switching function is turned off.

[0061] In some embodiments, in response to the row and column switching instruction for the first chart, a prompt message can also be displayed synchronously, and the prompt message is used to remind the user that the second chart is a chart after the row and column switching is performed on the first chart. For example, the prompt message can be "Row / column switching has been turned on, and the chart will be displayed with the data after the current horizontal and vertical axes are converted." In this way, when the chart is displayed by row and column switching, the prompt message reminds the user that the chart is currently in the row and column switching state. If the user accidentally touches the function due to an erroneous operation, he can also quickly know which function has been erroneously operated. Optionally, the prompt message can be displayed at the top of page 200 to avoid blocking the content in page 200. Optionally, the prompt message can be automatically closed after being displayed for a certain period of time (for example, 10s) to avoid affecting the user's viewing of the content in page 200. In some embodiments, a close control can be set at the associated position of the prompt message (for example, on the right side), and the user can close the prompt message by triggering the close control to facilitate operation.

[0062] In some embodiments, as Figure 2B As shown, the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis. In other words, the user does not need to reconfigure the fields of the horizontal axis and the vertical axis ( Figure 2B The configuration information of the horizontal and vertical axes in the chart does not change), and there is no need to change the data table, and one-click switching of rows and columns can be achieved. Optionally, when displaying the second chart, the horizontal axis of the second chart can be displayed based on the second column field and the vertical axis of the second chart can be displayed based on the first column field, and the legend corresponding to the first column field can be displayed in the associated position of the second chart. For example, Figure 2B As shown in the figure, Q1, Q2, Q3, and Q4 displayed on the horizontal axis are the field names of the second column. They can also be the coordinates on the horizontal axis, reflecting the arrangement order of the second column fields along the horizontal axis. For example, Figure 2B As shown, multiple numerical values ​​and corresponding scale lines are displayed on the vertical axis, corresponding to the column field values ​​of the second column field corresponding to each column field value of the first column field (for example, sales), which are used as reference values ​​for drawing the graph of the chart, and can be drawn according to the maximum value in the data table. For example, the maximum value in the data table is about 2200000, and the maximum scale line of the vertical axis can be the scale line corresponding to 2200000. For another example, the associated position of the second chart (for example, the upper left corner) displays the legend corresponding to the first column field, so that according to the legend, the user can know what the column field value of the first column field corresponding to each graph in the second chart is. Then, according to the horizontal axis, vertical axis and legend, each graph of the second chart can be drawn based on the corresponding values, so that according to the display of the graph, the user can intuitively compare the data corresponding to each field value.

[0063] like Figure 2B As shown, the graphics of the second chart have an arrangement order after exchanging the first order (i.e., the arrangement order of the column field values ​​of the first column field) and the second order (i.e., the arrangement order of the second column field). In other words, in the second chart, the second order has a higher priority than the first order, and when arranging the graphics, they are first arranged according to the second order, and then arranged according to the first order. Among them, the second order is based on the arrangement order of the second column field, so that when the graphics are arranged according to the aforementioned sorting rules, the second chart can appear to be drawn based on the second column field, so that the user can visually feel the effect of switching rows and columns.

[0064] In some embodiments, when displaying a second chart, the graphics of the second chart can be divided into the second number of second graphic groups according to the second number of the second column fields (for example, 4); wherein each of the second graphic groups includes a first number (for example, 3) of graphics, and the first number is the number of column field values ​​of the first column field; then, the second number of the second graphic groups are displayed in the second order and the first number of graphics in each second graphic group are displayed in the first order.

[0065] by Figure 2B Taking the second chart shown as an example, the second column fields can be Q1, Q2, Q3, and Q4, so that the graph can be divided into four second graph groups, corresponding to Q1, Q2, Q3, and Q4 respectively. Then, since the column field values ​​of the first column field include Sales Department 1, Sales Department 2, and Sales Department 3, each second graph group can further include three graphs, corresponding to Sales Department 1, Sales Department 2, and Sales Department 3 respectively. Then, the four second graph groups are arranged and displayed in sequence according to the second order (i.e., the arrangement order of the second column fields), wherein the three graphs in each second graph group are arranged and displayed in sequence according to the first order (i.e., the arrangement order of the column field values ​​of the first column fields). The shape of each graph (e.g., the height of the bar graph) is drawn based on its corresponding column field value (e.g., sales volume).

[0066] By using the above-mentioned method of drawing graphics, users can more intuitively feel the effect of switching between rows and columns visually.

[0067] As previously described, in some embodiments, the plurality of column fields and corresponding column field values ​​of the data table may be determined based on the configuration information of the data source configuration item 204 and / or the data range configuration item 206; and the first chart and / or the second chart may be drawn based on the column fields and corresponding column field values. Optionally, the data source configuration item 204 may be configured with multiple data sources (i.e., multiple data tables), thereby merging data from multiple data sources to generate a chart.

[0068] On this basis, in some embodiments, such as Figure 2C As shown, determining the multiple column fields and corresponding column field values ​​of the data table according to the configuration information of the data source configuration item and / or the data range configuration item may further include:

[0069] At step 222 , in response to the configuration information including a plurality of data sources, the number of field values ​​corresponding to the target column field value in the plurality of data sources is determined.

[0070] by Figure 1B For example, the first column field can be the department field, and the second column field can be the Q1, Q2, Q3, and Q4 fields. Therefore, when a new data table is added, the corresponding column fields and corresponding column field values ​​can be found in the new data table based on the first and second column fields. For example, assuming that the field values ​​of the department field in the new data table include Sales Department 1, Sales Department 2, Sales Department 4, and Sales Department 5, then based on Figure 1B In the data table and the newly added data table, we can determine that the multiple column field values ​​corresponding to the first column field are Sales Department 1, Sales Department 2, Sales Department 3, Sales Department 4, and Sales Department 5. Of these, Sales Department 1 and Sales Department 2 have overlapping field values, so we can remove duplicates and retain only one. Similarly, we can count and remove duplicates for the second column fields of multiple data sources to obtain multiple second column fields corresponding to the multiple data sources.

[0071] In step 224 , in response to the number of field values ​​corresponding to the target column field value in the multiple data sources being one, the field value is used as the target value corresponding to the target column field value.

[0072] refer to Figure 1B As shown, each row field value corresponds to each column field value one-to-one, forming multiple field pairs. Each field pair can correspond to a cell with a value, so the value corresponding to each field pair can be found based on this, and then the graph in the chart can be drawn based on it. Therefore, in this step, for each cell corresponding to the column field value, the corresponding field value can be found from multiple data tables.

[0073] With the aforementioned Figure 1B As an example, the data table and the newly added data table are Figure 1B The data table of Sales Department 4 and Sales Department 5 only appear in the newly added data table. Then, there is only one field value (sales volume) corresponding to Q1, Q2, Q3, and Q4 of Sales Department 3, Sales Department 4, and Sales Department 5. At this time, the field value can be directly used as the target value of the target column field value to draw the corresponding graph.

[0074] In step 226, in response to the number of field values ​​corresponding to the target column field value in the multiple data sources being multiple, the multiple field values ​​are aggregated and calculated based on the target aggregation method to obtain an aggregate value, and the aggregate value is used as the target value corresponding to the target column field value.

[0075] Still with the aforementioned Figure 1B Taking the existing data table and the newly added data table as an example, since Sales Department 1 and Sales Department 2 appear in both data tables, the number of corresponding field values ​​is 2. At this time, the two field values ​​can be summarized and calculated according to the target summary method to obtain a summary value as the target value corresponding to the target column field value for drawing the corresponding graph.

[0076] Optionally, the target aggregation method can be pre-configured by the user, which can be sum, average, maximum, minimum, etc. When a specific aggregation method is configured, when the target column field value corresponds to multiple field values, the multiple values ​​can be calculated into one value as the target value according to the configured aggregation method.

[0077] In this way, corresponding column field values ​​or target values ​​thereof are found from multiple data sources, and the first chart and / or the second chart can be drawn based on the column field values ​​or target values ​​thereof.

[0078] Through the above embodiments, the fusion display of multiple data sources is achieved, which can realize more complex data analysis capabilities.

[0079] In some embodiments, in response to a row-column switching instruction for the second chart (eg, by triggering the row-column switching control 202 again), the first chart may be restored to display, such as Figure 2A In this way, by performing the row and column switching operation again, the first chart can be easily restored to display, and the user can change the presentation mode of the chart at any time through this operation.

[0080] It can be understood that the above embodiment is described by taking the data table including multiple second column fields as an example. When the data table includes only one second column field or the user only configures one second column field, row and column switching can still be achieved based on the above principle.

[0081] In addition, the row field values ​​of the first row field can be different types of field values ​​instead of a series. For example, the row field values ​​of the first row field can include a sales field and a sales volume field, and the corresponding column field values ​​of the second column field can be different types of values, such as sales volume and sales volume. In addition, when there are multiple second column fields, each second column field can be a different type of field, for example, including quarters and provinces.

[0082] In some embodiments, the second chart 302 may also be displayed on the chart page 300, such as Figure 3 In this way, even if the record format of the data table is not changed, the corresponding chart can be displayed in different presentation methods and displayed in the chart page for users to view. Figure 3 As shown, the chart page 300 may also include other charts, so that the user can see various visual chart components in the chart page 300 to achieve more complex data analysis.

[0083] Alternatively, as Figure 3 As shown, the associated position of the second chart 302 (for example, the upper right corner) can also display a row and column switching control 304, so that the user can switch rows and columns with one click in the chart page 300 without entering the component page 200 to perform corresponding configuration.

[0084] In some embodiments, if the user modifies configuration information on page 200, the first chart and / or the second chart may be redrawn based on the modified configuration information. When data in the data table used to draw the first chart and / or the second chart is updated, the first chart and / or the second chart may also be redrawn based on the updated data table, thereby achieving automatic updating of the charts.

[0085] In some embodiments, the arrangement order of the column field values ​​of the first column field and the arrangement order of the second column field can also be configured, for example, configured in ascending order or descending order, so that the graphics can be arranged based on the configured arrangement order.

[0086] In some embodiments, the configuration of the type and style of the first chart (such as by chart options, theme colors, etc.) also applies to the second chart, and after the rows and columns are switched, the user does not need to manually modify the second chart. In some embodiments, the custom style of the first chart (for example, background, font color and size, axis title, legend) also applies to the second chart, and after the rows and columns are switched, the user does not need to manually modify the second chart. Optionally, after the rows and columns are switched, the user can also modify the second chart based on the configuration items mentioned in the aforementioned embodiments.

[0087] It can be understood that the row and column switching operation of the embodiment of the present disclosure can support charts including horizontal and vertical axes, such as bar charts, line charts, bar charts, area charts, etc. Accordingly, when drawing the graphics of the chart, the corresponding graphics can be drawn according to the chart type based on the value field value.

[0088] It can be seen from the above embodiments that the chart configuration method provided by the embodiments of the present disclosure allows users to switch rows and columns in the chart display without changing the data table structure by switching rows and columns with one click. After switching rows and columns, users can still configure data and customize styles.

[0089] It should be noted that the method of the embodiments of the present disclosure can be performed by a single device, such as a computer or server. The method of the embodiments of the present disclosure can also be applied in a distributed scenario, where multiple devices cooperate to perform the method. In such a distributed scenario, one of the multiple devices may only perform one or more steps of the method of the embodiments of the present disclosure, and the multiple devices will interact with each other to complete the method.

[0090] It should be noted that the above description is limited to some embodiments of the present disclosure. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in an order different from that described in the above embodiments and still achieve the desired results. Furthermore, the processes depicted in the accompanying drawings do not necessarily require the specific order or sequential order shown to achieve the desired results. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0091] Figure 4 FIG2 is a flow chart illustrating an exemplary chart configuration method 400 provided by an embodiment of the present disclosure. The method 400 can be used to configure a template. Optionally, the method 400 can be implemented solely by the terminal device 102A of FIG1 , or can be interactively implemented by various devices in the system 100 of FIG1 .

[0092] like Figure 4 As shown, the method 400 may further include the following steps.

[0093] In step 402, on the component page of the data table (e.g., Figure 2A 、 Figure 2B Page 200) shows the first chart (reference Figure 2A ). The first chart is drawn based on multiple column fields and corresponding column field values ​​of the data table, the multiple column fields include a first column field and a second column field, the first chart uses the first column field as the horizontal axis and the second column field as the vertical axis, and the component page is a page independent of the data table.

[0094] In step 404, in response to the row and column switching instruction for the first chart, the second chart (refer to Figure 2BThe second chart is drawn based on the multiple column fields and the corresponding column field values, and the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis.

[0095] The chart configuration method provided by the embodiment of the present disclosure implements a convenient row and column switching operation through a row and column switching instruction without modifying the data table.

[0096] In some embodiments, the component page includes a row and column switching control (e.g., Figure 2A 、 Figure 2B Row and column switching control 202);

[0097] The displaying of the second chart in response to the row-column switching instruction for the first chart includes: displaying the second chart in response to a triggering instruction of the row-column switching control.

[0098] In this way, by setting the row and column switching control, the row and column can be switched with one click, which makes the user operation easier.

[0099] In some embodiments, the component page includes a data source configuration item (e.g., Figure 2A 、 Figure 2B Data source configuration item 204) and / or data range configuration item (e.g., Figure 2A 、 Figure 2B Data range configuration item 206);

[0100] The method further comprises:

[0101] The multiple column fields and corresponding column field values ​​of the data table are determined according to the configuration information of the data source configuration item and / or the data range configuration item.

[0102] In this way, by using the data source configuration item to select the data source for generating the chart, users can flexibly configure the chart. By configuring the data range in the data range configuration item, the amount of data used for drawing the chart can be reduced by configuring the data range based on the configured data table.

[0103] In some embodiments, determining the plurality of column fields and corresponding column field values ​​of the data table according to configuration information of the data source configuration item and / or the data range configuration item includes:

[0104] In response to the configuration information including a plurality of data sources, determining the number of field values ​​in the plurality of data sources corresponding to the target column field value;

[0105] In response to the number of field values ​​corresponding to the target column field value in the multiple data sources being one, using the field value as the target value corresponding to the target column field value;

[0106] In response to the number of field values ​​corresponding to the target column field value in the multiple data sources being multiple, the multiple field values ​​are aggregated and calculated based on a target aggregation method to obtain an aggregate value, and the aggregate value is used as the target value corresponding to the target column field value.

[0107] Through the above embodiments, the fusion display of multiple data sources is achieved, which can realize more complex data analysis capabilities.

[0108] In some embodiments, the method further includes: in response to a row / column switching instruction for the first chart, displaying a prompt message, wherein the prompt message is used to remind the user that the second chart is a chart after the row / column switching is performed on the first chart. For example, the prompt message may be "Row / column switching is enabled, and the chart will be displayed with the data after the current horizontal and vertical axes are converted." In this way, when the chart is displayed after the row / column switching, the prompt message reminds the user that the chart is currently in the row / column switching state. If the user accidentally touches the function due to an error operation, the user can also quickly know which function was mistakenly operated.

[0109] In some embodiments, displaying the first chart includes:

[0110] Divide the graphics of the first chart into the first number of first graphic groups according to the first number of column field values ​​of the first column field; wherein each of the first graphic groups includes a second number of graphics, and the second number is the number of the second column field;

[0111] The first number of the first graphic groups are displayed in a first order and the second number of graphics in each of the first graphic groups are displayed in a second order.

[0112] by Figure 2A Taking the first chart shown as an example, the column field values ​​of the first column field can be Sales Department 1, Sales Department 2, and Sales Department 3, so the graph can be divided into three first graph groups, corresponding to Sales Department 1, Sales Department 2, and Sales Department 3, respectively. Then, since the second column field includes Q1, Q2, Q3, and Q4, each first graph group can further include four graphs, corresponding to Q1, Q2, Q3, and Q4, respectively. Then, the three first graph groups are arranged and displayed in sequence according to the first order (i.e., the order in which the column field values ​​of the first column field are arranged), wherein the four graphs in each first graph group are arranged and displayed in sequence according to the second order (i.e., the order in which the second column field is arranged). The shape of each graph (e.g., the height of the bar graph) is drawn based on its corresponding column field value (e.g., sales volume).

[0113] In some embodiments, displaying the second chart includes:

[0114] Divide the graphics of the second chart into the second number of second graphic groups according to the second number of the second column fields; wherein each second graphic group includes a first number of graphics, and the first number is the number of column field values ​​of the first column field;

[0115] The second number of the second graphic groups are displayed in a second order and the first number of graphics in each of the second graphic groups are displayed in a first order.

[0116] by Figure 2B Taking the second chart shown as an example, the second column fields can be Q1, Q2, Q3, and Q4, so that the graph can be divided into four second graph groups, corresponding to Q1, Q2, Q3, and Q4 respectively. Then, since the column field values ​​of the first column field include Sales Department 1, Sales Department 2, and Sales Department 3, each second graph group can further include three graphs, corresponding to Sales Department 1, Sales Department 2, and Sales Department 3 respectively. Then, the four second graph groups are arranged and displayed in sequence according to the second order (i.e., the arrangement order of the second column fields), wherein the three graphs in each second graph group are arranged and displayed in sequence according to the first order (i.e., the arrangement order of the column field values ​​of the first column fields). The shape of each graph (e.g., the height of the bar graph) is drawn based on its corresponding column field value (e.g., sales volume).

[0117] In some embodiments, displaying the first chart includes: displaying the horizontal axis of the first chart based on the first column field and displaying the vertical axis of the first chart based on the second column field, and displaying a legend corresponding to the second column field at an associated position of the first chart.

[0118] For example, Figure 2A As shown in the figure, Sales Department 1, Sales Department 2, and Sales Department 3 displayed on the horizontal axis are the column field values ​​of the first column field. They can also be the coordinates on the horizontal axis, reflecting the arrangement order of the column field values ​​of the first column field along the horizontal axis. For example, Figure 2AAs shown, multiple numerical values ​​and corresponding scale lines are displayed on the vertical axis, corresponding to the column field values ​​of the second column field (for example, sales), which are used as reference values ​​for drawing the graph of the chart, and can be drawn according to the maximum value in the data table. For example, the maximum value in the data table is about 2200000, and the maximum scale line of the vertical axis can be the scale line corresponding to 2200000. For another example, the associated position of the first chart (for example, the upper left corner) displays the legend corresponding to the second column field, so that according to the legend, the user can know what the second column field is corresponding to each graph in the first chart. Then, according to the horizontal axis, vertical axis and legend, the various graphics of the first chart can be drawn based on the corresponding values, so that according to the display of the graphics, the user can intuitively compare the data corresponding to each field value.

[0119] In some embodiments, displaying the second chart includes: displaying the horizontal axis of the second chart based on the second column field and displaying the vertical axis of the second chart based on the first column field, and displaying a legend corresponding to the first column field at an associated position of the second chart.

[0120] For example, Figure 2B As shown in the figure, Q1, Q2, Q3, and Q4 displayed on the horizontal axis are the field names of the second column. They can also be the coordinates on the horizontal axis, reflecting the arrangement order of the second column fields along the horizontal axis. For example, Figure 2B As shown, multiple numerical values ​​and corresponding scale lines are displayed on the vertical axis, corresponding to the column field values ​​of the second column field corresponding to each column field value of the first column field (for example, sales), which are used as reference values ​​for drawing the graph of the chart, and can be drawn according to the maximum value in the data table. For example, the maximum value in the data table is about 2200000, and the maximum scale line of the vertical axis can be the scale line corresponding to 2200000. For another example, the associated position of the second chart (for example, the upper left corner) displays the legend corresponding to the first column field, so that according to the legend, the user can know what the column field value of the first column field corresponding to each graph in the second chart is. Then, according to the horizontal axis, vertical axis and legend, each graph of the second chart can be drawn based on the corresponding values, so that according to the display of the graph, the user can intuitively compare the data corresponding to each field value.

[0121] In some embodiments, the method further includes: in response to a row-column switching instruction for the second chart, displaying the first chart, such as Figure 2A In this way, by performing the row and column switching operation again, the first chart can be easily restored to display, and the user can change the presentation mode of the chart at any time through this operation.

[0122] It should be noted that the method of the embodiments of the present disclosure can be performed by a single device, such as a computer or server. The method of the embodiments of the present disclosure can also be applied in a distributed scenario, where multiple devices cooperate to perform the method. In such a distributed scenario, one of the multiple devices may only perform one or more steps of the method of the embodiments of the present disclosure, and the multiple devices will interact with each other to complete the method.

[0123] It should be noted that the above description is limited to some embodiments of the present disclosure. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in an order different from that described in the above embodiments and still achieve the desired results. Furthermore, the processes depicted in the accompanying drawings do not necessarily require the specific order or sequential order shown to achieve the desired results. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0124] The embodiment of the present disclosure also provides a computer device for implementing the above-mentioned chart configuration method. Figure 5 FIG2 shows a hardware structure diagram of an exemplary computer device 500 provided in an embodiment of the present disclosure. The computer device 500 can be used to implement the server 106 in FIG1 , or can be used to implement the terminal devices 102A and 102B in FIG1 . In some scenarios, the computer device 500 can also be used to implement the database server 108 in FIG1 .

[0125] like Figure 5 As shown, computer device 500 may include: processor 502, memory 504, network interface 506, peripheral interface 508 and bus 510. Processor 502, memory 504, network interface 506 and peripheral interface 508 are communicatively connected to each other within computer device 500 via bus 510.

[0126] The processor 502 may 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 may be used to perform functions related to the technology described in this disclosure. In some embodiments, the processor 502 may also include multiple processors integrated into a single logical component. For example, Figure 5 As shown, processor 502 may include multiple processors 502a, 502b, and 502c.

[0127] The memory 504 may be configured to store data (eg, instructions, computer code, etc.). Figure 5 As shown, the data stored in the memory 504 may include program instructions (for example, one or more programs for implementing the chart configuration method of the embodiment of the present disclosure) and data to be processed (for example, the memory may store configuration files of other modules, etc.). The processor 502 may also access the program instructions and data stored in the memory 504 and execute the program instructions to operate on the data to be processed. The memory 504 may include a volatile storage device or a non-volatile storage device. In some embodiments, the memory 504 may include a random access memory (RAM), a read-only memory (ROM), an optical disk, a magnetic disk, a hard disk, a solid-state drive (SSD), a flash memory, a memory stick, etc.

[0128] The network interface 506 can be configured to provide the computer device 500 with communication with other external devices 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)), a cellular network, the Internet, or a combination thereof. It will be understood that the type of network is not limited to the specific examples above.

[0129] The peripheral interface 508 can be configured to connect the computer device 500 to one or more peripheral devices to enable information input and output. For example, the peripheral devices can include input devices such as a keyboard, a mouse, a touchpad, a touch screen, a microphone, and various sensors, as well as output devices such as a display, a speaker, a vibrator, and an indicator light.

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

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

[0132] The embodiment of the present disclosure also provides a chart configuration device. Figure 6FIG. 6 is a schematic diagram of an exemplary device 600 provided in an embodiment of the present disclosure. Figure 6 As shown, the apparatus 600 may be used to implement a chart configuration method and may further include the following modules.

[0133] Display module 602 is configured to: display a first chart on a component page of a data table; wherein the first chart is drawn based on a plurality of column fields of the data table and corresponding column field values, the plurality of column fields including a first column field and a second column field, the first chart has the first column field as a horizontal axis and the second column field as a vertical axis, and the component page is a page independent of the data table;

[0134] The switching module 604 is configured to: display a second chart in response to a row and column switching instruction for the first chart; wherein the second chart is drawn based on the multiple column fields and the corresponding column field values, and the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis.

[0135] In some embodiments, the component page includes a row and column switching control;

[0136] The switching module 604 is configured to display the second chart in response to a trigger instruction of the row-column switching control.

[0137] In some embodiments, the component page includes a data source configuration item and / or a data range configuration item;

[0138] The display module 602 is configured to determine the multiple column fields and corresponding column field values ​​of the data table according to the configuration information of the data source configuration item and / or the data range configuration item.

[0139] In some embodiments, the display module 602 is configured to:

[0140] In response to the configuration information including a plurality of data sources, determining the number of field values ​​in the plurality of data sources corresponding to the target column field value;

[0141] In response to the number of field values ​​corresponding to the target column field value in the multiple data sources being one, using the field value as the target value corresponding to the target column field value;

[0142] In response to the number of field values ​​corresponding to the target column field value in the multiple data sources being multiple, the multiple field values ​​are aggregated and calculated based on a target aggregation method to obtain an aggregate value, and the aggregate value is used as the target value corresponding to the target column field value.

[0143] In some embodiments, the switching module 604 is configured to: in response to a row-column switching instruction for the first chart, display prompt information for prompting the user that the second chart is a chart after row-column switching based on the first chart.

[0144] In some embodiments, the display module 602 is configured to: divide the graphics of the first chart into a first number of first graphic groups according to a first number of column field values ​​of the first column field; wherein each of the first graphic groups includes a second number of graphics, and the second number is the number of the second column fields; display the first number of the first graphic groups in a first order and display the second number of graphics in each of the first graphic groups in a second order.

[0145] In some embodiments, the switching module 604 is configured to: divide the graphics of the second chart into the second number of second graphic groups according to the second number of the second column fields; wherein each of the second graphic groups includes a first number of graphics, and the first number is the number of column field values ​​of the first column field; display the second number of the second graphic groups in a second order and display the first number of graphics in each of the second graphic groups in a first order.

[0146] In some embodiments, the display module 602 is configured to: display the horizontal axis of the first chart based on the first column field and display the vertical axis of the first chart based on the second column field, and display a legend corresponding to the second column field at an associated position of the first chart.

[0147] In some embodiments, the switching module 604 is configured to: display the horizontal axis of the second chart based on the second column field and display the vertical axis of the second chart based on the first column field, and display a legend corresponding to the first column field at an associated position of the second chart.

[0148] In some embodiments, the switching module 604 is configured to: display the first chart in response to a row-column switching instruction for the second chart.

[0149] For the convenience of description, the above devices are described as being functionally divided into various modules. Of course, when implementing the present disclosure, the functions of each module can be implemented in the same or multiple software and / or hardware.

[0150] The apparatus of the above embodiment is used to implement the corresponding chart configuration method in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be described in detail here.

[0151] Based on the same inventive concept, corresponding to any of the above-mentioned embodiment methods, the present disclosure also provides a non-volatile computer-readable storage medium containing a computer program, which, when executed by one or more processors, enables the one or more processors to execute the chart configuration method.

[0152] The computer-readable media of this embodiment include permanent and non-permanent, removable and non-removable media that can be used to store information by any method or technology. 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 technology, read-only compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device.

[0153] The computer program stored in the storage medium of the above embodiment is used to enable the one or more processors to execute the chart configuration method described in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be repeated here.

[0154] Based on the same inventive concept, corresponding to any of the above-described embodiments of the chart configuration method, the present disclosure further provides a computer program product comprising 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 chart configuration method. For each step in each embodiment of the chart configuration method, the processor executing the step may belong to the corresponding execution entity.

[0155] The computer program product of the above embodiment is used to enable a processor to execute the chart configuration method described in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be described in detail here.

[0156] Those skilled in the art should understand that the discussion of any of the above embodiments is merely illustrative and is not intended to imply that the scope of the present disclosure (including the claims) is limited to these examples. Within the scope of the present disclosure, the technical features in the above embodiments or different embodiments may be combined, the steps may be implemented in any order, and there are many other variations of the different aspects of the embodiments of the present disclosure as described above, which are not provided in detail for the sake of simplicity.

[0157] In addition, to simplify the description and discussion, and so as not to obscure the embodiments of the present disclosure, known power / ground connections to integrated circuit (IC) chips and other components may or may not be shown in the provided figures. In addition, devices may be shown in the form of block diagrams to avoid obscuring the embodiments of the present disclosure, and this also takes into account the fact that the details of the implementation of these block diagram devices are highly dependent on the platform on which the embodiments of the present disclosure are to be implemented (i.e., these details should be fully within the purview of those skilled in the art). Where specific details (e.g., circuits) are set forth to describe exemplary embodiments of the present disclosure, it will be apparent to those skilled in the art that the embodiments of the present disclosure may be implemented without these specific details or with variations in these specific details. Therefore, these descriptions should be considered illustrative rather than restrictive.

[0158] Although the present disclosure has been described in conjunction with specific embodiments thereof, many alternatives, modifications, and variations of these embodiments will be apparent to those skilled in the art based on the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may use the embodiments discussed.

[0159] The embodiments of the present disclosure are intended to cover all such substitutions, modifications, and variations that fall within the broad scope of the appended claims. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the embodiments of the present disclosure should be included in the scope of protection of the present disclosure.

Claims

1. A chart configuration method, comprising: Displaying a first chart on a component page of a data table; wherein the first chart is drawn based on a plurality of column fields of the data table and corresponding column field values, the plurality of column fields including a first column field and a second column field, the first chart uses the first column field as a horizontal axis and the second column field as a vertical axis, and the component page is a page independent of the data table; In response to a row and column switching instruction for the first chart, a second chart is displayed; wherein the second chart is drawn based on the multiple column fields and the corresponding column field values, and the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis.

2. The method according to claim 1, wherein The component page includes a row and column switching control; The displaying of the second chart in response to the row-column switching instruction for the first chart includes: displaying the second chart in response to a triggering instruction of the row-column switching control.

3. The method according to claim 2, wherein: The component page includes data source configuration items and / or data range configuration items; The method further comprises: The multiple column fields and corresponding column field values ​​of the data table are determined according to the configuration information of the data source configuration item and / or the data range configuration item.

4. The method according to claim 3, wherein: The determining, according to the configuration information of the data source configuration item and / or the data range configuration item, the plurality of column fields and corresponding column field values ​​of the data table includes: In response to the configuration information including a plurality of data sources, determining the number of field values ​​in the plurality of data sources corresponding to the target column field value; In response to the number of field values ​​corresponding to the target column field value in the multiple data sources being one, using the field value as the target value corresponding to the target column field value; In response to the number of field values ​​corresponding to the target column field value in the multiple data sources being multiple, the multiple field values ​​are aggregated and calculated based on a target aggregation method to obtain an aggregate value, and the aggregate value is used as the target value corresponding to the target column field value.

5. The method of claim 1 , further comprising: In response to the row-column switching instruction for the first chart, prompt information is displayed, where the prompt information is used to prompt the user that the second chart is a chart obtained by switching the rows and columns based on the first chart.

6. The method of claim 1, wherein: The displaying of the first chart includes: Divide the graphics of the first chart into the first number of first graphic groups according to the first number of column field values ​​of the first column field; wherein each of the first graphic groups includes a second number of graphics, and the second number is the number of the second column field; The first number of the first graphic groups are displayed in a first order and the second number of graphics in each of the first graphic groups are displayed in a second order.

7. The method of claim 1, wherein: The displaying of the second chart includes: Divide the graphics of the second chart into the second number of second graphic groups according to the second number of the second column fields; wherein each second graphic group includes a first number of graphics, and the first number is the number of column field values ​​of the first column field; The second number of the second graphic groups are displayed in a second order and the first number of graphics in each of the second graphic groups are displayed in a first order.

8. The method of claim 1, wherein: The displaying of the first chart includes: displaying a horizontal axis of the first chart based on the first column of fields and displaying a vertical axis of the first chart based on the second column of fields, and displaying a legend corresponding to the second column of fields at an associated position of the first chart; and / or The displaying of the second chart includes: displaying the horizontal axis of the second chart based on the second column of fields and displaying the vertical axis of the second chart based on the first column of fields, and displaying a legend corresponding to the first column of fields at an associated position of the second chart.

9. The method of claim 1 , further comprising: In response to a row-column switching instruction for the second graph, the first graph is displayed.

10. A chart configuration device comprising: A display module is configured to: display a first chart on a component page of a data table; wherein the first chart is drawn based on a plurality of column fields of the data table and corresponding column field values, the plurality of column fields including a first column field and a second column field, the first chart uses the first column field as a horizontal axis and the second column field as a vertical axis, and the component page is a page independent of the data table; The switching module is configured to: display a second chart in response to a row and column switching instruction for the first chart; wherein the second chart is drawn based on the multiple column fields and the corresponding column field values, and the second chart uses the second column field as the horizontal axis and the first column field as the vertical axis.

11. 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 9.

12. 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 9.

13. 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 9 is implemented.

Images