Data display method, device and equipment and computer readable storage medium

Abstract

The application relates to the technical field of web front ends of financial technology, and discloses a data display method, device and equipment and a computer readable storage medium. The data display method comprises the following steps: when a data display instruction is received, a target query index, a target query dimension and a target filtering condition are acquired according to the data display instruction; target query data is acquired according to the target query index, the target query dimension and the target filtering condition; a corresponding data display table is generated according to the target query dimension and the target query index, and the target query data is filled into the data display table for display. The application can solve the technical problem that data cannot be filtered in multiple levels and clearly and intuitively displayed on a web page in the prior art.

Description

Technical Field

[0001] This invention relates to the field of web front-end technology in financial technology (Fintech), and more particularly to a data display method, apparatus, device, and computer-readable storage medium. Background Technology

[0002] With the development of computer technology, more and more technologies (big data, distributed systems, blockchain, artificial intelligence, etc.) are being applied in the financial field. The traditional financial industry is gradually transforming into financial technology (Fintech). However, due to the security and real-time requirements of the financial industry, higher demands are also being placed on technology.

[0003] In the era of big data, every enterprise possesses massive amounts of business data, which contains immense value. It is crucial to effectively query and display this data on web pages, enabling users to obtain precise datasets and view information clearly and intuitively according to their needs. Currently, data querying and display are typically limited to querying and listing multiple indicators or single-dimensional data. This method of data querying and display on web pages is relatively singular in scope and restricts the range of data that can be queried. It cannot simultaneously support data queries with multiple indicators, dimensions, and filtering conditions, nor can it provide a comprehensive, clear, and intuitive display of the retrieved data, thus hindering users' ability to intuitively view data information on web pages. Therefore, how to achieve multi-level data filtering and clear, intuitive display on web pages has become an urgent problem to be solved. Summary of the Invention

[0004] The main objective of this invention is to provide a data display method, apparatus, device, and computer-readable storage medium, aiming to solve the technical problem in the prior art that data cannot be filtered at multiple levels and displayed clearly and intuitively on a web page.

[0005] To achieve the above objectives, the present invention provides a data display method applied to a web page, the data display method comprising:

[0006] Upon receiving a data display instruction, the target query metrics, target query dimensions, and target filtering conditions are obtained according to the data display instruction.

[0007] Obtain target query data based on the target query metrics, target query dimensions, and target filtering conditions;

[0008] A corresponding data display table is generated based on the target query dimension and target query metric, and the target query data is filled into the data display table for display.

[0009] Optionally, the step of obtaining target query data based on the target query metrics, target query dimensions, and target filtering conditions includes:

[0010] Based on the preset configuration information, obtain the first expression corresponding to the target query indicator, the second expression corresponding to the target query dimension, and the third expression corresponding to the target filtering condition.

[0011] The first expression, the second expression, and the third expression are format-converted to obtain the format-converted expression.

[0012] Based on the format-converted expression, a corresponding data query instruction is generated and sent to the backend server;

[0013] Receive the target query data returned by the backend server based on the data query instruction.

[0014] Optionally, the step of generating a corresponding data display table based on the target query dimension and target query metric includes:

[0015] The dimension level of each target query dimension is determined according to the input order of the target query dimensions, and the value corresponding to each target query dimension is obtained.

[0016] Based on the dimension level of each target query dimension and the corresponding value of each target query dimension, a corresponding dimension structure is generated, and the row layout information of the data display table is determined based on the dimension structure.

[0017] The column layout information of the data display table is determined based on the input order and quantity of the target query dimensions and the input order and quantity of the target query indicators.

[0018] Based on the row layout information and the column layout information, detect whether there are any identical adjacent rows in the same column;

[0019] If it exists, the corresponding merge information is generated, and a corresponding data display table is generated based on the merge information, the row layout information, and the column layout information;

[0020] If it does not exist, a corresponding data display table will be generated based on the row layout information and the column layout information.

[0021] Optionally, the data display method further includes:

[0022] Upon receiving a display mode switching instruction, the target display mode is obtained according to the display mode switching instruction, and the corresponding data display strategy is determined according to the target display mode;

[0023] The target display data is obtained based on the data display strategy, and the target display data is displayed.

[0024] Optionally, the step of determining the corresponding data display strategy based on the target display method includes:

[0025] If the target display method is a data analysis table, then the corresponding data display strategy is determined to be the first data display strategy;

[0026] The steps of obtaining target display data based on the data display strategy and displaying the target display data include:

[0027] Based on the first data display strategy, derived indicators are obtained, and derived data corresponding to the derived indicators are obtained. The derived data and the target query data are determined as the first target display data.

[0028] Based on the first data display strategy and the derived indicators, update the column layout information and the row layout information to obtain the updated column layout information and the updated row layout information;

[0029] Based on the updated column layout information and the updated row layout information, a corresponding data analysis table is generated, and the first target display data is filled into the data analysis table for display.

[0030] Optionally, the step of determining the corresponding data display strategy based on the target display method further includes:

[0031] If the target display method is a pie chart, then the corresponding data display strategy is determined to be the second data display strategy;

[0032] The steps of obtaining target display data based on the data display strategy and displaying the target display data include:

[0033] The second target display data information is obtained based on the second data display strategy. The second target display data information includes second dimension information and second indicator information.

[0034] The second target display data is obtained based on the second dimension information and the second indicator information, and a corresponding pie chart is generated based on the second target display data for display.

[0035] Optionally, the step of determining the corresponding data display strategy based on the target display method further includes:

[0036] If the target display method is a time sequence diagram, then the corresponding data display strategy is determined to be the third data display strategy;

[0037] The steps of obtaining target display data based on the data display strategy and displaying the target display data include:

[0038] Based on the third data display strategy, the specified display data is obtained, and the third indicator information, third dimension information and filtering condition information corresponding to the specified display data are obtained.

[0039] Based on the third indicator information, the third dimension information, the filtering condition information, and the preset time range, obtain similar data corresponding to the specified display data, and determine the specified display data and the similar data as the third target display data;

[0040] Based on the data from the third target, a corresponding time series diagram is generated for display.

[0041] Furthermore, to achieve the above objectives, the present invention also provides a data display device applied to a web page, the data display device comprising:

[0042] The first acquisition module is used to acquire the target query indicators, target query dimensions and target filtering conditions according to the data display instructions when a data display instruction is received.

[0043] The second acquisition module is used to acquire target query data based on the target query indicators, target query dimensions and target filtering conditions;

[0044] The data display module is used to generate a corresponding data display table based on the target query dimension and target query indicator, and to fill the target query data into the data display table for display.

[0045] In addition, to achieve the above objectives, the present invention also provides a data display device, the data display device comprising: a memory, a processor, and a data display program stored in the memory and executable on the processor, wherein the data display program, when executed by the processor, implements the steps of the data display method as described above.

[0046] In addition, to achieve the above objectives, the present invention also provides a computer-readable storage medium storing a data display program, which, when executed by a processor, implements the steps of the data display method described above.

[0047] This invention provides a data display method, apparatus, device, and computer-readable storage medium. Upon receiving a data display instruction, the method obtains target query indicators, target query dimensions, and target filtering conditions according to the instruction; obtains target query data based on these indicators; generates a corresponding data display table based on the target query dimensions and indicators; and populates the data display table with the target query data for display. Through this method, the invention can simultaneously support multiple indicators, multiple dimensions, and multiple filtering conditions for data filtering and querying on a web page, allowing users to obtain more accurate datasets according to their needs. It achieves multi-level personalized data filtering and querying, and supports the display of data obtained through multi-level filtering, going beyond the simple listing of multiple indicator data or single-dimensional data in existing technologies. This invention allows users to clearly and intuitively view multi-level data on a web page, improving the user experience. Attached Figure Description

[0048] Figure 1 This is a schematic diagram of the device structure of the hardware operating environment involved in the embodiments of the present invention;

[0049] Figure 2 This is a flowchart illustrating the first embodiment of the data display method of the present invention;

[0050] Figure 3 This is a schematic diagram of the data display instruction trigger interface and data display table involved in the data display method of the present invention;

[0051] Figure 4 This is a schematic diagram of the data analysis table involved in the data display method of the present invention;

[0052] Figure 5 This is a schematic diagram of a pie chart involved in the data display method of the present invention;

[0053] Figure 6 This is a schematic diagram of the timing diagram involved in the data display method of the present invention;

[0054] Figure 7 This is a schematic diagram of the functional modules of the first embodiment of the data display device of the present invention.

[0055] The realization of the objective, functional features and advantages of the present invention will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0056] It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

[0057] Reference Figure 1 , Figure 1This is a schematic diagram of the device structure of the hardware operating environment involved in the embodiments of the present invention.

[0058] The data display device in this embodiment of the invention can be a smartphone, or a PC (Personal Computer), tablet computer, portable computer, server, or other terminal device.

[0059] like Figure 1 As shown, the data display device may include: a processor 1001, such as a CPU; a communication bus 1002; a user interface 1003; a network interface 1004; and a memory 1005. The communication bus 1002 is used to enable communication between these components. The user interface 1003 may include a display screen and an input unit such as a keyboard; optionally, the user interface 1003 may also include a standard wired interface or a wireless interface. The network interface 1004 may optionally include a standard wired interface or a wireless interface (such as a Wi-Fi interface). The memory 1005 may be high-speed RAM or non-volatile memory, such as a disk drive. Optionally, the memory 1005 may also be a storage device independent of the aforementioned processor 1001.

[0060] Those skilled in the art will understand that Figure 1 The data display device structure shown does not constitute a limitation on the data display device. It may include more or fewer components than shown, or combine certain components, or have different component arrangements.

[0061] like Figure 1 As shown, the memory 1005, which serves as a computer storage medium, may include an operating system, a network communication module, a user interface module, and a data display program.

[0062] exist Figure 1 In the terminal shown, the network interface 1004 is mainly used to connect to the backend server and communicate data with the backend server; the user interface 1003 is mainly used to connect to the client and communicate data with the client; and the processor 1001 can be used to call the data display program stored in the memory 1005 and execute the various steps of the following data display method.

[0063] Based on the above hardware structure, various embodiments of the data display method of the present invention are proposed.

[0064] It should be noted that existing web pages can only query and list multiple metrics or single-dimensional data when displaying data. This method of data query and display on web pages is relatively limited in scope and the range of data that can be queried is limited.

[0065] Even though existing Excel spreadsheets can display multi-row and multi-column data, Excel only allows for offline operation, as data is manually entered locally on the terminal. It cannot be used for online operation and display on web pages such as browsers. If you want to display online data with multiple rows or columns, the current method requires exporting the data from the webpage to a local Excel spreadsheet and then manually displaying the data. This process of exporting data every time it needs to be displayed is cumbersome and inefficient.

[0066] Based on this, the present invention provides a data display method.

[0067] Reference Figure 2 , Figure 2 This is a flowchart illustrating the first embodiment of the data display method of the present invention.

[0068] In this embodiment, the data display method is applied to a web page, and the method includes:

[0069] Step S10: Upon receiving a data display instruction, obtain the target query metrics, target query dimensions, and target filtering conditions according to the data display instruction;

[0070] The data display method in this embodiment is implemented by a data display device, which is described using a server as an example. It should be noted that this server is a front-end server. In this embodiment, when a user wants to filter data at multiple levels and display the filtered data, they can log in to the corresponding software through a user terminal (such as a smartphone or PC). After entering indicators, dimensions, and filtering conditions in the software interface, a data display command can be triggered, for example... Figure 3 Taking loan data display as an example, users can select one or more indicators (such as loan balance, loan interest rate, number of loans, loan amount), one or more dimensions (such as domestic / overseas, customer entity, loan type), and one or more filter conditions (such as bank name, data month, loan amount, loan term, loan type) on the corresponding web page. Then, they can load the report with a single click on the same page, triggering the data display. Of course, to facilitate differentiation between data display tables, a report description section can be added to the web page, allowing users to enter information such as the report name.

[0071] Correspondingly, when the front-end server receives a data display instruction, it obtains the target query indicators, target query dimensions, and target filtering conditions based on the instruction. In the example above, the target query indicators include loan balance, loan interest rate, number of loans disbursed, and loan amount; the target query dimensions include domestic / overseas, customer entity, and loan type; and the target filtering conditions include: bank name is Industrial and Commercial Bank of China (ICBC), data month is May 2018, loan amount disbursed is greater than 500,000, loan term is more than five years, and loan type is consumer loan.

[0072] Step S20: Obtain target query data based on the target query metrics, target query dimensions, and target filtering conditions;

[0073] Then, target query data is obtained based on target query metrics, target query dimensions, and target filtering conditions. Specifically, step S20 includes:

[0074] Step a1: Obtain the first expression corresponding to the target query indicator, the second expression corresponding to the target query dimension, and the third expression corresponding to the target filtering condition according to the preset configuration information.

[0075] First, based on the preset configuration information, obtain the first expression corresponding to the target query metric, the second expression corresponding to the target query dimension, and the third expression corresponding to the target filtering condition.

[0076] The preset configuration information is pre-configured and includes the indicator fields and corresponding calculation functions for each target query indicator. The first expression corresponding to the target query indicator can be obtained based on the indicator fields and corresponding calculation functions in the preset configuration information. For example, for the target query indicator X, its corresponding indicator fields A, B, and C, combined with the calculation function, yield the expression sum(A*B)+avg(C). That is, the target query indicator X can be obtained by performing function calculations on the data corresponding to the three indicator fields A, B, and C according to the above expression.

[0077] The preset configuration information also includes dimension expressions. The configuration of dimension expressions is similar to that of indicator expressions, but dimension expressions do not include an "operation function" option. Each target query dimension's expression may contain multiple dimension fields. For example, if there are two dimension fields D and E, and a dimension W is configured, then its corresponding expression is D+E. Similarly, to obtain the second expression corresponding to the target query dimension, when the target query dimension is W, the corresponding second expression can be obtained from the preset configuration information as D+E.

[0078] In addition, the preset configuration information also includes filter condition expressions, which can be used to obtain the third expression corresponding to the target filter condition. The filter conditions include the following two types of expressions, as detailed below:

[0079] (1) Conditional expression: Similar to dimension expression, it consists of conditional fields and operators. For example, if the conditional fields are F and G, the conditional expression is configured as F*G.

[0080] (2) The "constants" in the filter criteria also need to be configured with an expression. The constants include three types: sequence type constants, interval type constants, and value-corresponding type constants. For the expression of sequence type constants, please refer to the following example:

[0081] {

[0082] "Low education level":{

[0083] "Quality Education": ["Primary School", "Junior High School"],

[0084] "Non-quality education": ["High school"]

[0085] },

[0086] "Secondary Education Level": ["Associate Degree", "Bachelor's Degree", "Master's Degree"],

[0087] "Advanced Education": ["Doctorate"]

[0088] }

[0089] For expressions of range type constants, please refer to the following example:

[0090] {

[0091] "Minor":"[1,18]",

[0092] "Youth":"[19,28]"

[0093] }

[0094] For expressions that correspond to constants of the value type, please refer to the following example:

[0095] {

[0096] "Male":1,

[0097] "Female":0

[0098] }

[0099] Step a2: Perform format conversion on the first expression, the second expression, and the third expression to obtain the format-converted expression;

[0100] After obtaining the first expression corresponding to the target query metric, the second expression corresponding to the target query dimension, and the third expression corresponding to the target filter condition, since the data processing is performed by the backend server, the first, second, and third expressions need to be converted to JSON format to obtain the converted expressions, which are then sent to the backend server to retrieve data. During data conversion, native JavaScript functions can be used to convert the expressions to JSON format. For example, the expression for metric X is sum(metric field A * metric field B) + avg(metric field C), the expression for dimension W is dimension field D + dimension field E, and the expression for filter condition S is filter condition field F + filter condition field G. The constant selected for filter condition S is option H in the interval type, with a value of [m, n]. The final generated JSON data will look something like this:

[0101] {

[0102] "index":{

[0103] "Name":"X",

[0104] Expression: "sum(indicator field A * indicator field B) + avg(indicator field C)"

[0105] },

[0106] "Dimension":{

[0107] "Name":"Y",

[0108] "expression":"dimension field D + dimension field E"

[0109] },

[0110] "Filter criteria":{

[0111] "Name":"S",

[0112] "expression":"Filter condition field F + Filter condition field G",

[0113] "Constant type":"Interval",

[0114] "Constant name":"H",

[0115] "Constant expression": "[m,n]"

[0116] }

[0117] }

[0118] Step a3: Generate the corresponding data query instruction based on the expression after format conversion, and send it to the backend server;

[0119] Step a4: Receive the target query data returned by the backend server based on the data query instruction.

[0120] Then, a corresponding data query instruction is generated based on the format-converted expression and sent to the backend server, so that the backend server can perform data processing and calculation according to the format-converted expression to obtain the corresponding target query data, and then return it to the frontend server; at this time, the frontend server receives the target query data returned by the backend server based on the data query instruction.

[0121] Step S30: Generate a corresponding data display table based on the target query dimension and target query indicator, and fill the target query data into the data display table for display.

[0122] After obtaining the target query data, a corresponding data display table is generated based on the target query dimensions and metrics. The target query data is then populated into this data display table for presentation. The generation process of the data display table is as follows: The dimension level of each target query dimension is determined according to the input order, and the corresponding value for each target query dimension is obtained; based on the dimension level and the corresponding value of each target query dimension, a corresponding dimension structure is generated, and the row layout information of the data display table is determined based on the dimension structure; the column layout information of the data display table is determined based on the input order and number of target query dimensions and the input order and number of target query metrics; and the corresponding data display table is generated based on the row and column layout information.

[0123] Furthermore, to improve the intelligence of data display table generation, before the step of generating the corresponding data display table based on row layout information and column layout information, the method further includes: detecting whether there are identical adjacent rows in the same column based on row layout information and column layout information; if so, generating corresponding merging information, and generating the corresponding data display table based on the merging information, row layout information, and column layout information; if not, directly executing the step of "generating the corresponding data display table based on row layout information and column layout information". The specific generation process can be referred to in the second embodiment below, and will not be elaborated here.

[0124] This invention provides a data display method. Upon receiving a data display instruction, the method obtains target query indicators, target query dimensions, and target filtering conditions according to the instruction; obtains target query data based on these indicators; generates a corresponding data display table based on the target query dimensions and indicators; and populates the data display table with the target query data for display. Through this method, this invention supports simultaneous filtering and querying of data using multiple indicators, dimensions, and filtering conditions on a web page. This allows users to obtain more accurate datasets according to their needs, achieving multi-level personalized data filtering and querying. Furthermore, it supports displaying data obtained through multi-level filtering, going beyond the simple listing of multiple indicator data or single-dimensional data found in existing technologies. This invention allows users to clearly and intuitively view multi-level data on a web page, improving the user experience.

[0125] Furthermore, compared to the existing method of exporting data from Excel spreadsheets and then manually displaying it, the technical solution of this invention eliminates the need for multiple manual exports. Data can be selected and displayed directly on the web page from multiple dimensions, indicators, or conditions. The entire process supports real-time dynamic updates and is implemented entirely online, making data display on the web page very convenient, intelligent, and efficient.

[0126] Furthermore, based on the first embodiment described above, a second embodiment of the data display method of the present invention is proposed. In this embodiment, the step "generating a corresponding data display table based on the target query dimension and target query metric" includes:

[0127] Step b1: Determine the dimension level of each target query dimension according to the input order of the target query dimensions, and obtain the value corresponding to each target query dimension;

[0128] First, determine the dimension level of each target query dimension based on the input order of the target query dimensions, and obtain the corresponding value of each target query dimension. For example, in the example above, when the input order of the target query dimensions is domestic and foreign, customer entity and loan business type, it can be determined that domestic and foreign is the first-level dimension, customer entity is the second-level dimension, and loan business type is the third-level dimension. Among them, the value corresponding to domestic and foreign includes domestic and foreign, the value corresponding to customer entity includes corporate and personal, and the value corresponding to loan business type includes project loan and working capital loan.

[0129] Step b2: Generate the corresponding dimension structure based on the dimension level of each target query dimension and the corresponding value of each target query dimension, and determine the row layout information of the data display table based on the dimension structure;

[0130] Then, based on the dimension level and corresponding values ​​of each target query dimension, a corresponding dimension structure is generated. This dimension structure is similar to a tree structure, with the value of the first-level dimension as the root node. The values ​​of the second-level dimensions then serve as the sub-nodes of each root node, and so on, with the values ​​of the third-level dimensions serving as the sub-nodes of the nodes corresponding to the values ​​of each second-level dimension. This dimension structure includes multiple "routes." For example, in the above example, eight "routes" can be obtained: Domestic-Corporate-Project Loan, Domestic-Corporate-Working Capital Loan, Domestic-Personal-Project Loan, Domestic-Personal-Working Capital Loan, Overseas-Corporate-Project Loan, Overseas-Corporate-Working Capital Loan, Overseas-Personal-Project Loan, and Overseas-Personal-Working Capital Loan.

[0131] After generating the dimensional structure, the row layout information of the data display table is determined based on the dimensional structure. Specifically, each "route" in the dimensional structure occupies one row at a time, and the name of the target query dimension can occupy the first row of the data display table, thus obtaining the row layout information of the data display table.

[0132] Step b3: Determine the column layout information of the data display table based on the input order and quantity of the target query dimension and the input order and quantity of the target query indicator;

[0133] Then, based on the input order and quantity of the target query dimensions and the target query metrics, the column layout information of the data display table is determined. Specifically, the target query dimensions can be sequentially assigned as the first few columns of the data display table according to their input order (the number of columns they occupy is equal to the number of target query dimensions). Then, the target query metrics can be sequentially assigned as the next few columns of the data display table according to their input order (the number of columns they occupy is equal to the number of target query metrics), thus obtaining the column layout information.

[0134] Step b4: Detect whether there are identical adjacent rows in the same column based on the row layout information and the column layout information;

[0135] As can be seen from the above analysis, the first few levels of dimensions may appear multiple times, that is, adjacent rows in the same column display the same content. This will cause visual trouble for users. In order to make the data display table more concise and improve the user experience, we can detect whether there are adjacent rows with the same content in the same column based on the row layout information and column layout information, and merge the rows that display the same content in adjacent rows in the same column.

[0136] If it exists, proceed to step b5 to generate the corresponding merge information, and generate the corresponding data display table based on the merge information, the row layout information and the column layout information;

[0137] If it does not exist, proceed to step b6: Generate the corresponding data display table based on the row layout information and the column layout information.

[0138] Specifically, if adjacent rows in the same column are found to be identical, corresponding merge information is generated, and a corresponding data display table is created based on the merge information, row layout information, and column layout information. The merge information specifies which rows in a particular column will be merged. For example, in the example above, "Domestic" is a value in the first-level dimension, "Corporate" and "Individual" are values ​​in the second-level dimension, and the rest are values ​​in the third-level dimension. There are a total of four "routes," each starting from the first-level dimension "Domestic." Therefore, all four rows in the first column should display "Domestic." Furthermore, in the second column, one pair of adjacent rows will display "Corporate," and another pair will display "Individual." In this case, these four rows in the first column will be merged into one cell. Similarly, the adjacent rows in the second column displaying "Corporate" and "Individual" will be merged. Figure 3 The data display table shown below.

[0139] If no identical adjacent rows in the same column are detected, the corresponding data display table is generated directly based on the row layout information and column layout information.

[0140] Of course, it's understandable that in practice, it's not necessary to check for identical adjacent rows in the same column; instead, the corresponding data display table can be generated directly based on the row and column layout information. That is, after step b3, step b6 can be executed directly. Furthermore, executing steps b4-b6 after step b3 can further improve the intelligence of the data display table generation.

[0141] Through the above methods, the embodiments of the present invention can support the display of data with multiple indicators, multiple dimensions and multiple filtering conditions, so that users can view the data clearly and intuitively, thereby improving the user experience.

[0142] Furthermore, based on the second embodiment described above, a third embodiment of the data display method of the present invention is proposed. In this embodiment, after step S30, the data display method further includes:

[0143] Step A: Upon receiving a display mode switching instruction, obtain the target display mode according to the display mode switching instruction, and determine the corresponding data display strategy according to the target display mode;

[0144] Step B: Obtain target display data based on the data display strategy, and display the target display data.

[0145] To facilitate users' intuitive viewing of data trends, comparison information, and proportions, diverse display methods can be provided for the target query data. The data table mentioned above is a basic data display method. In this embodiment, users can trigger a display method switching command within the data display table interface. The triggering method for the display method switching command is not limited and can be set according to actual conditions. Switching can be done by clicking the corresponding option, such as clicking... Figure 3 The "Data Analysis" function can also trigger a display mode switching command by clicking on a data point in the data display table. It can be understood that although different triggering methods can all trigger the display mode switching command, the corresponding target display mode is different.

[0146] When the front-end server receives a display mode switching instruction, it can obtain the target display mode based on the instruction, determine the corresponding data display strategy based on the target display mode, obtain the target display data based on the data display strategy, and then display the target display data.

[0147] As one implementation method, the step "determine the corresponding data display strategy according to the target display method" may include:

[0148] Step A1: If the target display method is a data analysis table, then the corresponding data display strategy is determined to be the first data display strategy.

[0149] At this point, step B includes:

[0150] Step B11: Obtain derived indicators based on the first data display strategy, and obtain the derived data corresponding to the derived indicators, and determine the derived data and the target query data as the first target display data;

[0151] Step B12: Based on the first data display strategy and the derived indicators, update the column layout information and the row layout information to obtain the updated column layout information and the updated row layout information;

[0152] Step B13: Generate a corresponding data analysis table based on the updated column layout information and the updated row layout information, and fill the first target display data into the data analysis table for display.

[0153] In this embodiment, if the target display method is a data analysis table, then the corresponding data display strategy is determined to be the first data display strategy. Then, based on the first data display strategy, derived indicators are obtained, and the derived data corresponding to these indicators is obtained. The derived data and the target query data are determined to be the first target display data. The derived indicators can be system defaults or user-selected based on the page. Derivative indicators can include, but are not limited to, "last month," "increase compared to last month," "growth rate compared to last month," "beginning of the year," "increase compared to the beginning of the year," "growth rate compared to the beginning of the year," "same period last year," "increase compared to the same period last year," and "growth rate compared to the same period last year," etc. Figure 4 In the query, the user selected "Compared to last month," and the corresponding derived metrics include "Last Month," "Increase Compared to Last Month," and "Increase Compared to Last Month." Then, the derived data corresponding to these metrics is retrieved. The specific retrieval method is similar to the process of retrieving the target query data, and will not be elaborated here.

[0154] After obtaining the primary target display data, the column layout and row layout information can be updated based on the primary data display strategy and derived indicators, resulting in updated column layout and row layout information. Specifically, updating the column layout information involves adding corresponding columns at the appropriate positions based on the derived indicators (e.g., ...). Figure 4 As shown), the column layout information is updated; for the row layout information, the corresponding rows are added to the table header based on the derived indicators and the target query indicators, such as... Figure 4 In the table, add a row below the loan balance to display the current month, previous month, increase compared to last month, and growth rate compared to last month. Furthermore, to improve the display effect of the data analysis table, the number of columns occupied by the target query dimensions can be reduced, saving space for more data display. This allows for an increase in the amount of data displayed on the page without changing the screen size, making it easier for users to view. Specifically, the target query dimensions and their corresponding values ​​can be combined into one column for display; correspondingly, the column layout and row layout information also need to be updated. In addition, to facilitate differentiation of the levels of the target query dimensions, lower-level dimensions can be indented, such as... Figure 4 As shown, this way, even if all the dimensions of all levels are placed in one column, the hierarchical relationship can still be clearly seen.

[0155] Then, based on the updated column layout information and the updated row layout information, a corresponding data analysis table is generated, and the data to be displayed as the first target is filled into the data analysis table for display.

[0156] As another implementation, the step "determine the corresponding data display strategy according to the target display method" may further include:

[0157] Step A2: If the target display method is a pie chart, then the corresponding data display strategy is determined to be the second data display strategy;

[0158] At this point, step B includes:

[0159] Step B21: Obtain second target display data information based on the second data display strategy. The second target display data information includes second dimension information and second indicator information.

[0160] Step B22: Obtain the second target display data based on the second dimension information and the second indicator information, and generate a corresponding pie chart based on the second target display data for display.

[0161] In this embodiment, if the target display method is a pie chart, then the corresponding data display strategy is determined to be the second data display strategy. Then, based on the second data display strategy, second target display data information is obtained, wherein the second target display data information includes second dimension information and second indicator information. Then, the second target display data is obtained according to the second dimension information and the second indicator information, and a corresponding pie chart is generated based on the second target display data for display. For example... Figure 5 In the second dimension indicator, when the second indicator is domestic or overseas, and the second indicator is the loan balance, the domestic loan balance and the overseas loan balance (i.e., the second target display data) are obtained, and then a corresponding pie chart is generated based on the domestic loan balance and the overseas loan balance for display.

[0162] In addition, to facilitate users' viewing of pie charts corresponding to indicators at different levels, forward and backward buttons can be set on the pie chart display interface. The forward button will retrieve the pie chart corresponding to the indicator at the previous level, and the backward button will retrieve the pie chart corresponding to the indicator at the next level. For example, for... Figure 5 The pie charts in the image allow you to click the "back" button to access pie charts showing domestic corporate and personal loan data, as well as overseas corporate and personal loan data.

[0163] As another implementation method, the step "determine the corresponding data display strategy according to the target display method" may further include:

[0164] Step A3: If the target display method is a time sequence diagram, then the corresponding data display strategy is determined to be the third data display strategy.

[0165] At this point, step B includes:

[0166] Step B31: Obtain the specified display data based on the third data display strategy, and obtain the third indicator information, third dimension information and filtering condition information corresponding to the specified display data;

[0167] Step B32: Based on the third indicator information, the third dimension information, the filtering condition information, and the preset time range, obtain similar data corresponding to the specified display data, and determine the specified display data and the similar data as the third target display data;

[0168] Step B33: Generate a corresponding time series diagram based on the third target display data for display.

[0169] In this embodiment, if the target display method is a time sequence diagram, the corresponding data display strategy is determined to be the third data display strategy. Then, based on the third data display strategy, specified display data is obtained. This specified display data can be the click data corresponding to when a user triggers a display method switching command by clicking on a certain data point, or it can be the data selected by the user based on the corresponding page. After obtaining the specified display data, the third indicator information, third dimension information, and filtering condition information corresponding to the specified display data are obtained. The filtering condition information includes at least filtering time information (e.g., the data month in the example above), and may also include other filtering information. Then, based on the third indicator information, third dimension information, filtering condition information, and a preset time range, similar data corresponding to the specified display data (i.e., data within the preset time range that meets the third indicator information, third dimension information, and other filtering condition information except for the filtering time information) is obtained, thereby determining the specified display data and similar data as the third target display data. The preset time range can be set according to actual needs, for example, it can be set to a preset number of months from the filtering time information (e.g., 6 months), or monthly data of the year corresponding to the filtering time information. After obtaining the third target display data, a corresponding time series diagram is generated based on the third target display data for display, such as... Figure 6 As shown.

[0170] Through the above methods, the embodiments of the present invention can support multiple data display methods, so that users can switch the data display method according to their own needs, realize personalized data display, and enable users to focus on the data they are interested in, thereby improving the user experience.

[0171] The present invention also provides a data display device.

[0172] Reference Figure 7 , Figure 7 This is a schematic diagram of the functional modules of the first embodiment of the data display device of the present invention.

[0173] like Figure 7 As shown, the data display device includes:

[0174] The first acquisition module 10 is used to acquire the target query index, target query dimension and target filtering conditions according to the data display instruction when it receives the data display instruction;

[0175] The second acquisition module 20 is used to acquire target query data based on the target query indicators, target query dimensions and target filtering conditions;

[0176] The data display module 30 is used to generate a corresponding data display table based on the target query dimension and target query indicator, and to fill the target query data into the data display table for display.

[0177] Furthermore, the second acquisition module 20 includes:

[0178] The expression acquisition unit is used to acquire, according to preset configuration information, the first expression corresponding to the target query indicator, the second expression corresponding to the target query dimension, and the third expression corresponding to the target filtering condition.

[0179] The format conversion unit is used to convert the format of the first expression, the second expression, and the third expression to obtain the format-converted expression.

[0180] The instruction sending unit is used to generate a corresponding data query instruction based on the expression after the format conversion, and send it to the backend server;

[0181] The data receiving unit is used to receive the target query data returned by the backend server based on the data query instruction.

[0182] Furthermore, the data display module 30 includes:

[0183] The first acquisition unit is used to determine the dimension level of each target query dimension according to the input order of the target query dimensions, and to acquire the value corresponding to each target query dimension.

[0184] The first determining unit is used to generate a corresponding dimension structure based on the dimension level of each target query dimension and the value corresponding to each target query dimension, and to determine the row layout information of the data display table based on the dimension structure.

[0185] The second determining unit is used to determine the column layout information of the data display table based on the input order and quantity of the target query dimension and the input order and quantity of the target query indicator.

[0186] The detection unit is used to detect whether there are identical adjacent rows in the same column based on the row layout information and the column layout information.

[0187] The first generation unit is used to generate corresponding merge information if it exists, and to generate a corresponding data display table based on the merge information, the row layout information and the column layout information.

[0188] The second generation unit is used to generate a corresponding data display table based on the row layout information and the column layout information if the table does not exist.

[0189] Furthermore, the data display device also includes:

[0190] The strategy determination module is used to obtain the target display mode according to the display mode switching instruction when a display mode switching instruction is received, and to determine the corresponding data display strategy according to the target display mode;

[0191] The switching display module is used to obtain target display data based on the data display strategy and to display the target display data.

[0192] Furthermore, the strategy determination module includes:

[0193] The first strategy determination unit is used to determine the corresponding data display strategy as the first data display strategy if the target display method is a data analysis table.

[0194] The switching display module includes:

[0195] The third determining unit is used to obtain derived indicators based on the first data display strategy, obtain derived data corresponding to the derived indicators, and determine the derived data and the target query data as the first target display data;

[0196] The information update unit is used to update the column layout information and the row layout information based on the first data display strategy and the derived indicators, so as to obtain the updated column layout information and the updated row layout information.

[0197] The first display unit is used to generate a corresponding data analysis table based on the updated column layout information and the updated row layout information, and to fill the first target display data into the data analysis table for display.

[0198] Furthermore, the strategy determination module also includes:

[0199] The second strategy determination unit is used to determine the corresponding data display strategy as the second data display strategy if the target display method is a pie chart.

[0200] The switching display module includes:

[0201] The second acquisition unit is used to acquire second target display data information based on the second data display strategy. The second target display data information includes second dimension information and second indicator information.

[0202] The second display unit is used to obtain second target display data based on the second dimension information and the second indicator information, and generate a corresponding pie chart based on the second target display data for display.

[0203] Furthermore, the strategy determination module also includes:

[0204] The third strategy determination unit is used to determine the corresponding data display strategy as the third data display strategy if the target display method is a time sequence diagram.

[0205] The switching display module includes:

[0206] The third acquisition unit is used to acquire specified display data based on the third data display strategy, and to acquire the third indicator information, third dimension information and filtering condition information corresponding to the specified display data.

[0207] The fourth acquisition unit is used to acquire similar data corresponding to the specified display data based on the third indicator information, the third dimension information, the filtering condition information and the preset time range, and determine the specified display data and the similar data as the third target display data;

[0208] The third display unit is used to generate a corresponding time sequence diagram based on the third target display data for display.

[0209] The functions of each module in the data display device correspond to the steps in the data display method embodiment, and their functions and implementation processes will not be described in detail here.

[0210] The present invention also provides a computer-readable storage medium storing a data display program, which, when executed by a processor, implements the steps of the data display method as described in any of the above embodiments.

[0211] The specific embodiments of the computer-readable storage medium of the present invention are basically the same as the embodiments of the data display method described above, and will not be repeated here.

[0212] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or system. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or system that includes that element.

[0213] The sequence numbers of the above embodiments of the present invention are for descriptive purposes only and do not represent the superiority or inferiority of the embodiments.

[0214] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) as described above, and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in the various embodiments of the present invention.

[0215] The above are merely preferred embodiments of the present invention and do not limit the scope of the patent. Any equivalent structural or procedural transformations made based on the description and drawings of the present invention, or direct or indirect applications in other related technical fields, are similarly included within the scope of patent protection of the present invention.

Claims

1. A data presentation method, characterized by, The data display method applied to a web page comprises: Upon receiving a data display instruction, obtaining a target query index, a target query dimension, and a target filtering condition according to the data display instruction; Obtaining target query data according to the target query index, the target query dimension, and the target filtering condition; Generating a corresponding data display table according to the target query dimension and the target query index, and filling the target query data into the data display table for display; The step of obtaining target query data according to the target query index, the target query dimension, and the target filtering condition comprises: Obtaining a first expression corresponding to the target query index, a second expression corresponding to the target query dimension, and a third expression corresponding to the target filtering condition according to preset configuration information; for the target query index, the preset configuration information comprises an index field corresponding to the target query index and a corresponding operation function; for the target query dimension, the preset configuration information comprises a dimension expression corresponding to the target query dimension; for the target filtering condition, the preset configuration information comprises a filtering condition expression corresponding to the target filtering condition; Converting the formats of the first expression, the second expression, and the third expression to obtain format-converted expressions; Generating corresponding data query instructions based on the format-converted expressions and sending them to a backend server; Receiving target query data returned by the backend server based on the data query instructions; The step of generating a corresponding data display table according to the target query dimension and the target query index comprises: Determining the dimension levels of each target query dimension according to the input order of the target query dimensions, and obtaining the values corresponding to each target query dimension; Generating a corresponding dimension structure according to the dimension levels of the target query dimensions and the values corresponding to the target query dimensions, and determining the row layout information of the data display table according to the dimension structure; wherein the dimension structure comprises multiple dimension routes, and each dimension route occupies a row in the data display table; According to the input order of the target query dimensions, the target query dimensions are sequentially used as the first m columns of the data display table; according to the input order of the target query indexes, the target query indexes are sequentially used as the last n columns of the data display table, m is the number of target query dimensions, and n is the number of target query indexes.

2. The data presentation method of claim 1, wherein, The method further comprises: Detecting whether there is a case of identical adjacent rows in the same column according to the row layout information and the column layout information; If there is, generating corresponding merging information, and generating a corresponding data display table based on the merging information, the row layout information, and the column layout information; If there is not, generating a corresponding data display table according to the row layout information and the column layout information.

3. The data presentation method of claim 2, wherein, The data display method further comprises: Upon receiving a display mode switching instruction, obtaining a target display mode according to the display mode switching instruction, and determining a corresponding data display strategy according to the target display mode; The data display device obtains target display data based on the data display strategy, and displays the target display data.

4. The data presentation method of claim 3, wherein, The step of determining the corresponding data display strategy according to the target display mode comprises: If the target display mode is a data analysis table, the corresponding data display strategy is determined to be a first data display strategy; The step of obtaining target display data based on the data display strategy and displaying the target display data comprises: Based on the first data display strategy, a derived index is obtained, and corresponding derived data of the derived index is obtained, and the derived data and the target query data are determined to be first target display data; Based on the first data display strategy and the derived index, the column layout information and the row layout information are updated to obtain updated column layout information and updated row layout information; Based on the updated column layout information and the updated row layout information, a corresponding data analysis table is generated, and the first target display data is filled into the data analysis table for display.

5. The data presentation method of claim 3, wherein, The step of determining the corresponding data display strategy according to the target display mode comprises: If the target display mode is a pie chart, the corresponding data display strategy is determined to be a second data display strategy; The step of obtaining target display data based on the data display strategy and displaying the target display data comprises: Based on the second data display strategy, second target display data information is obtained, which includes second dimension information and second index information; According to the second dimension information and the second index information, second target display data is obtained, and a corresponding pie chart is generated according to the second target display data for display.

6. The data presentation method of claim 3, wherein, The step of determining the corresponding data display strategy according to the target display mode comprises: If the target display mode is a time sequence chart, the corresponding data display strategy is determined to be a third data display strategy; The step of obtaining target display data based on the data display strategy and displaying the target display data comprises: Based on the third data display strategy, specified display data is obtained, and corresponding third index information, third dimension information and filtering condition information of the specified display data are obtained; According to the third index information, the third dimension information, the filtering condition information and a preset time range, same type data corresponding to the specified display data is obtained, and the specified display data and the same type data are determined to be third target display data; A corresponding time sequence chart is generated based on the third target display data for display.

7. A data presentation device, characterized by The data display device is applied to a web page, and comprises: A first obtaining module is configured to, when a data display instruction is received, obtain a target query index, a target query dimension and a target filtering condition according to the data display instruction; A second obtaining module is configured to obtain target query data according to the target query index, the target query dimension and the target filtering condition. The data display module is configured to generate a corresponding data display table according to the target query dimensions and target query indicators, and fill the target query data into the data display table for display. The second obtaining module is specifically configured to obtain a first expression corresponding to the target query indicators, a second expression corresponding to the target query dimensions, and a third expression corresponding to the target filtering conditions according to preset configuration information; for the target query indicators, the preset configuration information includes an indicator field corresponding to the target query indicators and a corresponding operation function; for the target query dimensions, the preset configuration information includes a dimension expression corresponding to the target query dimensions; for the target filtering conditions, the preset configuration information includes a filtering condition expression corresponding to the target filtering conditions. The first expression, the second expression, and the third expression are format-converted to obtain format-converted expressions; a corresponding data query instruction is generated based on the format-converted expressions and sent to a backend server; and target query data returned by the backend server based on the data query instruction is received. The data display module is further specifically configured to determine the dimension levels of each target query dimension according to the input order of the target query dimensions, and obtain values corresponding to each target query dimension. According to the dimension levels of the target query dimensions and the values corresponding to the target query dimensions, a corresponding dimension structure is generated, and row layout information of a data display table is determined according to the dimension structure; wherein the dimension structure includes multiple dimension routes, and each dimension route occupies a row in the data display table. According to the input order of the target query dimensions, the target query dimensions are sequentially used as the first m columns of a data display table; and according to the input order of the target query indicators, the target query indicators are sequentially used as the last n columns of the data display table, m is the number of target query dimensions, and n is the number of target query indicators.

8. A data display device, characterized by The data display device includes a memory, a processor, and a data display program stored on the memory and executable on the processor, and the data display program, when executed by the processor, implements the steps of the data display method of any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a data display program, and the data display program, when executed by a processor, implements the steps of the data display method of any one of claims 1 to 6.

10. A computer program product, characterised in that, The computer program product stores instructions, and when a computer reads and executes the instructions, the computer executes the method of any one of claims 1 to 6.

Images