Chart analysis method and system, device and medium

Abstract

Provided are a chart analysis method and system, a device and a medium. The method comprises: displaying a dashboard, the dashboard comprising at least one chart used for presenting a data statistical result, and the dashboard being generated on the basis of data of an online form; receiving a chart analysis operation for a target chart among the at least one chart; and displaying a chart analysis result of the target chart in an associated area of the target chart, wherein the chart analysis result is represented by natural language content, and the chart analysis result of the target chart is generated on the basis of a data statistical result of the target chart.

Description

Chart analysis method, system, device and medium

[0001] Cross-reference to related applications

[0002] This application claims priority to the Chinese Patent Application No. 202411067117.1, filed on August 5, 2024, and entitled "Chart analysis method, system, device and medium", the content of which is incorporated herein by reference in its entirety. TECHNICAL FIELD

[0003] The present application relates to the technical field of computer, and in particular, to a chart analysis method, system, electronic device and computer readable storage medium. BACKGROUND

[0004] With the rapid development of computer technology, online tables have emerged as the times require. Online tables are electronic tables that can be accessed and edited through the Internet, allowing multiple people to collaborate and share data simultaneously.

[0005] In some online table systems, a dashboard function is provided. The dashboard can display table data in online tables in the form of charts, enabling users to intuitively obtain data information. SUMMARY

[0006] The present application provides a chart analysis method. The present application also provides a system, an electronic device, a computer readable storage medium and a computer program product corresponding to the above method.

[0007] In a first aspect, the present application provides a chart analysis method, comprising:

[0008] displaying a dashboard, the dashboard comprising at least one chart for presenting data statistical results, the dashboard being generated based on table data of an online table;

[0009] receiving a chart analysis operation on a target chart in the at least one chart;

[0010] displaying a chart analysis result of the target chart in an associated area of the target chart; wherein the chart analysis result represents natural language content, and the chart analysis result of the target chart is generated based on data statistical results of the target chart.

[0011] In some possible implementation manners, the receiving a chart analysis operation on a target chart in the at least one chart comprises:

[0012] in response to a focus being located in a chart area of a target chart in the at least one chart, displaying a chart analysis control in the chart area of the target chart;

[0013] receiving a triggering operation for the chart analysis control.

[0014] In some possible implementation manners, the displaying, in the associated area of the target chart, of the chart analysis result of the target chart comprises:

[0015] displaying, in the associated area of the target chart, a chart analysis interface;

[0016] in response to the chart analysis result of the target chart starting to be generated, presenting, in the chart analysis interface, a streaming output process of the chart analysis result of the target chart.

[0017] In some possible implementation manners, the method further comprises:

[0018] in response to the data statistical result of the target chart changing, displaying, in the associated area of the target chart, identification information, the identification information being used to identify that the data statistical result changes.

[0019] In some possible implementation manners, the chart analysis result of the target chart comprises a first chart analysis result generated based on a data statistical result of a first time point and a second chart analysis result generated based on a data statistical result of a second time point, the second time point being after the first time point, and the data statistical result of the second time point being the same as the data statistical result of the first time point.

[0020] the displaying, in the associated area of the target chart, of the chart analysis result of the target chart comprises:

[0021] reading, from a cache, a first chart analysis result of the target chart;

[0022] determining the first chart analysis result of the target chart as a second chart analysis result of the target chart, and displaying, in the associated area of the target chart, the second chart analysis result of the target chart.

[0023] In some possible implementation manners, the chart analysis result of the target chart comprises a first chart analysis result generated based on a data statistical result of a first time point and a second chart analysis result generated based on a data statistical result of a second time point, the second time point being after the first time point, and the data statistical result of the second time point being different from the data statistical result of the first time point.

[0024] The method further comprises:

[0025] updating the first chart analysis result of the target chart in the cache to the second chart analysis result.

[0026] In some possible implementation manners, the method further includes:

[0027] receiving an analysis result viewing operation for a target chart in the at least one chart;

[0028] displaying a plurality of chart analysis results of the target chart in a historical time period.

[0029] In some possible implementation manners, the method further includes:

[0030] receiving a push configuration operation for the dashboard; wherein the push configuration operation is used to configure push information for pushing information related to the dashboard, and the push information includes at least one of the following: information indicating whether to push chart analysis results, information indicating a push time, and information indicating a push object.

[0031] In some possible implementation manners, the method further includes:

[0032] generating, according to the push configuration operation, a push request for the dashboard, and pushing information related to the dashboard to a push object; wherein the information related to the dashboard includes the at least one chart and / or chart analysis results related to the at least one chart.

[0033] In some possible implementation manners, the chart analysis results related to the at least one chart include: chart analysis results corresponding to the at least one chart, and / or chart analysis summary results generated based on the chart analysis results corresponding to the at least one chart.

[0034] In some possible implementation manners, the chart analysis results of the target chart are generated by the following steps:

[0035] generating prompt information based at least on the data statistics result of the target chart, the prompt information indicating a generation process of a language model generating chart analysis results;

[0036] processing the prompt information by using the language model to obtain chart analysis results of the target chart returned by the language model.

[0037] In some possible implementation manners, the method further includes:

[0038] receiving a configuration operation for a prompt template, the configuration operation being used to configure a prompt template indicating chart analysis requirements and / or a prompt template indicating a chart analysis result format;

[0039] generating the prompt information based at least on the chart analysis results of the target chart includes:

[0040] generate prompt information based on the data statistical result of the target chart and the prompt template.

[0041] In some possible implementation manners, after the chart analysis result of the target chart is displayed, the method further includes:

[0042] In an associated area of the target chart, receiving conversation information for the chart analysis result of the target chart, the conversation information representing natural language content;

[0043] displaying reply information of the conversation information.

[0044] In a second aspect, the present application provides a chart analysis system, the system comprising:

[0045] a display module configured to display a dashboard, the dashboard comprising at least one chart for presenting a data statistical result, the dashboard being generated based on table data of an online table;

[0046] a receiving module configured to receive a chart analysis operation for a target chart in the at least one chart;

[0047] The display module is further configured to display a chart analysis result of the target chart in an associated area of the target chart, wherein the chart analysis result represents natural language content, and the chart analysis result of the target chart is generated based on a data statistical result of the target chart.

[0048] In some possible implementation manners, the receiving module is specifically configured to:

[0049] In response to a focus being located in a chart area of a target chart in the at least one chart, display a chart analysis control in the chart area of the target chart;

[0050] receive a triggering operation for the chart analysis control.

[0051] In some possible implementation manners, the display module is specifically configured to:

[0052] display a chart analysis interface in an associated area of the target chart;

[0053] In response to a chart analysis result of the target chart starting to be generated, present a streaming output process of the chart analysis result of the target chart in the chart analysis interface.

[0054] In some possible implementation manners, the display module is further configured to:

[0055] In response to a change in the data statistics result of the target chart, display identification information in the associated area of the target chart, the identification information being used to identify the change in the data statistics result.

[0056] In some possible implementation manners, the chart analysis result of the target chart includes a first chart analysis result generated based on a data statistics result of a first time point and a second chart analysis result generated based on a data statistics result of a second time point, the second time point being after the first time point, and the data statistics result of the second time point being the same as the data statistics result of the first time point; and the display module is specifically configured to:

[0057] read the first chart analysis result of the target chart from the cache;

[0058] determine the first chart analysis result of the target chart as the second chart analysis result of the target chart, and display the second chart analysis result of the target chart in the associated area of the target chart.

[0059] In some possible implementation manners, the chart analysis result of the target chart includes a first chart analysis result generated based on a data statistics result of a first time point and a second chart analysis result generated based on a data statistics result of a second time point, the second time point being after the first time point, and the data statistics result of the second time point being different from the data statistics result of the first time point; and the system further includes an update module, the update module being configured to:

[0060] update the first chart analysis result of the target chart in the cache to the second chart analysis result.

[0061] In some possible implementation manners, the display module is further configured to:

[0062] receive an analysis result viewing operation on a target chart in the at least one chart;

[0063] display a plurality of chart analysis results of the target chart in a historical time period.

[0064] In some possible implementation manners, the receiving module is further configured to:

[0065] receive a push configuration operation on the dashboard; wherein the push configuration operation is used to configure push information for pushing information related to the dashboard, the push information including at least one of the following: information indicating whether to push a chart analysis result, information indicating a push time, and information indicating a push object.

[0066] In some possible implementation manners, the system further includes a push module, the push module being configured to:

[0067] According to the push configuration operation, a push request is generated for the dashboard, and information related to the dashboard is pushed to a push object; wherein the information related to the dashboard includes the at least one chart and / or chart analysis results related to the at least one chart.

[0068] In some possible implementation manners, the chart analysis results related to the at least one chart include chart analysis results corresponding to the at least one chart, and / or chart analysis summary results generated based on the chart analysis results corresponding to the at least one chart.

[0069] In some possible implementation manners, the chart analysis results of the target chart are generated through the following steps:

[0070] The prompt information is generated based at least on the data statistical result of the target chart, and the prompt information indicates a generation process of the language model generating the chart analysis results;

[0071] The prompt information is processed by using the language model, and the chart analysis results of the target chart returned by the language model are obtained.

[0072] In some possible implementation manners, the receiving module is further configured to:

[0073] The configuration operation for the prompt template is received, and the configuration operation is used for configuring a prompt template indicating a chart analysis requirement and / or configuring a prompt template indicating a chart analysis result format;

[0074] The prompt information is generated based at least on the chart analysis results of the target chart, and the prompt information includes:

[0075] The prompt information is generated based on the data statistical result of the target chart and the prompt template.

[0076] In some possible implementation manners, the display module is further configured to:

[0077] In the associated area of the target chart, the dialog information of the chart analysis results of the target chart is received, and the dialog information represents natural language content;

[0078] The reply information of the dialog information is displayed.

[0079] In a third aspect, the present application provides an electronic device, the electronic device comprising a processor and a memory. The processor and the memory are in communication with each other. The processor is configured to execute instructions stored in the memory, so that the electronic device performs the chart analysis method in the first aspect or any implementation manner of the first aspect.

[0080] In a fourth aspect, the present application provides a computer readable storage medium, wherein the computer readable storage medium stores instructions, and the instructions instruct an electronic device to perform the chart analysis method in the first aspect or any implementation manner of the first aspect.

[0081] In a fifth aspect, the present application provides a computer program product comprising instructions which, when executed on an electronic device, cause the electronic device to perform the chart analysis method in the first aspect or any implementation manner of the first aspect.

[0082] On the basis of the implementation manners of the above aspects, the present application can be further combined to provide more implementation manners. BRIEF DESCRIPTION OF DRAWINGS

[0083] In order to more clearly illustrate the technical method of the embodiments of the present application, the drawings required to be used in the embodiments will be briefly introduced as follows.

[0084] FIG. 1 is a schematic diagram of a dashboard page provided by an embodiment of the present application;

[0085] FIG. 2 is a flowchart of a chart analysis method provided by an embodiment of the present application;

[0086] FIGS. 3A to 3D are schematic diagrams of a dashboard page provided by an embodiment of the present application;

[0087] FIG. 4 is a schematic diagram of a prompt template configuration page provided by an embodiment of the present application;

[0088] FIG. 5 is a schematic diagram of a push configuration page provided by an embodiment of the present application;

[0089] FIG. 6 is a schematic diagram of an instant messaging page provided by an embodiment of the present application;

[0090] FIG. 7 is a structural schematic diagram of a chart analysis system provided by an embodiment of the present application;

[0091] FIG. 8 is a structural schematic diagram of an electronic device provided by an embodiment of the present application. DETAILED DESCRIPTION

[0092] The terms “first” and “second” in the embodiments of the present application are only for descriptive purposes, and cannot be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined with “first” and “second” can explicitly or implicitly include one or more of the features.

[0093] First, some technical terms involved in the embodiments of the present application are introduced.

[0094] An online form is an electronic form that can be accessed and edited through the Internet, allowing multiple people to collaborate and share data at the same time. Specifically, an online form can be provided by an online form system (e.g., an online form application), through which a user can create an online form or enter an online form created by others and add, delete, or modify data in the online form. Data recorded in an online form can be referred to as form data.

[0095] An online form system can provide a dashboard function. The dashboard, which can also be referred to as a data board or a data report, is used to statistically analyze data from different dimensions and visually display the data through various chart types such as bar charts, column charts, line charts, and the like. For example, in a project operation scenario, operation data is recorded in an online form, and a dashboard can visually display the operation data to facilitate users to intuitively observe data changes. For another example, in a project management scenario, project data is recorded in an online form, and a dashboard can visually display the project data to facilitate users to make project decisions.

[0096] A user can set a chart type and a data range in a dashboard. Specifically, the user can set a data source (e.g., a certain online form), filter data (e.g., certain fields in an online form), set a chart type (e.g., a line chart), and configure the specific display manner of the chart. In this way, the user can intuitively obtain data information such as data change information and comparison information of different data categories through the dashboard.

[0097] With reference to a specific example, referring to a schematic diagram of a dashboard page shown in FIG. 1, the dashboard 30 includes a chart 101, a chart 102, and a chart 103. The chart 101 is a statistical number type chart used to statistically sum up a category of data, and can also calculate the maximum value, minimum value, or average value of a category of data. The chart 102 is a pie chart type chart used to analyze the proportion relationship between multiple different category data and overall data. The chart 103 is a column chart type chart used to compare the size relationship between multiple different category data.

[0098] However, in a complex business scenario, there are many data categories and the charts in the dashboard are relatively complex, making it difficult for a user to quickly understand the data information conveyed by various professional charts in the dashboard. The user needs to have certain chart professional knowledge, which has a certain use threshold, and the efficiency of using the dashboard for data insight is relatively low.

[0099] Therefore, the present application provides a chart analysis method. The method first displays a dashboard, wherein the dashboard includes at least one chart for presenting a data statistical result, the dashboard is generated based on table data of an online table, receives a chart analysis operation on a target chart in the at least one chart, and then displays a chart analysis result of the target chart in an associated area of the target chart, wherein the chart analysis result represents natural language content, and the chart analysis result of the target chart is generated based on the data statistical result of the target chart.

[0100] In the method, a user can trigger a chart analysis operation on a chart displayed in a dashboard, so that the user is displayed a chart analysis result generated by analyzing a data statistical result in the chart. Since the chart analysis result is described in natural language, complex and professional chart information is converted into easy-to-understand text information, the threshold for the user to understand the data statistical result in the dashboard is lowered, and the data insight efficiency is improved.

[0101] To make the technical solutions of the embodiments of the present application clearer, the following will be described with reference to the accompanying drawings.

[0102] Referring to a flowchart of a chart analysis method provided by an embodiment of the present application shown in FIG. 2, the method specifically includes the following steps.

[0103] S201: Display a dashboard.

[0104] The dashboard includes at least one chart for presenting a data statistical result. Different types of charts can represent different data statistical results. For example, a column chart type chart and a bar chart type chart can be used to compare different categories of data, a line chart type chart can be used to view the trend of data change, and a pie chart type chart can be used to analyze the relationship between part data and whole data.

[0105] In the embodiment of the present application, the dashboard is generated based on table data of an online table. That is, the chart in the dashboard can present a data statistical result obtained by statistical analysis on table data in the online table.

[0106] When implemented, the online table system can provide a dashboard page, and the dashboard is displayed in the dashboard page. In this way, a user can intuitively view the data statistical result of the online table in the form of a chart.

[0107] S202: Receive a chart analysis operation on a target chart in the at least one chart.

[0108] The chart analysis operation can be understood as an operation of analyzing a data statistical result, and the target chart can be understood as a chart in the dashboard that needs to be analyzed.

[0109] Since the dashboard presents the data statistics in the form of charts, after the user views at least one chart through the dashboard, the user still needs to analyze, understand and infer the data statistics, determine the data categories in the chart, observe the data distribution, analyze the data trend in the chart, and combine professional business knowledge to mine the information conveyed by the chart, and the chart analysis is difficult.

[0110] Therefore, in the embodiment of the present application, a chart analysis function is provided in the dashboard. By triggering a chart analysis operation by the user, an artificial intelligence (AI) intelligent analysis is performed on the data statistics of the chart, and automatic analysis is realized for the target chart.

[0111] In specific implementation, in response to the focus being located in the chart area of the target chart in the at least one chart, the chart analysis control can be displayed in the chart area of the target chart, and a triggering operation on the chart analysis control can be received.

[0112] Wherein, the focus can be used to indicate the control position. In some embodiments, the client of the online table system is deployed in a personal computer (PC), at this time, the focus can be a cursor, and the control position can be the position of the cursor. In other embodiments, the client of the online table system is deployed in a mobile device (such as a mobile phone or a tablet computer), and the mobile device supports touch operation, at this time, the focus can be an entity triggering the touch operation, such as a finger or a stylus, and the control position can be the touch position of the finger or the stylus.

[0113] That is, when the focus is placed (hovered) on the chart area of the target chart, the chart analysis control is displayed in the chart area of the target chart, and the user can trigger the chart analysis operation on the target chart by triggering the chart analysis control. In this way, the chart analysis function is provided for each chart in the dashboard without affecting the original chart display mode of the dashboard.

[0114] The embodiment of the present application does not limit the way of triggering the chart analysis operation, in some possible implementation ways, the chart analysis control can also be displayed in the dashboard page, after receiving the triggering operation on the chart analysis control, a chart selection interface including at least one chart is displayed, and by receiving the selection operation on the target chart triggered in the chart selection interface, the chart analysis operation on the target chart is triggered.

[0115] S203: In the associated area of the target chart, the chart analysis result of the target chart is displayed.

[0116] The associated area of the target chart can be understood as an area associated with the chart area of the target chart, for example, an area that has an overlapping part with the chart area of the target chart.

[0117] In the embodiments of the present application, the chart analysis result represents natural language content, and the chart analysis result can be generated based on the data statistical result of the target chart. That is, by analyzing the data statistical result of the target chart, the graphical data statistical result is converted into text described in natural language. In this way, the user can understand the data information conveyed by the data statistical result of the target chart by viewing the chart analysis result.

[0118] In some possible implementations, considering that the chart analysis result can be long, the chart analysis result can be sent to the client of the online table system in a streaming output manner. Therefore, the chart analysis interface is displayed in the associated area of the target chart, and the streaming output process of the chart analysis result of the target chart is presented in the chart analysis interface in response to the generation of the chart analysis result of the target chart.

[0119] The chart analysis interface can be understood as an interface for presenting the chart analysis result. In some embodiments, the chart analysis interface can be displayed in the form of a floating window component and suspended in the associated area of the target chart.

[0120] In the embodiments of the present application, the generated character (token) is displayed in the chart analysis interface in real time during the generation of the chart analysis result, so as to show the user the real-time generation process of the chart analysis result and avoid long waiting time of the user, thereby improving the user experience.

[0121] In some embodiments, the display height of the chart analysis interface can be adaptively adjusted based on the text length of the chart analysis result. If the text length of the chart analysis result exceeds the maximum display height of the chart analysis interface, a scrolling control can be provided in the chart analysis interface, so that the user can scroll to view the chart analysis result.

[0122] In addition, after the generation of the chart analysis result is completed, the generation time can also be displayed in the chart analysis interface. Furthermore, a copy control and a feedback control can also be provided in the chart analysis interface. The user can copy the text content of the chart analysis result through the copy control, and can also feed back the chart analysis result through the feedback control, for example, a "like" control representing positive feedback and a "dislike" control representing negative feedback.

[0123] Further, after the chart analysis result of the target chart is displayed, the conversation information for the chart analysis result of the target chart can also be received in the associated area of the target chart, and the reply information of the conversation information is displayed. The conversation information represents natural language content.

[0124] That is, after completing the chart analysis on the target chart, the user can also have a dialogue on the chart analysis result. For example, the user can input dialogue information representing a question, and view reply information for the question, realizing a round of human-computer dialogue.

[0125] In this way, after the chart analysis on the target chart, the user is supported to further mine the chart analysis result, facilitating the user to better understand the chart analysis result and the data statistical result of the target chart, realizing deep analysis on the target chart, and meeting the personalized analysis needs of the user.

[0126] In this method, the user can trigger a chart analysis operation on the chart displayed in the dashboard, so that the chart analysis result generated after analyzing the data statistical result in the chart is displayed to the user. Since the chart analysis result is described in natural language, complex and professional chart information is converted into easy-to-understand text information, reducing the threshold for the user to understand the data statistical result in the dashboard and improving the data insight efficiency.

[0127] The generation process of the chart analysis result will be introduced below.

[0128] In the embodiments of the present application, the chart analysis result can be generated with the aid of a language model. The language model has natural language processing capability and can recognize, analyze and generate natural language content, and can process different types of natural language tasks. For example, the language model can be a deep learning model trained using text data.

[0129] Specifically, at least based on the data statistical result of the target chart, prompt information is generated, which indicates the generation process of the language model generating the chart analysis result, and then the prompt information is processed using the language model to obtain the chart analysis result of the target chart returned by the language model.

[0130] In other words, the chart analysis result is generated based on the prompt learning in the embodiments of the present application. In the generation task (such as a text generation task, a question and answer task, a dialogue task), the prompt information (prompt) can be used to guide the language model to make specific output. By generating prompt information, the language model is helped to understand the background and needs of the task, so that the language model can process different types of natural language processing tasks without retraining the language model, increasing the scalability and flexibility of the language model.

[0131] In the embodiments of the present application, the prompt information can include the data statistical result of the target chart and the instruction for chart analysis. Through the prompting capability of the prompt information, the language model is instructed to analyze the data statistical result of the target chart, and the target chart analysis result meeting the needs is generated, realizing automatic analysis on the target chart.

[0132] The embodiment of the present application also supports user self-configuration of prompt templates. Specifically, a configuration operation for a prompt template is received, the configuration operation being used for configuring a prompt template indicating a chart analysis requirement and / or configuring a prompt template indicating a chart analysis result format.

[0133] In other words, the user can configure different prompt templates according to a specific target chart and a specific chart analysis requirement or a format of a chart analysis result, so that the language model generates a chart analysis result meeting the chart analysis requirement of the user or the format of the chart analysis result, improves the applicability and flexibility of the chart analysis method, and enriches the use scenarios of the chart analysis method.

[0134] In the process of using the online table by the user, the table data can change in real time, and the chart in the dashboard can change with the change of the table data, and the data statistical result is updated in real time.

[0135] In the embodiment of the present application, in response to a change in the data statistical result of the target chart, identification information can be displayed in the associated area of the target chart. The identification information can be used to identify the change in the data statistical result.

[0136] That is, when the user triggers a chart analysis operation for the target chart and generates a chart analysis result of the target chart, if the data statistical result of the target chart changes, the user can be informed of the change in the data statistical result of the target chart by displaying the identification information, so as to update the chart analysis result, and ensure the real-time of the chart analysis result.

[0137] The embodiment of the present application does not limit the form of the identification information. For example, the identification information can be displayed in the form of a prompt box, and for another example, the identification information can be displayed in the form of an identification symbol (such as a red dot).

[0138] Considering that the data statistical result can change, the embodiment of the present application also supports the user repeatedly triggering a chart analysis operation for the target chart. In specific implementation, first, a chart analysis operation for a target chart in at least one chart triggered at a first time can be received, and a first chart analysis result of the target chart is displayed in an associated area of the target chart. The first chart analysis result is generated based on a data statistical result of the target chart at the first time.

[0139] Then, a chart analysis operation for the target chart in at least one chart triggered at a second time can be received, and a second chart analysis result of the target chart is displayed in the associated area of the target chart. The second time is after the first time, and the second chart analysis result is generated based on a data statistical result of the target chart at the second time.

[0140] That is, after the user triggers the chart analysis operation for the target chart at the first time, the first chart analysis result is generated based on the data statistical result of the target chart at the first time, and one chart analysis is completed. Thereafter, the user can trigger the chart analysis operation for the target chart again at the second time, and generate the chart analysis result (i.e., the second chart analysis result) again based on the data statistical result of the target chart at the second time, so as to update the chart analysis result of the target chart, so that the data statistical result and the chart analysis result are consistent, and the latest chart analysis result is displayed to the user.

[0141] In some embodiments, the data statistical result of the target chart at the second time is the same as the data statistical result of the target chart at the first time. In other words, the data statistical result of the target chart does not change, but the user triggers the chart analysis operation for the target chart again. At this time, the first chart analysis result of the target chart is read from the cache, the first chart analysis result of the target chart is determined as the second chart analysis result of the target chart, and the second chart analysis result of the target chart is displayed in the associated area of the target chart.

[0142] That is, after the chart analysis is performed on the target chart, the chart analysis result can be stored in the cache. When the user triggers the chart analysis operation for the target chart again, it is judged whether the data statistical result of the current chart analysis and the last chart analysis changes. If it does not change, the first chart analysis result generated by the last chart analysis is directly read from the cache and displayed to the user, without the need to generate the chart analysis result again, saving the computing resources and improving the chart analysis efficiency.

[0143] In other embodiments, the data statistical result of the target chart at the second time is different from the data statistical result of the target chart at the first time. In other words, the data statistical result of the target chart changes, and the user triggers the chart analysis operation for the target chart again. At this time, the first chart analysis result of the target chart in the cache is updated to the second chart analysis result.

[0144] That is, when the user triggers the chart analysis operation for the target chart again, it is judged whether the data statistical result of the current chart analysis and the last chart analysis changes. If it changes, the second chart analysis result is regenerated based on the data statistical result of the target chart at the second time, the chart analysis result stored in the cache is updated, and the real-time of the chart analysis result stored in the cache is ensured.

[0145] Further, the embodiments of the present application also support the user to view the historical version of the chart analysis result. Specifically, the analysis result viewing operation for the target chart in the at least one chart is received, and the multiple chart analysis results of the target chart in the historical time period are displayed.

[0146] The historical time period can be pre-configured by the user, for example, the historical time period can be within 1 week, within 1 month, etc. Since the user can trigger the chart analysis operation for the same target chart multiple times, by showing the user multiple chart analysis results, the user can compare the trend changes of the multiple chart analysis results.

[0147] In some embodiments, the online table system supports a push function of the dashboard. That is, a push configuration operation for the dashboard can be received. The push configuration operation can be used to configure push information for pushing information related to the dashboard. The push information can include at least one of the following: information indicating whether to push the chart analysis result, information indicating a push time, and information indicating a push object. In this way, the user can choose whether to push the chart analysis result together when pushing the dashboard, the time of pushing the dashboard and / or the chart analysis result, and the object of pushing the dashboard and / or the chart analysis result, thereby realizing the function of automatically pushing information related to the dashboard to the push object, so that the push object can view the data statistical result in the dashboard without logging in the online table system.

[0148] In specific implementation, according to the push configuration operation, a push request for the dashboard is generated, and information related to the dashboard is pushed to the push object. The information related to the dashboard includes at least one chart and / or chart analysis result related to the at least one chart.

[0149] That is, when the push time is reached, the charts and chart analysis results in the dashboard are pushed to the push object together, so that the push object can view the charts and chart analysis results together, enriching the push content.

[0150] In some possible implementation manners, the online table system can be deployed in an office automation (OA) system. The OA system, which can also be referred to as a business system or a business platform, includes multiple functional modules providing different functions, such as an instant messaging module, a form module, a task management module, a meeting module, a schedule module, etc. At this time, the online table system can push the information related to the dashboard to the instant messaging module of the push object, and display the information related to the dashboard in the instant messaging page provided by the instant messaging module, to realize the push in the form of instant messaging messages.

[0151] In other possible implementation manners, the push of the dashboard can also be realized by means of email, etc., which is not limited in the embodiments of the present application.

[0152] In the embodiments of the present application, the chart analysis result related to the at least one chart includes: a chart analysis result corresponding to the at least one chart, and / or a chart analysis summary result generated based on the chart analysis result corresponding to the at least one chart.

[0153] That is, when pushing the dashboard related information to the push object, the chart analysis result of a single chart can be pushed, or the chart analysis summary result can be generated according to the chart analysis result of a single chart, and the chart analysis summary result is pushed. In this way, the push object can view the chart analysis result generated after analysis from different chart dimensions, and can also view the summary result generated after summarizing different chart analysis results, enrich the push content, and meet the diversified needs of users.

[0154] The foregoing describes the chart analysis method provided by the present application, and the following introduces a specific scenario.

[0155] As shown in FIGS. 3A to 3D, a schematic diagram of a dashboard page, in FIG. 3A, the dashboard page 30 includes three charts, when the focus 301 is located at the chart area of the target chart "pie chart", the chart analysis control 302 is displayed in the chart area of the target chart "pie chart". In this way, the user can trigger the chart analysis operation for the target chart "pie chart" by triggering the chart analysis control 302.

[0156] In FIG. 3B, the chart analysis interface 303 is displayed in the associated area of the target chart "pie chart" of the dashboard page 30. In the chart analysis interface 303, the chart analysis result of the target chart "pie chart" is displayed, for example, the chart analysis result can include "insight and suggestion" and "data profile".

[0157] In FIG. 3C, the dashboard page 30 includes a chart analysis interface, and the input box 304 is provided in the chart analysis interface. After the chart analysis result is displayed to the user, the user can input the dialogue information through the input box 304, and further dig and ask questions about the generated chart analysis result, thereby further reducing the understanding threshold of the user for the data statistics result.

[0158] In FIG. 3D, after completing the chart analysis for the target chart, if the data statistics result of the target chart "pie chart" changes, the identification information 305 is displayed. Specifically, when the focus is located at the chart area of the target chart "pie chart" again, and the data statistics result of the target chart "pie chart" changes, the identification information "·" can be displayed beside the chart analysis control, to inform the user that the data statistics result of the target chart changes, and the chart analysis result can be updated.

[0159] As shown in a prompt template configuration page diagram in FIG. 4, a user can configure a prompt template for a target chart in the prompt template configuration page 40, for example, the user can configure a prompt template indicating chart analysis requirements and a prompt template indicating chart analysis result format. In this way, a chart analysis result meeting the user's analysis requirements and output format is generated.

[0160] As shown in a push configuration page diagram in FIG. 5, a user can configure a push dashboard in the push configuration page 50, for example, the user can configure the time of the push dashboard and the push object. In addition, the user can also select whether to push the chart analysis result (i.e., the AI intelligent summary notification in FIG. 5) together, enriching the push content.

[0161] As shown in an instant messaging page diagram in FIG. 6, when pushing dashboard related information to an instant messaging module of a push object, the dashboard related information can be displayed in the instant messaging page 60. For example, when pushing in the identity of a "dashboard robot", the instant messaging page 60 can be an instant messaging page of the push object and the dashboard robot, and in the instant messaging page 60, chart analysis results corresponding to at least one chart and chart analysis summary results generated based on the chart analysis results corresponding to at least one chart are displayed.

[0162] The chart analysis method provided by the embodiments of the present application is described in detail above in combination with FIGS. 1 to 6, and the system and device provided by the embodiments of the present application will be introduced below in combination with the drawings.

[0163] Referring to a structural diagram of a chart analysis system shown in FIG. 7, the system 70 includes:

[0164] The display module 701 is configured to display a dashboard, the dashboard including at least one chart for presenting a data statistical result, the dashboard being generated based on table data of an online table;

[0165] The receiving module 702 is configured to receive a chart analysis operation for a target chart in the at least one chart;

[0166] The display module 701 is further configured to display a chart analysis result of the target chart in an associated area of the target chart, wherein the chart analysis result represents natural language content, and the chart analysis result of the target chart is generated based on the data statistical result of the target chart.

[0167] In some possible implementation manners, the receiving module 702 is specifically configured to:

[0168] In response to the focus being located in a chart region of a target chart in the at least one chart, a chart analysis control is displayed in the chart region of the target chart.

[0169] A triggering operation for the chart analysis control is received.

[0170] In some possible implementation manners, the display module 701 is specifically configured to:

[0171] A chart analysis interface is displayed in the associated region of the target chart.

[0172] In response to the chart analysis result of the target chart starting to be generated, a streaming output process of the chart analysis result of the target chart is presented in the chart analysis interface.

[0173] In some possible implementation manners, the display module 701 is further configured to:

[0174] In response to the data statistical result of the target chart changing, identification information is displayed in the associated region of the target chart, and the identification information is used to identify that the data statistical result changes.

[0175] In some possible implementation manners, the chart analysis result of the target chart includes a first chart analysis result generated based on a first time point data statistical result and a second chart analysis result generated based on a second time point data statistical result, the second time point is after the first time point, and the second time point data statistical result is the same as the first time point data statistical result; and the display module 701 is specifically configured to:

[0176] The first chart analysis result of the target chart is read from the cache.

[0177] The first chart analysis result of the target chart is determined as the second chart analysis result of the target chart, and the second chart analysis result of the target chart is displayed in the associated region of the target chart.

[0178] In some possible implementation manners, the chart analysis result of the target chart includes a first chart analysis result generated based on a first time point data statistical result and a second chart analysis result generated based on a second time point data statistical result, the second time point is after the first time point, and the second time point data statistical result is different from the first time point data statistical result; and the system further includes an update module, the update module is configured to:

[0179] The first chart analysis result of the target chart in the cache is updated as the second chart analysis result.

[0180] In some possible implementation manners, the display module 701 is further configured to:

[0181] receiving an analysis result viewing operation for a target chart in the at least one chart;

[0182] displaying a plurality of chart analysis results of the target chart in a historical time period.

[0183] In some possible implementation manners, the receiving module 702 is further configured to:

[0184] receiving a push configuration operation for the dashboard, wherein the push configuration operation is used to configure push information for pushing information related to the dashboard, and the push information comprises at least one of the following: information indicating whether to push chart analysis results, information indicating a push time, and information indicating a push object.

[0185] In some possible implementation manners, the system further comprises a pushing module, configured to:

[0186] generating, according to the push configuration operation, a push request for the dashboard, and pushing information related to the dashboard to a push object, wherein the information related to the dashboard comprises the at least one chart and / or chart analysis results related to the at least one chart.

[0187] In some possible implementation manners, the chart analysis results related to the at least one chart comprise chart analysis results corresponding to the at least one chart, and / or chart analysis summary results generated based on the chart analysis results corresponding to the at least one chart.

[0188] In some possible implementation manners, the chart analysis result of the target chart is generated by the following steps:

[0189] generating prompt information based at least on the data statistical result of the target chart, wherein the prompt information indicates a generation process of a language model generating a chart analysis result;

[0190] processing the prompt information by using the language model, to obtain the chart analysis result of the target chart returned by the language model.

[0191] In some possible implementation manners, the receiving module 702 is further configured to:

[0192] receiving a configuration operation for a prompt template, wherein the configuration operation is used to configure a prompt template indicating a chart analysis requirement and / or a prompt template indicating a chart analysis result format;

[0193] generating the prompt information based at least on the chart analysis result of the target chart comprises:

[0194] Generate prompt information based on the data statistics result of the target chart and the prompt template.

[0195] In some possible implementation manners, the display module 701 is further configured to:

[0196] In the associated area of the target chart, receive dialogue information of a chart analysis result of the target chart, the dialogue information representing natural language content.

[0197] Display reply information of the dialogue information.

[0198] The chart analysis system 70 according to the embodiments of the present application can correspond to performing the methods described in the embodiments of the present application, and the above and other operations and / or functions of the various modules / units of the chart analysis system 70 are respectively for realizing the corresponding flows of the various methods in the embodiments shown in FIG. 2, and for brevity, will not be repeated here.

[0199] The embodiments of the present application also provide an electronic device. The electronic device is specifically used to implement the functions of the chart analysis system 70 in the embodiments shown in FIG. 7.

[0200] FIG. 8 provides a structural schematic diagram of an electronic device 800. As shown in FIG. 8, the electronic device 800 includes a bus 801, a processor 802, a communication interface 803 and a memory 804. The processor 802, the memory 804 and the communication interface 803 communicate through the bus 801.

[0201] The bus 801 can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. For the convenience of representation, only one thick line is used in FIG. 8, but it does not mean that there is only one bus or only one type of bus.

[0202] The processor 802 can be any one or more of a central processing unit (CPU), a graphics processing unit (GPU), a micro processor (MP), or a digital signal processor (DSP) and the like.

[0203] The communication interface 803 is used for external communication. For example, the communication interface 803 can be used for communication with a terminal.

[0204] The memory 804 can include volatile memory, such as random access memory (RAM), and non-volatile memory, such as read-only memory (ROM), floppy disks, hard disks, or solid state drives (SSDs).

[0205] The executable code is stored in the memory 804, and the processor 802 executes the executable code to perform the aforementioned chart analysis method.

[0206] Specifically, in the case of implementing the embodiment shown in FIG. 7, and in the case that each module or unit of the chart analysis system 70 described in the embodiment of FIG. 7 is implemented by software, the software or program code required to perform the functions of each module / unit in FIG. 7 can be partially or entirely stored in the memory 804. The processor 802 executes the program code corresponding to each unit stored in the memory 804 to perform the aforementioned chart analysis method.

[0207] The embodiments of the present application also provide a computer readable storage medium. The computer readable storage medium can be any available medium or data storage device that can be accessed by a computing device, such as a data center or the like. The available medium can be a magnetic medium (such as a floppy disk, a hard disk, a magnetic tape), an optical medium (such as a DVD), or a semiconductor medium (such as a solid state disk), etc. The computer readable storage medium includes instructions that instruct a computing device to perform the chart analysis method described above and applied to the chart analysis system 70.

[0208] The embodiments of the present application also provide a computer program product including one or more computer instructions. When the computer instructions are loaded and executed on a computing device, all or part of the processes or functions described in the embodiments of the present application are generated.

[0209] The computer instructions can be stored in a computer readable storage medium, or transmitted from one computer readable storage medium to another computer readable storage medium, for example, the computer instructions can be transmitted from one website, computer or data center to another website, computer or data center through wired (such as coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (such as infrared, wireless, microwave, etc.) mode.

[0210] The computer program product is executed by a computer, and the computer executes any one of the preceding chart analysis methods. The computer program product can be a software installation package, and when any one of the preceding chart analysis methods needs to be used, the computer program product can be downloaded and executed on the computer.

[0211] The flow and block diagrams in the drawings show the possible architectural, functional, and operational architectures of systems, methods, and computer program products according to various embodiments of the present application. In this regard, each block in the flow and block diagrams can represent a module, a segment, or a portion of code that comprises one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions noted in the blocks can occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently or in the reverse order, depending on the functionality involved. It will also be noted that each block in the block diagrams and / or flowchart illustrations, and combinations of blocks in the block diagrams and / or flowchart illustrations, can be implemented by a dedicated hardware-based system that performs the specified functions or operations, or a combination of dedicated hardware and computer instructions.

[0212] The units described in the embodiments of the present application can be implemented by software, or can be implemented by hardware. In some cases, the name of the unit / module does not constitute a limitation on the unit itself.

[0213] The functions described above in the present document can be performed at least in part by one or more hardware logic components. For example, non-limiting examples of exemplary types of hardware logic components that can be used include field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), system-on-a-chip (SOCs), complex programmable logic devices (CPLDs), etc.

[0214] In the context of the embodiments of the present application, a machine-readable medium can be a tangible medium that contains or stores a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include but is not limited to an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of the machine-readable storage medium will include one or more lines of electrical connections, portable computer disks, hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or Flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination of the foregoing.

[0215] It should be noted that the various embodiments described in the specification are progressive, and each embodiment focuses on the differences from other embodiments. The same and similar parts between embodiments can be referred to each other.

[0216] It should be understood that in the present application, "at least one" means one or more, and "multiple" means two or more. "And / or" is used to describe the relationship between the associated objects, which means that there can be three kinds of relationships, for example, "A and / or B" can represent: only A, only B, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally represents that the associated objects before and after are in an "or" relationship. "At least one of the following" or similar expressions means any combination of these items, including any combination of single or multiple items. For example, at least one of a, b or c can represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, and c can be single or multiple.

[0217] It is also to be noted that, as used in the specification and the appended claims, the singular forms "a," "an" and "the" include plural referents unless otherwise indicated. Furthermore, to the extent that the terms "including," "includes," "having," "has," "with," or "contains" are used in either the detailed description and the claims, such terms are intended to be inclusive in a manner similar to the term "comprising" as an open transition term without precluding any additional or other elements.

[0218] The embodiments disclosed herein can each be implemented as a method, apparatus, or article of manufacture using programming instructions. The embodiments disclosed herein can be implemented using software, firmware, hardware, or a combination thereof. The various elements of the disclosed embodiments, as well as the embodiments themselves, can be constructed from any combination of hardware, software, and / or firmware. The software implementation can be implemented by one or more software modules using object-oriented design methodology, among other techniques. The software modules can be stored on any computer-readable medium, including RAM, ROM, EEPROM, flash memory, or a hard disk, to name a few. The software modules can include one or more routines.

[0219] The above description of disclosed embodiments provides information sufficient to understand how to make and use the application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein can be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A chart analysis method, comprising: displaying a dashboard, the dashboard comprising at least one chart for presenting a data statistic result, the dashboard being generated based on table data of an online table; receiving a chart analysis operation on a target chart in the at least one chart; displaying a chart analysis result of the target chart in an associated area of the target chart, wherein the chart analysis result represents natural language content, and the chart analysis result of the target chart is generated based on the data statistic result of the target chart.

2. The method of claim 1, wherein, The receiving a chart analysis operation on a target chart in the at least one chart comprises: in response to a focus on a chart area of a target chart in the at least one chart, displaying a chart analysis control in the chart area of the target chart; receiving a triggering operation on the chart analysis control.

3. The method of claim 1, wherein, The displaying a chart analysis result of the target chart in an associated area of the target chart comprises: displaying a chart analysis interface in the associated area of the target chart; in response to a start of generation of the chart analysis result of the target chart, presenting a streaming output process of the chart analysis result of the target chart in the chart analysis interface. 4.The method of claim 1, further comprising: in response to a change in the data statistic result of the target chart, displaying identification information in the associated area of the target chart, the identification information being used to identify the change in the data statistic result.

5. The method of claim 1, wherein, The chart analysis result of the target chart comprises a first chart analysis result generated based on a data statistic result at a first time and a second chart analysis result generated based on a data statistic result at a second time, the second time being after the first time, and the data statistic result at the second time being the same as the data statistic result at the first time. The displaying a chart analysis result of the target chart in an associated area of the target chart comprises: reading the first chart analysis result of the target chart from a cache; determining the first chart analysis result of the target chart as the second chart analysis result of the target chart, and displaying the second chart analysis result of the target chart in the associated area of the target chart.

6. The method of claim 1, wherein, The chart analysis result of the target chart comprises a first chart analysis result generated based on a data statistic result at a first time and a second chart analysis result generated based on a data statistic result at a second time, the second time being after the first time, and the data statistic result at the second time being different from the data statistic result at the first time. The method further comprises: updating the first chart analysis result of the target chart in the cache to the second chart analysis result. 7.The method of claim 1, further comprising: receiving an analysis result viewing operation on a target chart in the at least one chart; displaying a plurality of chart analysis results of the target chart in a historical time period. 8.The method of claim 1, further comprising: receive a push configuration operation for the dashboard; wherein the push configuration operation is used to configure push information for pushing information related to the dashboard, the push information including at least one of: information indicating whether to push chart analysis results, information indicating a push time, and information indicating a push object.

9. The method of claim 8, further comprising: generating, according to the push configuration operation, a push request for the dashboard, and pushing information related to the dashboard to a push object; wherein the information related to the dashboard includes the at least one chart and / or chart analysis results related to the at least one chart.

10. The method of claim 9, wherein, The chart analysis results related to the at least one chart include: chart analysis results corresponding to the at least one chart, and / or chart analysis summary results generated based on the chart analysis results corresponding to the at least one chart.

11. The method of claim 1, wherein, The chart analysis results of the target chart are generated by the following steps: generating prompt information based at least on the data statistics results of the target chart, the prompt information indicating a generation process of a language model generating chart analysis results; processing the prompt information using a language model to obtain chart analysis results of the target chart returned by the language model.

12. The method of claim 11, further comprising: receiving a configuration operation for a prompt template, the configuration operation being used to configure a prompt template indicating chart analysis requirements and / or a prompt template indicating chart analysis result formats; The at least one chart analysis result based on the target chart includes: generating prompt information based on the data statistics results of the target chart and the prompt template.

13. The method according to any one of claims 1 to 12, wherein, After displaying the chart analysis results of the target chart, the method further comprises: in the associated area of the target chart, receiving conversation information for the chart analysis results of the target chart, the conversation information representing natural language content; displaying reply information of the conversation information.

14. A chart analysis system, the system comprising: a display module configured to display a dashboard, the dashboard including at least one chart for presenting data statistics results, the dashboard being generated based on table data of an online table; a receiving module configured to receive a chart analysis operation for a target chart in the at least one chart; the display module is further configured to display chart analysis results of the target chart in an associated area of the target chart; wherein the chart analysis results represent natural language content, and the chart analysis results of the target chart are generated based on data statistics results of the target chart.

15. An electronic device, the electronic device comprising a processor and a memory; the processor is configured to execute instructions stored in the memory, so that the electronic device performs the method of any one of claims 1 to 13.

16. A computer-readable storage medium comprising instructions for instructing an electronic device to perform the method of any one of claims 1 to 13.

Images