CN115113862A - A method, device, electronic device and storage medium for creating a derived index - Google Patents

Abstract

The invention discloses a method and a device for creating a derived index, electronic equipment and a storage medium, wherein the method comprises the following steps: responding to a derivative index creating instruction sent by a client, and displaying an index creating interface, wherein the index creating interface displays an index calculation logic configuration area, an index basic information setting area and a plurality of visual program controls; responding to an index configuration operation acted on the index creation interface, and determining the configuration of the derived index, wherein the index configuration operation at least comprises a logic operation setting operation of a visual program control selected in the index calculation logic configuration area and a basic information setting operation performed in the index basic information setting area; and in response to a saving operation acting on the index creation interface, saving the configuration of the derived index to generate a derived index. The invention solves the problems that the current index has poor flexibility and is difficult to flexibly process more complex index data statistical logic.

Description

A method, device, electronic device and storage medium for creating a derived index

technical field

The invention relates to the technical field of data processing, in particular to a method, device, electronic device and storage medium for creating a derived index.

Background technique

At present, the logic based on data statistics is usually selected through the rules preset by the system. Each indicator is usually the default statistics of the system. Generally, indicators are mainly divided into two major types, including numerical type and count type. Among them, numerical type, That is, the amount, quantity, etc. directly calculated by business logic. The count type is divided into unique count and non-unique count. It is obtained by counting the code value in a certain field. The traditional indicator function is relatively simple and the flexibility is poor. It is difficult to flexibly handle more complex indicator data statistical logic. When it needs to be applied to complex indicator data statistical logic, professional personnel are required to carry out program design, which is inconvenient to use, and has high professional requirements.

SUMMARY OF THE INVENTION

The purpose of the present invention is to overcome the above technical deficiencies, and to provide a method, device, electronic device and storage medium for creating a derived index, so as to solve the technical problem of poor index flexibility and difficulty in flexibly handling more complex index data statistical logic in the prior art.

In order to achieve the above-mentioned technical purpose, the present invention has adopted the following technical solutions:

In a first aspect, the present invention provides a method for creating a derived index, including:

In response to the derived indicator creation instruction sent by the client, an indicator creation interface is displayed, wherein the indicator creation interface displays an indicator calculation logic configuration area, an indicator basic information setting area, and a plurality of visualization program controls;

In response to an indicator configuration operation acting on the indicator creation interface, the configuration of the derived indicator is determined, wherein the indicator configuration operation at least includes the logic operation setting of the visual program control selected in the indicator calculation logic configuration area operations and basic information setting operations performed in the indicator basic information setting area;

In response to a save operation acting on the indicator creation interface, the configuration of the derived indicator is saved to generate a derived indicator.

In some embodiments, the logical operation setting operation includes a selection operation and a dragging operation, and the determining the configuration of the derived indicator in response to an indicator configuration operation acting on the indicator creation interface includes:

Based on the selection operation acting on the indicator creation interface, the visualization program control selected by the user is displayed in the indicator calculation logic configuration area;

Based on the drag-and-drop operation acting on the indicator creation interface, the selected visual program controls are combined to realize the logical operation configuration of the derived indicator;

The basic information of the derived indicator is configured based on the basic information setting operation acting on the indicator basic information setting area.

In some embodiments, the visualizer controls include at least an atomic indicator type visualizer control, a function type visualizer control, and an operator type visualizer control.

In some embodiments, the visualization program controls selected by the user are displayed in the indicator calculation logic configuration area based on the selection operation acting on the indicator creation interface, including:

Based on the selection operation acting on the indicator creation interface, after selecting a number of atomic indicator type visualization program controls, they are displayed in the indicator calculation logic configuration area; and

Based on the selection operation acting on the indicator creation interface, select several function type visualization program controls to perform parameter configuration on the selected function type visualization program controls, and then display them in the indicator calculation logic configuration area; and/or

Based on the selection operations acting on the indicator creation interface, after selecting several operator type visualization program controls, they are displayed in the indicator calculation logic configuration area.

In some embodiments, in response to a save operation acting on the indicator creation interface, saving the configuration of the derived indicator to generate the derived indicator includes:

In response to the saving operation acting on the indicator creation interface, verifying the configuration of the derived indicator;

When the configuration verification of the derived indicator passes, the configuration of the derived indicator is saved to generate a derived indicator, otherwise, configuration failure information is generated and displayed on the indicator creation interface.

In some embodiments, the verifying the configuration of the derived indicator in response to the saving operation acting on the indicator creation interface includes:

In response to the saving operation acting on the indicator creation interface, a preset indicator verification control is used to verify the configuration of the derived indicator, wherein the indicator verification control is configured with indicator verification rules, and the The index verification rule is used to perform logical operation verification of the configuration of the derived index.

In some embodiments, in response to the saving operation acting on the indicator creation interface, after saving the configuration of the derived indicator to generate the derived indicator, the method further includes:

According to the metadata corresponding to the derived index, index information corresponding to the derived index is generated.

In a second aspect, the present invention also provides a device for creating a derived index, including:

an interface display module, configured to display an indicator creation interface in response to a derived indicator creation instruction sent by the client, wherein the indicator creation interface displays an indicator calculation logic configuration area, an indicator basic information setting area, and a plurality of visualization program controls;

an indicator configuration module, configured to determine the configuration of the derived indicator in response to an indicator configuration operation acting on the indicator creation interface, wherein the indicator configuration operation at least includes visualization of selection in the indicator calculation logic configuration area The logic operation setting operation of the program control and the basic information setting operation performed in the basic information setting area of the indicator;

The indicator generation module is configured to save the configuration of the derived indicator in response to the saving operation acting on the indicator creation interface, so as to generate the derived indicator.

In a third aspect, the present invention also provides an electronic device, comprising: a processor and a memory;

a computer program executable by the processor is stored on the memory;

When the processor executes the computer program, the steps in the above-described method for creating a derived indicator are implemented.

In a fourth aspect, the present invention also provides a computer-readable storage medium, where the computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to achieve Steps in the method of creating the derived indicator as described above.

The method, device, electronic device and storage medium for creating a derived indicator provided by the present invention provide the user with an indicator creating interface with various visual program controls, so that the user can operate on the indicator creating interface, and use the visual program controls to perform operations on their own Logical operation configuration and basic information configuration of the required derived indicators, simple operation, short development cycle, improved development efficiency and ease of creation of derived indicators, and more flexible derived indicators, which can flexibly handle more complex The statistical logic of indicator data is more efficient and allows business parties to reduce their dependence on data development.

Description of drawings

1 is a system architecture diagram of an embodiment of a derived index creation platform provided by the present invention;

2 is a flowchart of an embodiment of a method for creating a derived index provided by the present invention;

3 is a flowchart of an embodiment of step S200 in the method for creating a derived index provided by the present invention;

4 is a flowchart of an embodiment of step S300 in the method for creating a derived index provided by the present invention;

Fig. 5 is the functional module schematic diagram of the derived index creation device provided by the present invention;

FIG. 6 is a schematic diagram of the hardware structure of the electronic device provided by the present invention.

Detailed ways

In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

The technical solutions of the embodiments of the present invention can be applied to scenarios in which a large number of repetitive and fixed operations need to be performed in the fields of IT technology, human resources service, supply chain, and finance. Provides multiple visual program controls with different functions. Users can select a visual program control with corresponding functions on the indicator creation interface according to specific needs. Derivative indicators used to execute a large number of repetitive and fixed indicator data statistical logic, the creation of derived indicators can be completed without the need for users to master too much development knowledge, which shortens the development cycle and development difficulty of derived indicators, and enables users to develop quickly. Users can create derived indicators that they want to develop, and users can create derived indicators that are highly flexible and can flexibly handle complex statistical logic of indicator data according to their needs.

Referring to FIG. 1, FIG. 1 is a schematic diagram of a system architecture of a derived indicator creation platform provided by an embodiment of the present invention. As shown in the figure, the derived indicator creation platform may include a derived indicator creation server 101 and a display terminal 102, wherein the derived indicator The creation server 101 creates a “back-end device” of the platform for the derived indicator, and there may be one or more derived indicator creation servers 101 , which may be used to provide support and services to the display terminal 102 . The derived index creation server 101 stores multiple application controls with different functions, and the multiple application controls with different functions can be displayed on the display terminal 102 in a visual form. The display terminal 102 is the "front-end device" of the derived indicator creation platform, which can be used to display the indicator creation interface to the user. The display terminal 102 can interact with the user, obtain the user's user operation on the indexable index creation interface, and feed back the user operation to the derived index creation server 101 in a direct or indirect manner. Specifically, the display terminal 102 may be a mobile phone, a computer, a tablet computer or the like. The derived indicator creation platform may be a client/server (client/server, C/S) architecture platform. In this case, the display terminal 102 is to install a client corresponding to the derived indicator creation platform. The derived indicator creation platform may also be a browser/server (browser/server, B/S) architecture platform. In this case, the display terminal 102 is a browser installed with which the derived indicator creation platform can be browsed.

Please refer to FIG. 2. FIG. 2 is a schematic flowchart of a method for creating a derived indicator according to an embodiment of the invention. The method can be implemented on the server for creating a derived indicator shown in FIG. 1. As shown in the figure, the method includes step S100. Go to step S300.

S100. In response to the derived indicator creation instruction sent by the client, display an indicator creation interface, wherein the indicator creation interface displays an indicator calculation logic configuration area, an indicator basic information setting area, and a plurality of visualization program controls.

In this embodiment, the derived index creation instruction is used to create a derived index, and the derived index is an index obtained by performing addition, subtraction, multiplication and division on the atomic index or the limitation of modifiers. Derived indicators can be applied to situations that require statistical and logical calculation of indicator data, such as IT technology, human resource services, supply chain, finance, and so on.

The client is used to provide a visual interface according to the control of the server, and the server realizes the creation of derived indicators according to the content received on the visual interface. The client can be a display terminal, which can provide a login interface. After the user successfully logs in through his own account and other login information, the client sends a derived indicator creation instruction to the server. The derived indicator creation instruction may include a request to open the The command of the indicator creation interface, the server responds to the command and displays the indicator creation interface on the client side.

The indicator creation interface has an indicator calculation logic configuration area and an indicator basic information setting area. The indicator calculation logic configuration area is used for users to configure the calculation logic of derived indicators, such as combining atomic indicators and operators in the area to generate An operation logic, the operation logic can perform logical calculation, and the basic information setting area of the indicator is used to set the basic information of the derived indicator, such as basic information such as indicator caliber, indicator similarity, and the business line. In addition, the indicator creation interface displays multiple visualization program controls. After the user clicks or selects one of the visualization program controls, the indicator creation interface can also display subprogram controls corresponding to each function that the visualization program control can provide. For example, the subprogram control is Go to the action subroutine control of the parameter configuration page of the visualizer control.

S200. In response to an indicator configuration operation acting on the indicator creation interface, determine the configuration of the derived indicator, wherein the indicator configuration operation at least includes the logic of the visualization program control selected in the indicator calculation logic configuration area The operation setting operation and the basic information setting operation performed in the indicator basic information setting area.

In this embodiment, the user's indicator configuration operation on the indicator creation interface may be an operation that the user indirectly acts on the indicator creation interface through a mouse, a keyboard, etc.; the user's indicator configuration operation on the indicator creation interface may also be performed by the user through fingers, The touch screen pen directly acts on the operations on the indicator creation interface. The indicator configuration operation may include an operation by the user to select a visual program control on the indicator creation interface, a logical operation setting operation of the visual program control selected in the indicator calculation logic configuration area, and basic information in the indicator basic information setting area. Set the action.

S300. In response to the save operation acting on the indicator creation interface, save the configuration of the derived indicator to generate a derived indicator.

In this embodiment, the user's saving operation on the indicator creation interface refers to the operation of saving the configuration of the derived indicator on the indicator creation interface after the user completes the configuration of the derived indicator. Exemplarily, there is a "save" button on the indicator creation interface. After the user's configuration is completed, click the "save" button to save the configuration of the derived indicator, thereby generating the desired derived indicator.

The embodiment of the present invention provides the user with an index creation interface with multiple visual program controls, so that the user can operate on the index creation interface, and use the visualized program control to perform logical operation configuration and basic information configuration for the derived index required by himself, The operation is simple and the development cycle is short, which improves the development efficiency and ease of use of derived indicators, and makes the derived indicators more flexible, able to flexibly handle more complex indicator data statistical logic, higher utilization efficiency, and make the derived indicators more flexible. Business parties can reduce their reliance on data development.

In some embodiments, referring to FIG. 3 , the logical operation setting operation includes a selection operation and a dragging operation, and the configuration of the derived indicator is determined in response to an indicator configuration operation acting on the indicator creation interface, include:

S210, based on the selection operation acting on the indicator creation interface, display the visual program control selected by the user in the indicator calculation logic configuration area;

S220, based on the drag-and-drop operation acting on the index creation interface, combine the selected visual program controls to realize the logical operation configuration of the derived index;

S230. Configure the basic information of the derived indicator based on the basic information setting operation acting on the indicator basic information setting area.

In this embodiment, the user first selects the desired visualization program control on the visualization interface. Specifically, the visualization program control on the interface can be created by clicking on the indicator. After clicking, the name of the visualization program control will be displayed in the indicator calculation logic configuration area. , and then the user can drag and drop the selected visual program controls in the indicator calculation logic configuration area, so that each visual program control can be combined according to the user's needs and appear in the appropriate position, and the logic calculation can be performed according to the user's needs, so as to meet the requirements The configuration of derived indicators required by users, and because the creation rules are simple and clear, and the use of visual indicator creation increases the ease of use of derived indicators. The required derived indicators can be obtained quickly, which is simple and convenient.

After the configuration is complete, the user can input the basic information of the derived indicator by directly inputting the basic information of the indicator in the indicator basic information setting area of the indicator creation interface, such as inputting basic information such as indicator caliber, similar indicator, and business line to which it belongs. easy and convenient.

In some embodiments, the visualizer controls include at least an atomic indicator type visualizer control, a function type visualizer control, and an operator type visualizer control.

In this embodiment, in order to increase the computing capability of the derived index, the desired derived index can be obtained by combining a variety of different types of visualization program controls. Among them, the atomic indicator type visualization program controls are various atomic indicators, such as numerical indicators, count indicators, and so on. Each atomic indicator is configured with dimension information in the background of the derived indicator creation platform, such as institution, channel, product type, wealth level, etc. When multiple different atomic indicators are selected, the derived indicator creation platform will check the atomic indicators. Whether there is an intersection of the dimensions between them, so that the merge calculation operation can be performed.

The function type visualization program control is used to set the calculation rules between various atomic indicators, and the function type visualization program control is used to realize the standard of data statistical calculation. The function type visualization degree control includes but is not limited to the average function, the maximum value function, minimum function, median function, fixed value function, time offset function, conditional filter function, etc.

The operator type visualization program control is a control that performs four arithmetic operations on atomic indicators, and the operator type visualization program control includes but is not limited to plus sign, minus sign, multiplication sign, division sign, parentheses and so on.

In the embodiment of the present invention, by combining the atomic index with the operation function or operator, the configuration of the derived index can be quickly obtained according to the requirements, so as to achieve the purpose of quickly creating the derived index. Complex indicator data statistics logic.

In some embodiments, the step S210 includes:

Based on the selection operation acting on the indicator creation interface, after selecting a number of atomic indicator type visualization program controls, they are displayed in the indicator calculation logic configuration area; and

Based on the selection operation acting on the indicator creation interface, select several function type visualization program controls to perform parameter configuration on the selected function type visualization program controls, and then display them in the indicator calculation logic configuration area; and/or

Based on the selection operations acting on the indicator creation interface, after selecting several operator type visualization program controls, they are displayed in the indicator calculation logic configuration area.

In this embodiment, the user first clicks the indicator control on the indicator creation interface, and after selecting the derived indicator to be calculated, the name of the derived indicator is displayed in the indicator calculation logic configuration area, and then the user clicks the operator or function, and the operator and function also appear in the In the index calculation logic configuration area, the selected controls in the index calculation logic configuration area appear based on the order of precedence. You need to drag the "+" sign to the correct position, and calculate according to the four operation rules.

When selecting a function, you need to configure parameters for the function. Specifically, the maximum value function, the minimum value function, the average value function, and the median function are calculated within the selected dimension code value range. The maximum, minimum, average and median of the Putin amount. The fixed value function is a special function that can lock the amount of a certain atomic indicator so that it will not be affected by the filter conditions. For example, if you want to calculate the proportion of the bank's total amount of money, you can set the denominator to the fixed value of the money amount. , and the numerator is the amount of the deposit (the amount of the deposit/fixed value [the amount of the deposit]), then when viewing the indicator, the users of the Shanghai branch and the Shenzhen branch can see that the deposit amount of the Shanghai branch and the Shenzhen branch accounts for the total amount of the deposit. ratio of rows. The Tianjian filter function can filter the filter conditions for the index. For example, if you only care about the deposit amount of the Shanghai branch, you can set the filter condition to be the summary of the Shanghai branch. The time offset function can specify the query time for the indicator, and supports dynamic N days ago, N weeks ago, N months ago, or fixed dates; for example, if you want to know the amount of the deposit amount 30 days ago, you can configure 30 days ago. If you want to know the value of December 31, 2021, you can set a fixed date as 2021-12-31; through the time offset, indicators such as year-on-year growth and relative fixed date growth can be calculated. Through the condition filtering and time offset calculation functions designed around the scene, the ability of derived indicators has been greatly expanded, so that derived indicators can be applied in a wider range.

In some embodiments, referring to FIG. 4 , the step S300 includes:

S310, in response to the saving operation acting on the indicator creation interface, verifying the configuration of the derived indicator;

S320. When the configuration verification of the derived indicator passes, save the configuration of the derived indicator to generate a derived indicator, otherwise, generate configuration failure information and display it on the indicator creation interface.

In this embodiment, in order to ensure the rationality of the user's configuration of the derived indicators, it is necessary to verify the configuration of the derived indicators before saving the configuration of the derived indicators, so as to prevent the derived indicators from being unusable due to unreasonable configuration. When the configuration of the derived indicators is reasonable, the derived indicators are directly saved. When the configuration of the derived indicator is unreasonable, configuration failure information is generated and displayed, wherein the configuration failure information includes information indicating that the configuration fails and information about the reason for the configuration failure. Exemplarily, when the verification is passed, a pop-up window may be used to display that the indicator has been created successfully, and the derived indicator after the verification is passed can be applied in the indicator map, indicator map, indicator board and other occasions. When the verification fails, a pop-up window will prompt the verification failure, and the reason for the verification failure will be displayed on the pop-up window.

In some embodiments, the step S310 includes:

In response to the saving operation acting on the indicator creation interface, a preset indicator verification control is used to verify the configuration of the derived indicator, wherein the indicator verification control is configured with indicator verification rules, and the The index verification rule is used to perform logical operation verification of the configuration of the derived index.

In this embodiment, the derived indicator creation platform is preset with an indicator verification control configured with indicator verification rules. When the user clicks the "Save" button, the indicator verification control uses the indicator verification rules to configure the derived indicators. Check, for example, check whether there are unpaired parentheses, whether there are derived indicators that are not connected by operators, etc. Since the embodiment of the present invention does not allow manual input of operators, other illegal input situations can be avoided, and further Save the time and content of verification and speed up verification efficiency.

In some embodiments, in order to facilitate the search of the created derived index, the derived index creation method further includes:

According to the metadata corresponding to the derived index, index information corresponding to the derived index is generated.

In this embodiment, after the derived index is saved, an index can be set for the derived index, so that the index can be directly used to find the desired derived index in the application stage. During specific implementation, the metadata corresponding to the index in the derived index creation platform can be used to set the index information, so as to facilitate the user's search. In application, for example, the user first queries the metadata corresponding to the derived indicator, then obtains the index information generated by the derived indicator in advance, and then generates a SQL query statement according to the index information, and then queries the required data through the SQL query statement. derived indicators.

Through the index derivation function, the embodiment of the present invention can greatly improve the utilization efficiency of the index, so that the business party can reduce the dependence on data development; through the visual index creation technology, the ease of use of the index creation is increased, and the creation rules are simple and clear; In addition, the condition filtering and time offset calculation functions designed around the scene greatly expand the ability of index derivation, so that index derivation can be applied in a wider range.

Another embodiment of the present invention provides an apparatus for creating a derived indicator. Please refer to FIG. 5 . The apparatus for creating a derived indicator includes an interface display module 11 , an indicator configuration module 12 and an indicator generation module 13 .

The interface display module 11 is configured to display an indicator creation interface in response to a derived indicator creation instruction sent by the client, wherein the indicator creation interface displays an indicator calculation logic configuration area, an indicator basic information setting area, and a plurality of visualization program controls;

The indicator configuration module 12 is configured to determine the configuration of the derived indicator in response to an indicator configuration operation acting on the indicator creation interface, wherein the indicator configuration operation at least includes visualization of selection in the indicator calculation logic configuration area The logic operation setting operation of the program control and the basic information setting operation performed in the basic information setting area of the indicator;

The indicator generating module 13 is configured to save the configuration of the derived indicator in response to the saving operation acting on the indicator creation interface, so as to generate the derived indicator.

The embodiment of the present invention provides the user with an index creation interface with multiple visual program controls, so that the user can operate on the index creation interface, and use the visualized program control to perform logical operation configuration and basic information configuration for the derived index required by himself, The operation is simple and the development cycle is short, which improves the development efficiency and ease of use of derived indicators, and makes the derived indicators more flexible, able to flexibly handle more complex indicator data statistical logic, higher utilization efficiency, and make the derived indicators more flexible. Business parties can reduce their reliance on data development.

It should be noted that the module referred to in the present invention refers to a series of computer program instruction segments capable of completing specific functions, and is more suitable for describing the execution process of the creation of the derived index than the program. For the specific implementation of each module, please refer to the corresponding method above. Examples are not repeated here.

In some embodiments, the logic operation setting operation includes a selection operation and a drag operation, and the index configuration module 12 includes a selection unit, a drag unit, and a basic information setting unit.

The selection unit is configured to display the visual program control selected by the user in the indicator calculation logic configuration area based on the selection operation acting on the indicator creation interface.

The drag-and-drop unit is configured to combine the selected visual program controls based on the drag-and-drop operation acting on the indicator creation interface, so as to realize the logical operation configuration of the derived indicator.

The basic information setting unit is configured to configure the basic information of the derived indicator based on the basic information setting operation acting on the indicator basic information setting area.

In some embodiments, the visualizer controls include at least an atomic indicator type visualizer control, a function type visualizer control, and an operator type visualizer control.

In some embodiments, the selection unit includes an indicator display unit, a function display unit and an operator display unit.

The indicator display unit is used for selecting a number of atomic indicator type visualization program controls based on the selection operation acting on the indicator creation interface, and displaying them in the indicator calculation logic configuration area.

The function display unit is used for selecting a number of function type visualization program controls based on the selection operation acting on the indicator creation interface, after configuring the parameters of the selected function type visualization program controls, and displaying them in the indicator calculation logic configuration area.

The operator display unit is used for selecting a number of operator type visualization program controls based on the selection operation acting on the indicator creation interface, and displaying them in the indicator calculation logic configuration area.

In some embodiments, the indicator generating module 13 includes a checking unit and a saving unit.

The verification unit is configured to verify the configuration of the derived indicator in response to the saving operation acting on the indicator creation interface.

The saving unit is configured to save the configuration of the derived index when the configuration verification of the derived index is passed, so as to generate a derived index, otherwise, generate configuration failure information and display it on the index creation interface.

In some embodiments, the verification unit is specifically configured to use a preset indicator verification control to verify the configuration of the derived indicator in response to a save operation acting on the indicator creation interface, wherein the indicator The verification control is configured with an indicator verification rule, and the indicator verification rule is used to perform logical operation verification of the configuration of the derived indicator.

In some embodiments, the apparatus for creating a derived indicator further includes an index generation module configured to generate index information corresponding to the derived indicator according to metadata corresponding to the derived indicator.

Another embodiment of the present invention provides an electronic device. As shown in FIG. 6 , the electronic device 10 includes:

One or more processors 110 and the memory 120 are described by taking one processor 110 as an example in FIG. 4 . The processor 110 and the memory 120 may be connected by a bus or in other ways. In FIG. 6 , the connection by a bus is taken as an example.

The processor 110 is used to complete various control logics of the electronic device 10, which can be a general-purpose processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA), a single-chip microcomputer, an ARM ( Acorn RISCMachine) or other programmable logic devices, discrete gate or transistor logic, discrete hardware components, or any combination of these components. Also, the processor 110 may be any conventional processor, microprocessor or state machine. The processor 110 may also be implemented as a combination of computing devices, eg, a combination of a DSP and a microprocessor, multiple microprocessors, one or more microprocessors in combination with a DSP, and/or any other such configuration.

The memory 120, as a non-volatile computer-readable storage medium, can be used to store non-volatile software programs, non-volatile computer-executable programs and modules, such as programs corresponding to the method for creating a derived index in the embodiment of the present invention instruction. The processor 110 executes various functional applications and data processing of the electronic device 10 by running the non-volatile software programs, instructions and units stored in the memory 120 , that is, to implement the method for creating derived indicators in the above method embodiments.

The memory 120 may include a storage program area and a storage data area, wherein the storage program area may store an operating platform, an application program required for at least one function; the storage data area may store data created according to the use of the electronic device 10 and the like. Additionally, memory 120 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some embodiments, memory 120 may optionally include memory located remotely from processor 110, which may be connected to electronic device 10 via a network. Examples of such networks include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

One or more units are stored in the memory 120, and when executed by one or more processors 110, execute the derived index creation method in any of the above method embodiments, for example, execute the above-described method steps S100 to 2 in FIG. Step S300.

Another embodiment of the present invention provides a computer-readable storage medium storing computer-executable instructions, the computer-executable instructions being executed by one or more processors, for example, executing the above-described FIG. 2 The method in step S100 to step S300.

As examples, the computer-readable storage medium can include read only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM), or flash memory. Volatile memory can include random access memory (RAM) as external cache memory. By way of illustration and not limitation, RAM may be configured in a variety of formats such as Synchronous RAM (SRAM), Dynamic RAM, (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchlink DRAM (SLDRAM), and Direct Rambus (Lambas) RAM (DRRAM) and many other forms. The disclosed memory components or memories of the operating environments described herein are intended to include one or more of these and/or any other suitable types of memory.

To sum up, the method, device, electronic device and storage medium for creating a derived indicator provided by the present invention provide the user with an indicator creating interface with a variety of visual program controls, so that the user can operate on the indicator creating interface and utilize the visualization program. It is easy to operate and has a short development cycle, which improves the development efficiency and ease of use of derived indicators, and makes the derived indicators more flexible and able to Flexible processing of more complex indicator data statistics logic, higher utilization efficiency, and allows business parties to reduce their dependence on data development.

The specific embodiments of the present invention described above do not limit the protection scope of the present invention. Any other corresponding changes and modifications made according to the technical concept of the present invention shall be included in the protection scope of the claims of the present invention.

Claims (10)

1. A method for creating a derived index, comprising: In response to the derived indicator creation instruction sent by the client, an indicator creation interface is displayed, wherein the indicator creation interface displays an indicator calculation logic configuration area, an indicator basic information setting area, and a plurality of visualization program controls; In response to an indicator configuration operation acting on the indicator creation interface, the configuration of the derived indicator is determined, wherein the indicator configuration operation at least includes the logic operation setting of the visual program control selected in the indicator calculation logic configuration area operations and basic information setting operations performed in the indicator basic information setting area; In response to a save operation acting on the indicator creation interface, the configuration of the derived indicator is saved to generate a derived indicator. 2 . The method for creating a derived indicator according to claim 1 , wherein the logical operation setting operation includes a selection operation and a dragging operation, and the determination is made in response to an indicator configuration operation acting on the indicator creation interface. 3 . The configuration of the derived indicator includes: Based on the selection operation acting on the indicator creation interface, the visualization program control selected by the user is displayed in the indicator calculation logic configuration area; Based on the drag-and-drop operation acting on the indicator creation interface, the selected visual program controls are combined to realize the logical operation configuration of the derived indicator; The basic information of the derived indicator is configured based on the basic information setting operation acting on the indicator basic information setting area. 3 . The method for creating a derived indicator according to claim 2 , wherein the visualization program controls at least include atomic indicator type visualization program controls, function type visualization program controls, and operator type visualization program controls. 4 . 4. The method for creating a derived indicator according to claim 3, wherein, based on the selection operation acting on the indicator creation interface, the visualization program control selected by the user is displayed in the indicator calculation logic configuration area, comprising: Based on the selection operation acting on the indicator creation interface, after selecting a number of atomic indicator type visualization program controls, they are displayed in the indicator calculation logic configuration area; and Based on the selection operation acting on the indicator creation interface, select several function type visualization program controls to perform parameter configuration on the selected function type visualization program controls, and then display them in the indicator calculation logic configuration area; and/or Based on the selection operations acting on the indicator creation interface, after selecting several operator type visualization program controls, they are displayed in the indicator calculation logic configuration area. 5 . The method for creating a derived indicator according to claim 1 , wherein, in response to a save operation acting on the indicator creation interface, the configuration of the derived indicator is saved to generate the derived indicator, comprising: 6 . In response to the saving operation acting on the indicator creation interface, verifying the configuration of the derived indicator; When the configuration verification of the derived indicator passes, the configuration of the derived indicator is saved to generate a derived indicator, otherwise, configuration failure information is generated and displayed on the indicator creation interface. 6 . The method for creating a derived indicator according to claim 5 , wherein, in response to a save operation acting on the indicator creation interface, verifying the configuration of the derived indicator comprises: 6 . In response to the saving operation acting on the indicator creation interface, a preset indicator verification control is used to verify the configuration of the derived indicator, wherein the indicator verification control is configured with indicator verification rules, and the The index verification rule is used to perform logical operation verification of the configuration of the derived index. 7. The method for creating a derived indicator according to claim 1, wherein the configuration of the derived indicator is saved in response to a saving operation acting on the indicator creation interface, so that after generating the derived indicator, the include: According to the metadata corresponding to the derived index, index information corresponding to the derived index is generated. 8. A device for creating a derived index, comprising: an interface display module, configured to display an indicator creation interface in response to a derived indicator creation instruction sent by the client, wherein the indicator creation interface displays an indicator calculation logic configuration area, an indicator basic information setting area, and a plurality of visualization program controls; an indicator configuration module, configured to determine the configuration of the derived indicator in response to an indicator configuration operation acting on the indicator creation interface, wherein the indicator configuration operation at least includes visualization of selection in the indicator calculation logic configuration area The logic operation setting operation of the program control and the basic information setting operation performed in the basic information setting area of the indicator; The indicator generation module is configured to save the configuration of the derived indicator in response to the saving operation acting on the indicator creation interface, so as to generate the derived indicator. 9. An electronic device, comprising: a processor and a memory; a computer program executable by the processor is stored on the memory; When the processor executes the computer program, the steps in the method for creating a derived indicator according to any one of claims 1-7 are implemented. 10. A computer-readable storage medium, characterized in that, the computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to realize the claim Steps in the derived indicator creation method described in any one of requirements 1-7.

Images