Method and device for displaying machine account data

Abstract

The invention provides an account data display method and device, and the method comprises the steps: obtaining a data source type, obtaining a hierarchical account data table which comprises a plurality of account fields if the data source type is an account data type, selecting a target account field meeting a display demand from the plurality of account fields, responding to an operation instruction, and displaying the target account field according to the operation instruction. A numeric type standing book field is selected from the standing book fields, the numeric type standing book field has a corresponding relation with the category, a visual chart of the standing book data table is constructed according to the target standing book field and the numeric type standing book field, the X axis of the visual chart is the target standing book field, and the Y axis of the visual chart is the numeric type standing book field. According to the method, the data source type is selected, the type of the data needing to be displayed is determined, if the data source type is the machine account data type, the X axis and the Y axis of the chart can be constructed by selecting the target machine account field and the numerical type machine account field, and therefore the correct chart can be displayed when the data is complex.

Description

Technical Field

[0001] The present invention relates to the technical field of ledger data display, and particularly to a method and device for displaying ledger data. Background Art

[0002] With the rapid development of information technology, the ability of data processing and analysis has been significantly improved. The traditional paper-based ledger management method has gradually been unable to meet the needs of modern enterprises, and there are problems such as low efficiency, poor security, and easy loss. Therefore, electronic ledgers have gradually emerged and developed into an important data management means. As an important management tool, ledger data display and analysis can help enterprises deeply understand market trends, competitor dynamics, and their own business conditions, so as to formulate more scientific and reasonable market strategies and management decisions. Therefore, more and more enterprises begin to attach importance to the development and application of ledger data display and analysis. However, traditional visualization analysis tools usually need to go through multiple complex processes such as data processing, model creation, and chart drawing, and finally perform large-screen display based on these created models or charts. Although this method can better meet the needs of data sorting, analysis, and display, especially in the case of complex data sources, diverse data types, or inconsistent data standards, for those ledger data with high specifications and accuracy, the processing process is relatively heavy. Summary of the Invention

[0003] In order to solve the above technical problems, the present invention is proposed. Embodiments of the present invention provide a method and device for displaying ledger data, which can solve the problem of poor effect display when data is complex.

[0004] According to one aspect of the present invention, a method for displaying ledger data is provided, including:

[0005] Obtain the data source type;

[0006] If the data source type is the ledger data type, obtain a hierarchical ledger data table; wherein, the ledger data table includes multiple ledger fields;

[0007] Select target ledger fields that meet the display requirements from the multiple ledger fields;

[0008] Respond to an operation instruction, and select numerical ledger fields from the multiple ledger fields; wherein, the numerical ledger fields are used for quantitative statistics of the category, and the numerical ledger fields have a corresponding relationship with the category;

[0009] Construct a visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields; wherein, the X-axis of the visualization chart is the target ledger field, and the Y-axis of the visualization chart is the numerical ledger field.

[0010] In one embodiment, constructing a visualization chart of the ledger data table according to the target ledger field and the numerical ledger field includes:

[0011] Set the color range of the target ledger field;

[0012] Based on the target ledger field, determine the category;

[0013] Determine the preferred data in the category that meets the numerical ledger field;

[0014] Based on the color range, determine the display color corresponding to the preferred data;

[0015] Construct a visualization chart of the ledger data table according to the display color corresponding to the preferred data, the category, and the numerical ledger field; wherein, the X-axis of the visualization chart is the category.

[0016] In one embodiment, constructing a visualization chart of the ledger data table according to the target ledger field and the numerical ledger field includes:

[0017] Input the numerical ledger field into a filter and trigger a pop-up window;

[0018] Set filtering conditions in the pop-up window;

[0019] Based on the filtering conditions, determine the target data in the target ledger field that meets the filtering conditions;

[0020] Construct a visualization chart of the ledger data table according to the target ledger field, the target data, and the numerical ledger field.

[0021] In one embodiment, after constructing the visualization chart of the ledger data table according to the target ledger field and the numerical ledger field, the method for displaying ledger data further includes:

[0022] Obtain metric indicators;

[0023] Based on the metric indicators and the visualization chart, determine the data status of the visualization chart.

[0024] In one embodiment, after constructing the visualization chart of the ledger data table according to the target ledger field and the numerical ledger field, the method for displaying ledger data further includes:

[0025] Obtain the associated ledger data table of the ledger data table;

[0026] Based on the association conditions, associate the ledger data table and the associated ledger data table to obtain a dynamic data chart.

[0027] In one embodiment, the associating the ledger data table and the associated ledger data table based on the association conditions to obtain a dynamic data chart includes:

[0028] Determine the association fields between the ledger data table and the associated ledger data table;

[0029] Based on the association fields, associate the ledger data table and the associated ledger data table to obtain a dynamic data chart.

[0030] In one embodiment, after associating the ledger data table and the associated ledger data table based on the association fields to obtain a dynamic data chart, the method for displaying ledger data further includes:

[0031] Based on the association fields, search for other ledger data tables associated with the associated ledger data table;

[0032] Associate the ledger data table, the other ledger data tables and the associated ledger data table to obtain a visual association chart.

[0033] In one embodiment, the constructing the visual chart of the ledger data table according to the target ledger fields and the numerical ledger fields includes:

[0034] Sort multiple target ledger fields;

[0035] According to the sorted target ledger fields and numerical ledger fields, construct the visual chart of the ledger data table.

[0036] In one embodiment, the obtaining the ledger data table with a hierarchy includes:

[0037] Obtain the ledger data table to be processed;

[0038] Determine the grouping information corresponding to the ledger data table to be processed; wherein the grouping information includes first-level grouping information and second-level grouping information, and the level of the first-level grouping information is higher than that of the second-level grouping information;

[0039] Set the first-level grouping information as tree nodes;

[0040] Set the second-level grouping information as the child nodes of the tree nodes;

[0041] According to the tree nodes and the child nodes of the tree nodes, construct the hierarchical relationship of the ledger data table to be processed;

[0042] Based on the hierarchical relationship, fill the data in the to-be-processed ledger data table into the corresponding nodes to obtain a hierarchical ledger data table.

[0043] According to another aspect of the present invention, there is provided a display device for ledger data, including:

[0044] An acquisition module, configured to acquire a data source type; if the data source type is a ledger data type, acquire a hierarchical ledger data table; wherein, the ledger data table includes a plurality of ledger fields; select target ledger fields that meet the display requirements from the plurality of ledger fields; in response to an operation instruction, select numerical ledger fields from the plurality of ledger fields; wherein, the numerical ledger fields are used for quantitatively statistics of the category, and the numerical ledger fields have a corresponding relationship with the category;

[0045] A construction module, configured to construct a visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields; wherein, the X-axis of the visualization chart is the target ledger field, and the Y-axis of the visualization chart is the numerical ledger field.

[0046] The display method and device for ledger data provided by the present invention include: acquiring a data source type, if the data source type is a ledger data type, acquiring a hierarchical ledger data table, wherein the ledger data table includes a plurality of ledger fields, selecting target ledger fields that meet the display requirements from the plurality of ledger fields, in response to an operation instruction, selecting numerical ledger fields from the plurality of ledger fields, wherein the numerical ledger fields are used for quantitatively statistics of the category, and the numerical ledger fields have a corresponding relationship with the category, constructing a visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields, wherein the X-axis of the visualization chart is the target ledger field, and the Y-axis of the visualization chart is the numerical ledger field. By selecting the data source type, the types of data to be displayed are determined. If the data source type is a ledger data type, the X-axis and Y-axis of the chart can be constructed by selecting the target ledger fields and numerical ledger fields, so that the correct chart can be displayed when the data is complex. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] By describing the embodiments of the present invention in more detail in conjunction with the accompanying drawings, the above and other objects, features, and advantages of the present invention will become more obvious. The accompanying drawings are used to provide a further understanding of the embodiments of the present invention, and constitute a part of the specification, and are used to explain the present invention together with the embodiments of the present invention, and do not constitute a limitation to the present invention. In the accompanying drawings, the same reference numerals generally represent the same components or steps.

[0048] Figure 1It is a schematic flowchart of a method for displaying ledger data provided by an exemplary embodiment of the present invention.

[0049] Figure 2 It is a schematic structural diagram of a visualization chart provided by an exemplary embodiment of the present invention.

[0050] Figure 3 It is a schematic flowchart of a method for constructing a visualization chart provided by an exemplary embodiment of the present invention.

[0051] Figure 4 It is a schematic structural diagram of a device for displaying ledger data provided by an exemplary embodiment of the present invention.

[0052] Figure 5 It is a schematic structural diagram of a device for displaying ledger data provided by another exemplary embodiment of the present invention.

[0053] Figure 6 It is a structural diagram of an electronic device provided by an exemplary embodiment of the present invention. Detailed Description of the Invention

[0054] Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments of the present invention. It should be understood that the present invention is not limited by the exemplary embodiments described herein.

[0055] Figure 1 It is a schematic flowchart of a method for displaying ledger data provided by an exemplary embodiment of the present invention. Figure 2 It is a schematic structural diagram of a visualization chart provided by an exemplary embodiment of the present invention. As Figure 1-2 shown, the method for displaying ledger data includes:

[0056] Step 110: Obtain the data source type.

[0057] In the embodiments of the present invention, the data source types of the present invention may include static data and ledger data. Different data source types will result in different display effects. Static data represents data that does not change within a certain time period, and static data is mainly used to display the visual effects of the chart. Ledger data changes within the time period, so the display effects of ledger data at different times are also different.

[0058] Specifically, the user creates a visualization dashboard, and the user's instruction triggers the visualization dashboard to select the data source type, and then dynamically generates a chart according to the data source type.

[0059] Step 120: If the data source type is the ledger data type, obtain a ledger data table with a hierarchy, where the ledger data table includes multiple ledger fields.

[0060] In an embodiment of the present invention, in order to make the ledger data display more intuitively, it is necessary to construct a ledger data table with a hierarchy. The ledger data table with a hierarchy can help users understand the relationship and hierarchy between data more clearly. That is to say, through the hierarchical structure, users can quickly find the information they need.

[0061] Step 130: Select target ledger fields that meet the display requirements from multiple ledger fields.

[0062] In an embodiment of the present invention, the present invention can select target ledger fields from multiple ledger fields according to the display requirements for the division rules. For example, the multiple ledger fields include: sales amount, cost, product name. If the display requirement is to determine the quantity of products to be displayed, then the target ledger field should be the product name.

[0063] Specifically, the user can drag the target ledger field to the "category axis / dimension" area by dragging, so as to realize the binding of the x-axis field of the chart.

[0064] Step 140: Respond to the operation instruction, and select numerical ledger fields from multiple ledger fields, where the numerical ledger fields are used for quantitative statistics of categories, and the numerical ledger fields have a corresponding relationship with the categories.

[0065] In an embodiment of the present invention, numerical ledger fields are selected from multiple ledger fields, such as sales amount, cost, etc. Since the numerical ledger fields carry numerical values, the numerical values of each target ledger field can be divided.

[0066] Specifically, the user can complete the binding of the y-axis field of the chart by dragging the field to the "value axis / metric" area. Among them, the operation instruction is the operation instruction for the user to drag the field to the metric area.

[0067] Step 150: Construct a visual chart of the ledger data table according to the target ledger field and the numerical ledger field, where the X-axis of the visual chart is the target ledger field, and the Y-axis of the visual chart is the numerical ledger field.

[0068] The display method of ledger data provided by the present invention includes: obtaining a data source type, if the data source type is a ledger data type, then obtaining a hierarchical ledger data table, wherein the ledger data table includes multiple ledger fields, selecting a target ledger field that meets the display requirements from the multiple ledger fields, responding to an operation instruction, selecting a numerical ledger field from the multiple ledger fields, wherein the numerical ledger field is used to quantify and count the categories, and the numerical ledger field has a corresponding relationship with the category, and constructing a visual chart of the ledger data table according to the target ledger field and the numerical ledger field, wherein the X-axis of the visual chart is the target ledger field, and the Y-axis of the visual chart is the numerical ledger field. By selecting the data source type, the type of data to be displayed is determined. If the data source type is a ledger data type, the X-axis and Y-axis of the chart can be constructed by selecting the target ledger field and the numerical ledger field, so that the correct chart can be displayed when the data is complicated.

[0069] Figure 3 FIG. 1 is a flow chart of a method for constructing a visualization chart provided by an exemplary embodiment of the present invention. Figure 3 As shown, step 150 may include:

[0070] Step 151: Set the color range of the target ledger field.

[0071] In an embodiment of the present invention, the expressiveness of the chart can be enhanced by setting the color range of the target ledger field. In the color area, the user uses the target ledger field as the basis for color classification, so that different data points in the chart display different colors according to the value of the field, thereby more intuitively showing the distribution of the data. For example, if the user wants to distinguish sales in different regions, the "Region" field can be dragged to the color area, so that each data point in the chart will display a different color according to the region to which it belongs.

[0072] Step 152: Determine the category based on the target ledger field.

[0073] In the embodiment of the present invention, although the target ledger field is determined, its category is not determined. Therefore, the category is determined by the name of the target ledger field, so that a more accurate display color can be obtained.

[0074] Step 153: Determine the preferred data in the category that satisfies the numerical ledger field.

[0075] Step 154: Based on the color range, determine the display color corresponding to the preferred data.

[0076] Step 155: Construct a visualization chart of the ledger data table based on the display color, category, and numerical ledger field corresponding to the preferred data, where the X-axis of the visualization chart is the category.

[0077] In one embodiment, step 150 may be specifically implemented as follows: input the numerical ledger field into the filter and trigger a pop-up window; set filtering conditions in the pop-up window; based on the filtering conditions, determine the target data in the target ledger field that meets the filtering conditions; and construct a visualization chart of the ledger data table according to the target ledger field, the target data, and the numerical ledger field.

[0078] In the embodiment of the present invention, the present invention sets a filter and clicking on the filter can trigger a pop-up window. In the pop-up window, the user can set specific conditions to filter out the data that meets the requirements, so as to achieve precise control of the chart data. For example, if the user only focuses on products with sales exceeding a certain threshold, the corresponding conditions can be set in the filter area, and then the chart will only display the product data that meets the conditions.

[0079] Specifically, in the chart data configuration panel, the user can easily set the filter. This function allows the user to add any type of field to the filter by dragging. Once the field is dragged into the filter area, the user can click the settings button to open a pop-up window. Inside this pop-up window, the user can add the required filtering conditions for the selected field. This process not only simplifies the data filtering operation but also improves work efficiency, enabling the user to quickly and accurately filter and analyze the data.

[0080] After completing the chart drawing of the ledger data, the user only needs to click the save button to easily save these chart settings. This not only makes the data visualization more intuitive but also greatly improves work efficiency. In addition, the chart supports functions such as moving, dragging, deleting, and copying. The moving and dragging functions allow the user to freely adjust the position and layout of the chart according to needs, so as to better display the relationship between data. At the same time, the deleting and copying functions enhance the flexibility of chart operations, enabling the user to easily delete the charts that are no longer needed or copy the charts for use in different large-screen pages, thus ensuring the accurate transmission and efficient utilization of information.

[0081] In one embodiment, after step 150, the method for displaying ledger data may be specifically implemented as follows: obtain the metric; based on the metric and the visualization chart, determine the data status of the visualization chart.

[0082] In the embodiments of the present invention, for measurement metrics, the system supports a series of complex calculation settings to meet the requirements of different analysis scenarios. These settings include total, average, count, distinct count, maximum, minimum, variance, standard deviation, etc. Through these calculation functions, users can examine data from multiple perspectives and reveal the deep - seated information behind it. For example, the total can help users understand the overall situation, while the average reflects the general level of the data. The count and distinct count respectively show the total amount of data and the number of unique values, which helps to understand the data distribution. The maximum and minimum reveal the extreme values of the data, while the variance and standard deviation reflect the degree of data fluctuation. In addition, the system also provides threshold settings, allowing users to define specific numerical boundaries for filtering or marking data. Year - on - year and month - on - month calculation settings can help users analyze the change trends of data over different time periods.

[0083] In one embodiment, after step 150, the method for displaying ledger data can be specifically implemented as follows: obtain the associated ledger data table of the ledger data table; based on the association conditions, associate the ledger data table and the associated ledger data table to obtain a dynamic data chart.

[0084] In the embodiments of the present invention, in the multi - ledger association setting, the user first needs to select the specific ledger that they wish to associate. This step can be easily completed through intuitive operations on the interface. The user only needs to click the "Association Setting" button next to the selected ledger. Subsequently, the system will pop up a dedicated association setting dialog box, where the user can specify the required association conditions in detail. After completing the setting of the association conditions, the user clicks the "OK" button in the dialog box, and the system will automatically generate a virtual ledger table node according to these conditions. This node is actually a dynamic data view that does not store any actual data but reflects all records that meet the association conditions in real - time.

[0085] When the user clicks on this virtual ledger table node, the system will immediately display all the field information queried according to the previously set association conditions. This means that users can view all the data from different but associated ledgers in a unified view, which greatly facilitates data analysis and decision - making.

[0086] In this way, the multi - ledger association setting function significantly enhances the flexibility and depth of data processing, enabling users to explore and analyze data from multiple perspectives and dimensions, thereby obtaining more comprehensive and in - depth business insights.

[0087] For example, a company has two ledger books: a sales ledger and an inventory ledger. The sales ledger records the sales quantity and sales amount of each product, while the inventory ledger records the inventory quantity and purchase records of each product. Through the multi-ledger association setting, users can select these two ledger books for association. The user clicks the "Association Setting" button next to the sales ledger. In the pop-up dialog box, the user sets the association conditions, such as: the association field is "Product ID". After clicking "OK", the system generates a virtual ledger table node. When the user clicks on this virtual node, the system will display all product information that meets the conditions, including the sales quantity, sales amount, and current inventory of each product. In this way, users can quickly understand which products are selling well and which products are out of stock, so as to make more accurate replenishment decisions and improve operational efficiency.

[0088] In one embodiment, the method for displaying ledger data can be specifically implemented as: determining the association field between the ledger data table and the associated ledger data table; based on the association field, associating the ledger data table and the associated ledger data table to obtain a dynamic data chart.

[0089] In an embodiment of the invention, when associating the ledger data table with the associated ledger data table, it is first necessary to clarify the association field between the two, which is a field that can uniquely identify data records, such as product ID, customer ID, or order number, etc. After determining the association field, the system will associate the ledger data table with the associated ledger data table based on these fields, thereby generating a dynamic data chart. This chart will reflect all relevant records that match the association field in real time, enabling users to see the relationship between data from different sources in a unified view, thus facilitating in-depth analysis and decision-making. Through this dynamic data chart, users can quickly identify key trends and potential problems, thereby more effectively supporting business decision-making and strategy formulation.

[0090] In one embodiment, after step 150, the method for displaying ledger data can be specifically implemented as: based on the association field, searching for other ledger data tables associated with the associated ledger data table; associating the ledger data table, other ledger data tables, and the associated ledger data table to obtain a visual association chart.

[0091] In an embodiment of the present invention, based on the determined associated fields, the system will search for other ledger data tables related to the associated ledger data table, and these tables may contain further and supplementary information. For example, the associated ledger for the sales ledger may be the customer information table, product information table, etc. When the user selects to associate these tables, the system will integrate the ledger data table, other relevant ledger data tables, and the associated ledger data table together according to the common associated fields, such as customer ID or product ID, so as to generate a visual association diagram. Taking a retail company as an example, the sales ledger may be combined with the customer information table (recording customer names, contact information, etc.) and the inventory ledger (recording inventory quantities, purchase times, etc.) to form a comprehensive chart, showing the purchase behavior of each customer and the inventory status of related products. In this way, users can intuitively see which customers have a high purchase frequency and which products are out of stock, so as to formulate more accurate marketing strategies or replenishment plans.

[0092] In one embodiment, step 150 may be specifically implemented as: sorting multiple target ledger fields; and constructing a visual chart of the ledger data table according to the sorted target ledger fields and numerical ledger fields.

[0093] In an embodiment of the present invention, in the configuration of field display, users can flexibly add corresponding settings according to their own needs to enhance the flexibility and depth of data analysis, so that the data display better fits the user's analysis goals. Especially in terms of dimension indicators, the system provides a variety of sorting functions, including default sorting, ascending order, and descending order options. This means that users can select the sorting method of data according to specific needs to help them more quickly identify trends, patterns, or outliers. For example, if a user wants to analyze sales data, they can choose to sort the sales amount in descending order to quickly identify the products with the highest sales amount; and if the user is concerned about the inventory turnover situation, they can choose to sort the inventory quantity in ascending order to find out the products with large inventory backlogs. This flexible sorting function not only improves the efficiency of data analysis, but also enables users to more intuitively understand the meaning behind the data, so as to make more accurate decisions.

[0094] In one embodiment, step 120 may be specifically implemented as: obtaining the ledger data table to be processed; determining the grouping information corresponding to the ledger data table to be processed; where the grouping information includes first-level grouping information and second-level grouping information, and the level of the first-level grouping information is higher than that of the second-level grouping information; setting the first-level grouping information as a tree node; setting the second-level grouping information as a child node of the tree node; constructing a hierarchical relationship of the ledger data table to be processed according to the tree node and the child node of the tree node; and filling the data in the ledger data table to be processed into the corresponding nodes based on the hierarchical relationship to obtain a hierarchical ledger data table.

[0095] In an embodiment of the present invention, the system will obtain the ledger data table to be processed and determine its corresponding grouping information, which includes a first-level grouping and a second-level grouping, where the level of the first-level grouping is higher than that of the second-level grouping. Next, the system will set the first-level grouping as a tree node and use the second-level grouping as the child nodes of these tree nodes. Through this hierarchical structure, the system can establish the hierarchical relationship of the ledger data table to be processed.

[0096] On this basis, the system will fill the data in the ledger data table to be processed into the corresponding nodes according to the hierarchical relationship, thereby generating a ledger data table with a clear hierarchy. Users can expand the currently selected node by clicking on any tree node, and the system will automatically load and display all the fields under that node, and these fields will be regarded as the child nodes of the current tree node. Such a design enables users to quickly access the specific data content of each node, greatly improving the efficiency of information retrieval.

[0097] In addition, the system also supports the field grouping function, allowing further child nodes to be included under the child nodes, thereby realizing the hierarchical management of data. This hierarchical structure not only makes the data more organized but also facilitates users to conduct in-depth analysis. For all leaf nodes, the system also provides a drag-and-drop function. Users can drag the fields to the chart data configuration panel for data configuration. However, it should be noted that the system does not support moving the node positions in the tree component. Such a design ensures the stability of the data hierarchy while providing a flexible data configuration method, further enhancing the user's operation experience and work efficiency.

[0098] Figure 4 is a schematic structural diagram of a display device for ledger data provided by an exemplary embodiment of the present invention. As Figure 4 shown, the display device for ledger data includes: an acquisition module 201, configured to acquire the data source type; if the data source type is the ledger data type, acquire a ledger data table with a hierarchy; where the ledger data table includes multiple ledger fields; select target ledger fields that meet the display requirements from the multiple ledger fields; in response to an operation instruction, select numeric ledger fields from the multiple ledger fields; where the numeric ledger fields are used for quantitative statistics of categories, and the numeric ledger fields have a corresponding relationship with the categories; a construction module 202, configured to construct a visual chart of the ledger data table according to the target ledger fields and the numeric ledger fields; where the X-axis of the visual chart is the target ledger field, and the Y-axis of the visual chart is the numeric ledger field.

[0099] Figure 5 is a schematic structural diagram of a display device for ledger data provided by another exemplary embodiment of the present invention. As Figure 5As shown, the construction module 202 may include: a setting unit 2021 for setting the color range of the target ledger field; a determination unit 2022 for determining the category based on the target ledger field; determining the preferred data that meets the numerical ledger field in the category; determining the display color corresponding to the preferred data based on the color range; a construction subunit 2023 for constructing a visual chart of the ledger data table according to the display color corresponding to the preferred data, the category, and the numerical ledger field; wherein the X-axis of the visual chart is the category.

[0100] In one embodiment, the construction module 202 may include: an input unit 2024 for inputting the numerical ledger field into the filter and triggering a pop-up window; a filtering unit 2025 for setting filtering conditions in the pop-up window; determining the target data in the target ledger field that meets the filtering conditions based on the filtering conditions; constructing a visual chart of the ledger data table according to the target ledger field, the target data, and the numerical ledger field.

[0101] In one embodiment, the display device for ledger data may be specifically configured to: obtain a metric; determine the data status of the visual chart based on the metric and the visual chart.

[0102] In one embodiment, the display device for ledger data may be specifically configured to: obtain the associated ledger data table of the ledger data table; associate the ledger data table and the associated ledger data table based on the association condition to obtain a dynamic data chart.

[0103] In one embodiment, the display device for ledger data may be specifically configured to: determine the association field between the ledger data table and the associated ledger data table; associate the ledger data table and the associated ledger data table based on the association field to obtain a dynamic data chart.

[0104] In one embodiment, the display device for ledger data may be specifically configured to: based on the association field, search for other ledger data tables associated with the associated ledger data table; associate the ledger data table, the other ledger data tables, and the associated ledger data table to obtain a visual association chart.

[0105] In one embodiment, the construction module 202 may be specifically configured to: sort multiple target ledger fields; construct a visual chart of the ledger data table according to the sorted target ledger fields and the numerical ledger field.

[0106] In one embodiment, the acquisition module 201 may include: a hierarchical construction unit 2011, configured to obtain a ledger data table to be processed; determine grouping information corresponding to the ledger data table to be processed; wherein the grouping information includes first-level grouping information and second-level grouping information, and the level of the first-level grouping information is higher than that of the second-level grouping information; set the first-level grouping information as a tree node; set the second-level grouping information as a child node of the tree node; construct a hierarchical relationship of the ledger data table to be processed according to the tree node and the child node of the tree node; and based on the hierarchical relationship, fill the data in the ledger data table to be processed into the corresponding nodes to obtain a ledger data table with a hierarchy.

[0107] Figure 6 The block diagram of an electronic device according to an embodiment of the present application is illustrated.

[0108] As Figure 6 shown, the electronic device 10 includes one or more processors 11 and a memory 12.

[0109] The processor 11 may be a central processing unit (CPU) or other forms of processing units with data processing capabilities and / or instruction execution capabilities, and may control other components in the electronic device 10 to perform desired functions.

[0110] The memory 12 may include one or more computer program products, and the computer program products may include various forms of computer-readable storage media, such as volatile memory and / or non-volatile memory. The volatile memory may include, for example, random access memory (RAM) and / or cache memory, etc. The non-volatile memory may include, for example, read-only memory (ROM), hard disk, flash memory, etc. One or more computer program instructions may be stored on the computer-readable storage media, and the processor 11 may run the program instructions to implement the ledger data display method of various embodiments of the present application described above and / or other desired functions. Various contents such as input signals, signal components, noise components, etc. may also be stored in the computer-readable storage media.

[0111] In one example, the electronic device 10 may further include: an input device 13 and an output device 14, and these components are interconnected through a bus system and / or other forms of connection mechanisms (not shown).

[0112] When the electronic device 10 is a stand-alone device, the input device 13 may be a communication network connector for receiving the collected input signals from the first device and the second device.

[0113] In addition, the input device 13 may further include, for example, a keyboard, a mouse, and the like.

[0114] The output device 14 can output various information to the outside, including the determined distance information, direction information, etc. The output device 14 can include, for example, a display, a speaker, a printer, a communication network, and remote output devices connected thereto, etc.

[0115] Of course, for simplicity, Figure 6 only some of the components related to the present application in the electronic device 10 are shown, and components such as a bus, an input / output interface, etc. are omitted. In addition, according to specific application scenarios, the electronic device 10 may further include any other appropriate components.

[0116] The computer program product can be written in any combination of one or more programming languages for programming code to execute the operations of the embodiments of the present application. The programming languages include object-oriented programming languages such as Java, C++, etc., and also include conventional procedural programming languages such as the "C" language or similar programming languages. The programming code can be executed entirely on the user computing device, partially on the user device, executed as a stand-alone software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server.

[0117] The computer-readable storage medium can adopt any combination of one or more readable media. The readable media can be a readable signal medium or a readable storage medium. The readable storage medium can, for example, include but is not limited to an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. More specific examples (non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0118] The above are only the preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principle of the present invention shall be included within the scope of protection of the present invention.

Claims

1. A method for displaying ledger data, characterized in that Including: Obtain the data source type; If the data source type is the ledger data type, obtain the ledger data table with levels; wherein, the ledger data table includes multiple ledger fields; Select the target ledger fields that meet the display requirements from the multiple ledger fields; In response to the operation instruction, select the numerical ledger fields from the multiple ledger fields; wherein, the numerical ledger fields are used for quantitative statistics of the category, and the numerical ledger fields have a corresponding relationship with the category; Construct a visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields; wherein, the X-axis of the visualization chart is the target ledger field, and the Y-axis of the visualization chart is the numerical ledger field.

2. The method for displaying ledger data according to claim 1, wherein The constructing the visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields includes: Set the color range of the target ledger field; Determine the category based on the target ledger field; Determine the preferred data in the category that meets the numerical ledger field; Determine the display color corresponding to the preferred data based on the color range; Construct a visualization chart of the ledger data table according to the display color corresponding to the preferred data, the category, and the numerical ledger field; wherein, the X-axis of the visualization chart is the category.

3. The method for displaying ledger data according to claim 1, wherein The constructing the visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields includes: Input the numerical ledger field into the filter and trigger a pop-up box; Set filtering conditions in the pop-up box; Based on the filtering conditions, determine the target data in the target ledger fields that meet the filtering conditions; Construct a visualization chart of the ledger data table according to the target ledger fields, the target data, and the numerical ledger fields.

4. The method for displaying ledger data according to claim 1, wherein After constructing the visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields, it further includes: Obtain the metric; Determine the data status of the visualization chart based on the metric and the visualization chart.

5. The display method of ledger data according to claim 1, wherein After constructing the visualization chart of the ledger data table according to the target ledger fields and the numerical ledger fields, it further includes: Obtain the associated ledger data table of the ledger data table; Based on the association condition, associate the ledger data table and the associated ledger data table to obtain a dynamic data chart.

6. The method for displaying ledger data according to claim 5, wherein The associating the ledger data table and the associated ledger data table based on the association condition to obtain a dynamic data chart includes: Determine the association fields between the ledger data table and the associated ledger data table; Based on the association fields, associate the ledger data table and the associated ledger data table to obtain a dynamic data chart.

7. The method for displaying ledger data according to claim 6, characterized in that After associating the ledger data table and the associated ledger data table based on the association fields to obtain a dynamic data chart, it further includes: Based on the association fields, search for other ledger data tables associated with the associated ledger data table; Associate the ledger data table, the other ledger data tables with the associated ledger data table to obtain a visualized association chart.

8. The method for displaying ledger data according to claim 1, wherein Constructing the visualized chart of the ledger data table according to the target ledger fields and the numerical ledger fields includes: Sort multiple target ledger fields. Construct the visualized chart of the ledger data table according to the sorted target ledger fields and numerical ledger fields.

9. The method for displaying ledger data according to claim 1, wherein Obtaining the ledger data table with a hierarchy includes: Obtain the ledger data table to be processed. Determine the grouping information corresponding to the ledger data table to be processed; wherein, the grouping information includes first-level grouping information and second-level grouping information, and the level of the first-level grouping information is higher than that of the second-level grouping information. Set the first-level grouping information as a tree node. Set the second-level grouping information as the child node of the tree node. Construct the hierarchical relationship of the ledger data table to be processed according to the tree node and the child node of the tree node. Based on the hierarchical relationship, fill the data in the ledger data table to be processed into the corresponding nodes to obtain a ledger data table with a hierarchy.

10. A display device for ledger data, characterized in that, Includes: An acquisition module for acquiring the data source type. If the data source type is the ledger data type, obtain the ledger data table with a hierarchy; wherein, the ledger data table includes multiple ledger fields; select the target ledger fields that meet the display requirements from the multiple ledger fields; in response to the operation instruction, select the numerical ledger fields from the multiple ledger fields; wherein, the numerical ledger fields are used for quantitative statistics of the category, and the numerical ledger fields have a corresponding relationship with the category. A construction module for constructing the visualized chart of the ledger data table according to the target ledger fields and the numerical ledger fields; wherein, the X-axis of the visualized chart is the target ledger field, and the Y-axis of the visualized chart is the numerical ledger field.

Images