CN114089934A - Target variable and influence factor display method and device - Google Patents
Target variable and influence factor display method and device Download PDFInfo
- Publication number
- CN114089934A CN114089934A CN202111172936.9A CN202111172936A CN114089934A CN 114089934 A CN114089934 A CN 114089934A CN 202111172936 A CN202111172936 A CN 202111172936A CN 114089934 A CN114089934 A CN 114089934A
- Authority
- CN
- China
- Prior art keywords
- target variable
- value
- influence factor
- influence
- cells
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/14—Digital output to display device ; Cooperation and interconnection of the display device with other functional units
- G06F3/1407—General aspects irrespective of display type, e.g. determination of decimal point position, display with fixed or driving decimal point, suppression of non-significant zeros
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Abstract
The application discloses a display method of target variables and influence factors, which comprises the following steps: receiving a selection event of a target variable or an influence factor through a table file, and highlighting the influence factor related to the selected target variable or highlighting the target variable related to the selected influence factor based on an operation formula in response to the selection event. The table file stores a plurality of target variables and a plurality of influence factors, the target variables are stored in cells of the table file in the form of an operation formula, the influence factors are also stored in the cells of the table file, and the cells of the influence factors are used as operation cells of the operation formula. In this way, the present application can highlight other indexes associated with the selected index by a simple operation.
Description
Technical Field
The present application relates to the field of internet technologies, and in particular, to a method and an apparatus for displaying a target variable and an impact factor.
Background
When developing the sensitivity analysis process, a sensitivity analysis scheme index library is required to be set, influence factors which have important influence on the target variable are found out one by one from a plurality of uncertain factors, and the influence degree of the influence factors on the target variable is analyzed and calculated.
Due to the fact that different users are responsible for different services, the concerned index ranges are different, and in the face of massive target variables in the model, the users need to select the concerned target variable indexes and the associated influence factor indexes. In the prior art, manual index selection is mostly adopted, the accuracy and integrity of the selected index are poor, and the user is required to have very deep knowledge on the indexes in the model and the logical relationship between the indexes so as to select the indexes.
Disclosure of Invention
The technical problem that the present application mainly solves is to provide a method and an apparatus for displaying a target variable and an impact factor, which can highlight other indexes associated with a selected index by simple operations.
In order to solve the above technical problem, a first aspect of the present application provides a method for displaying a target variable and an impact factor, the method including: receiving a selection event of a target variable or an influence factor through a table file; the table file stores a plurality of target variables and a plurality of influence factors, the target variables are stored in cells of the table file in the form of an operation formula, the influence factors are also stored in the cells of the table file, and the cells of the influence factors are used as operation cells of the operation formula; in response to a selection event, the impact factor associated with the selected target variable is highlighted, or the target variable associated with the selected impact factor is highlighted, based on the operational formula.
In order to solve the above technical problem, a second aspect of the present application provides an electronic device, which includes a memory and a processor connected to each other, wherein the memory stores program instructions, and the processor is configured to execute the program instructions to implement the method for displaying the target variable and the influencing factor of the first aspect.
To solve the above technical problem, a third aspect of the present application provides a computer storage medium for storing instructions/program data that can be executed to implement the above display method of target variables and influence factors.
The beneficial effect of this application is: different from the prior art, the method receives selection events of target variables or influence factors through a table file; storing a plurality of target variables and a plurality of influence factors in a table file, wherein the target variables are stored in cells of the table file in the form of an operation formula, the influence factors are also stored in the cells of the table file, and the cells of the influence factors are used as operation cells of the operation formula; and in response to the selection event, based on the operational relationship between the target variable and the influence factor, positioning and highlighting the influence factor related to the selected target variable, or positioning and highlighting the target variable related to the selected influence factor.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating a first embodiment of a method for displaying target variables and impact factors according to the present application;
FIG. 2 is a schematic flow chart of a second embodiment of a method for displaying target variables and impact factors according to the present application;
FIG. 3 is a schematic flow chart of a third embodiment of a method for displaying target variables and impact factors according to the present application;
FIG. 4 is a schematic flow chart of a fourth embodiment of a method for displaying target variables and influence factors according to the present application;
FIG. 5 is a flow chart of a fifth embodiment of the display method of the target variables and the influence factors of the present application;
FIG. 6 is a schematic diagram of a frame structure of an embodiment of an electronic device provided in the present application;
FIG. 7 is a block diagram of an embodiment of a computer storage medium according to the present application.
Detailed Description
The technical solutions in the embodiments of the present application are clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that, in the embodiments of the present application, there are descriptions related to "first", "second", etc., and the descriptions of "first", "second", etc. are only used for descriptive purposes and are not to be interpreted as indicating or implying relative importance or implicitly indicating the number of indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature.
Referring to fig. 1, fig. 1 is a schematic flow chart illustrating a method for displaying a target variable and an influence factor according to a first embodiment of the present application. The display method comprises the following steps:
s110: receiving a selection event of the target variable or the influence factor through a table file; a plurality of target variables and a plurality of influence factors are stored in a table file, the target variables are stored in cells of the table file in the form of an operation formula, the influence factors are also stored in the cells of the table file, and the cells of the influence factors are used as operation cells of the operation formula.
After a user clicks a target variable or a response factor, the electronic equipment receives a selection event of the clicked target variable or the clicked influence factor through the form file. The form file is preset in advance, and can be specifically established through the following steps:
step one, constructing a model format.
The method comprises the steps of constructing a model format through a table, drawing the table in a browser interface in a row-column mode according to initialization parameters (initConfig) through a script, and using an html5 canvas technology; a plurality of tables can be drawn, and the number of rows and columns contained in the tables are drawn as required.
Constructing a unique code of a table (sheet) and a unique code of rows and columns of the table, numbering the drawn table and each row and each column in each table, and specifically, numbering the tables as table 1, table 2 and the like, or table A, table B and the like; each row in the table is numbered as row 1, row 2, and so on, and each column in the table is numbered as column I, column II, and so on, so that each cell has a unique code.
Corresponding information, which can be data or text, is input into each cell in the model. This step may be performed when the table is drawn, or after the table is encoded.
And storing the coded table into a database, converting the table into JSON character strings by using a toJson method, and storing the JSON character strings into an unstructured database.
And step two, constructing measuring and calculating logic of the model.
Reading the JSON character string stored in the first step from a database, and drawing the constructed model format to a browser interface through a script; analyzing the JSON character string, and using the unique code of the cell as an operation formula required by cell binding, wherein the operation formula is a common operation formula in EXCEL, and can be specifically an addition or subtraction of a plurality of cells; and triggering the operation of the cells according to the relation between the bound operation formula and the cells, and filling the calculation result into the cells, wherein the operation between the cells can be triggered by using a resumecceservice method.
And step three, setting target variables and influence factors.
And constructing a sensitivity analysis database, wherein the sensitivity analysis database comprises two indexes, namely a target variable index and an influence factor index. The target variable can be set first, and then the influence factor associated with the target variable is set; the impact factor may also be set first, followed by the target variable associated therewith.
Specifically, in one embodiment, the target variable is set prior to setting the impact factor associated therewith. When a target variable is newly added, a cell with an operation formula in the model is selected as the target variable, and after the selection is completed, the codes of the table where the selected cell is located, the codes of the rows and columns where the cell is located and the values in the cell can be obtained from the database. The obtained data information is stored in the first table, the data information includes at least one of the code of the table in which the selected cell is located, the code of the row and column in which the cell is located, and/or the value of the selected cell and the boundary value of the target variable, and the table may be named as targetTable. When a plurality of target variables need to be set, a plurality of cells can be selected for setting for many times.
When the influence factor is newly added, the operation cell appearing in the operation formula of the set target variable is selected as the influence factor, and after the selection is completed, the code of the table where the selected cell is located, the code of the row and the column where the cell is located and the value in the cell can be obtained from the database. And storing the acquired data information into a second table, wherein the data information comprises at least one of the code of the table in which the selected cell is located, the code of the row and the column in which the cell is located, and/or the value of the selected cell and the boundary value of the influence factor, and the table can be named as factoratable. Multiple cells can be selected for multiple times, and multiple influence factors can be set. And storing the data in the first table and the second table into a database.
In another embodiment, the impact factor is set prior to setting the target variable associated therewith. When an influence factor is newly added, according to the requirement of a client, an index associated with a target variable is selected as the influence factor, the code of the table where the influence factor is located, the code of the row and the column where the influence factor is located and the value of the cell where the influence factor is located are obtained, the obtained data information is stored in a second table, and the second table can be named as factorTable.
When a target variable is newly added, traversing all cells with an operation formula in the model, acquiring the cells containing the selected influence factor data in the operation formula as the target variable, and after the selection is completed, acquiring the codes of the table where the selected cells are located, the codes of the rows and columns where the cells are located and the values in the cells from the database. The obtained data information is stored in a first table, which may be named targetTable. And storing the data in the first table and the second table into a database.
And constructing a table file in the model in the manner, and storing the information of the target variable and the associated influence factor into the table file.
S120: in response to a selection event, the impact factor associated with the selected target variable is highlighted, or the target variable associated with the selected impact factor is highlighted, based on the operational formula.
Obtaining cell information where the selected target variable or influence factor is located, wherein the information comprises: and the line and column codes of the cells of the target variables or the influence factors and the operation formulas contained in the cells highlight the influence factors related to the selected target variables or highlight the target variables related to the selected influence factors according to the operation formulas.
Specifically, in an embodiment, after a user clicks a target variable in a table file, the electronic device obtains cell information where the selected target variable is located in a database, where the cell information includes a code of a table where the cell is located, codes of rows and columns where the cell is located, and an operation formula bound to the cell. The method comprises the steps of obtaining information of operation cells contained in an operation formula, locating the cell where an influence factor is located based on the information of the operation cells contained in the operation formula, and highlighting the cell where the influence factor is located.
In another embodiment, the user clicks an influence factor in the table file, and the electronic device obtains the cell information where the selected influence factor is located in the database, where the cell information includes the code of the table where the cell is located, and the code of the row and column where the cell is located. And acquiring an operation formula containing the cell information of the selected influence factor in the model, and highlighting the cell corresponding to the operation formula. The cell corresponding to the operation formula is the cell of the target variable corresponding to the selected influence factor.
In the actual application process, if a client determines a target variable and needs to obtain all the influence factors associated with the target variable in the model, the target variable is clicked, the electronic device obtains cell information of the target variable in the database, and the influence factors associated with the selected target variable are highlighted based on an operation formula bound to the cells.
If the client determines a target variable, only a part of the influence factors associated with the target variable in the model need to be obtained. A first array may be declared first that is used to load information for all impact factors associated with the target variable in the model. The information includes the coding of the table in which each impact factor resides, and the coding of the rows and columns in which each impact factor resides.
The specific steps of acquiring the information of all the influence factors associated with the target variable are as follows: acquiring each table in the model and codes of rows and columns in each table; acquiring an operation formula of a cell where a target variable is located; and performing recursive traversal on the operation formula of the cell where the target variable is located through each table in the model and the coding of the row and the column in each table, and recording the information of the operation cell appearing in the operation formula into the first array. And declaring a second array, and loading the influence factors required by the customers from the database into the second array. And traversing all the influence factors in the first array to compare with the second array, and if the first array and the second array appear at the same time, highlighting and displaying in the table file.
By using the method, users who are not familiar with the operation relation between the target variable and the influence factor can quickly find out other indexes related to the determined index with the assistance of the system. For example, after the user determines the target variable or the influence factor, the associated influence factor or the target variable may be acquired by a simple operation.
Referring to fig. 2, fig. 2 is a flowchart illustrating a method for displaying a target variable and an influence factor according to a second embodiment of the present application. In this embodiment, the display method includes:
s210: receiving a selection event of the target variable or the influence factor through a table file; a plurality of target variables and a plurality of influence factors are stored in a table file, the target variables are stored in cells of the table file in the form of an operation formula, the influence factors are also stored in the cells of the table file, and the cells of the influence factors are used as operation cells of the operation formula.
S220: determining the row and column information of the cells of the relevant influence factors in the operational formula of the selected target variable to highlight the cells of the relevant influence factors; or determining the target variable corresponding to the operation formula with the selected influence factor and the cell row and column information of the target variable to highlight the corresponding target variable.
Step S210 has already been described in detail in the previous embodiment, and is not described herein again.
After receiving the selection event of the target variable or the influence factor in step S210, the electronic device automatically obtains the cell information where the selected target variable or the influence factor is located, where the cell information includes the row and column codes of the cells and the operation formulas for binding the cells. Acquiring the row and column information of the cells of the related influence factors in the operational formula of the selected target variable based on the operational cell information contained in the operational formula, and highlighting the cells of the related influence factors; or acquiring an operation formula containing the row and column codes of the cells in which the influence factors are located in the model and row and column information corresponding to the operation formula according to the row and column codes of the cells in which the influence factors are located, and highlighting the cells corresponding to the operation formula. The cell corresponding to the operation formula is the cell of the target variable corresponding to the selected influence factor.
Specifically, in an embodiment, after a user selects a target variable, the electronic device automatically obtains information of a cell where the target variable is located, where the information includes: the code of the cell where the target variable is located and the operation formula bound by the cell. And automatically positioning the operation cell according to the operation cell information contained in the operation formula, acquiring the row and column information of the operation cell, and positioning and highlighting the operation cell.
In another embodiment, after the user selects an influence factor, all the operation formulas in the model are traversed, the cell of the operation formula with the selected influence factor is obtained, the row and column information of the cell is obtained, and the cell is highlighted.
Referring to fig. 3, fig. 3 is a flowchart illustrating a third embodiment of a method for displaying a target variable and an influence factor according to the present application. The display method further comprises:
s310: and generating a display chart of the target variable according to the boundary value of the target variable.
The boundary values of the target variables are stored in a table file in the model, and the step of constructing the table file is already described in the first embodiment, and is not described herein again. The boundary value of the target variable can be set when the target variable is set, specifically, a cell having an operation formula in the model is selected as the target variable, and after the selection is completed, the code of the table where the selected cell is located, the code of the row and column where the cell is located, and the value in the cell can be obtained from the database. Setting the boundary value of the target variable according to the value of the cell, setting the maximum boundary value of the target variable to be 2 times of the value of the cell, and setting the minimum boundary value of the target variable to be the value of the cell minus the maximum value of the target variable. And selecting a partial value as a node value between the minimum boundary value and the maximum boundary value. And generating a display chart of the target variable according to the maximum boundary value and the minimum boundary value of the target variable, wherein the maximum value and the minimum value of the display chart are the maximum boundary value and the minimum boundary value of the target variable. The display chart can be a dashboard or a rectangular frame. In one embodiment, the display chart is a dashboard, the edge of the dashboard has boundary values of the target variable and node values, the node values and the boundary values divide the dashboard into several regions, and different regions display different colors. Two pointers are arranged at the center of the instrument panel, and the pointers point to the edge of the instrument panel. The first pointer is an original value of the target variable, and the second pointer is a value of the corresponding target variable after the influence factor is changed. Initially, the first pointer and the second pointer are overlapped to point to the original value of the cell where the target variable is located.
S320: and generating an adjusting element of the influence factor according to the boundary value of the influence factor.
The boundary values of the influencing factors are likewise stored in a table file in the model. The boundary value of the influence factor may be set when the influence factor is set, specifically, an operation cell appearing in the operation formula of the set target variable is selected as the influence factor, and after the selection is completed, the code of the table where the selected cell is located, the code of the row and column where the cell is located, and the value in the cell may be obtained from the database. Setting a boundary value of the impact factor according to the cell value, setting a maximum boundary value of the impact factor to be 2 times of the value of the cell, and setting a minimum boundary value of the impact factor to be a difference between the value of the cell and the maximum boundary value of the impact factor; the maximum and minimum boundary values of the influencing factor can also be adjusted manually as required.
The maximum and minimum values of the influence factor are set as the maximum and minimum values of the adjustment element of the influence factor. In one embodiment, the adjustment element may be configured as a slider, and the maximum value and the minimum value of the slider are the maximum value and the minimum value of the influence factor.
S330: and receiving an adjusting event of the influence factor through the adjusting original.
Specifically, the value of the adjustment original is changed, and the changed value is written into the cell of the influence factor corresponding to the adjustment original. And if a numerical value already exists in the cell of the influence factor, updating the numerical value into the value after the adjustment original is changed. And when the original is adjusted to be the sliding bar, changing the numerical value of the sliding bar to trigger a change event of the sliding bar, and writing the adjusted value of the sliding bar into the cell of the influence factor corresponding to the sliding bar.
S340: in response to an adjustment event, the value of the target variable associated with the impact factor changes in the corresponding display chart.
And writing the changed value into the cell of the influence factor corresponding to the adjustment original, triggering the operation engine of the control, and automatically recalculating the operation formula related to the cell by the operation engine. Because the target variable and the influence factor have corresponding operational relationship, when the value of the influence factor changes, the value of the cell where the corresponding target variable is located also changes. Acquiring the value of the changed target variable and the original value of the target variable, if the target variable is changed after the influence factor is changed, updating the display chart and calculating the difference value between the value of the changed target variable and the original value of the target variable; and if the value of the target variable is not changed after the value of the influence factor is changed, the display chart is not updated.
Referring to fig. 4, fig. 4 is a schematic flow chart diagram illustrating a fourth embodiment of a method for displaying target variables and impact factors according to the present application, the method further comprising:
s410: and generating a display chart of the target variable according to the boundary value of the target variable.
The maximum boundary value of the target variable is 2 times of the value of the cell in which the selected target variable is located, and the minimum boundary value of the target variable is obtained by subtracting the maximum value of the target variable from the value of the cell in which the selected target variable is located. And generating a display chart of the target variable according to the maximum boundary value and the minimum boundary value of the target variable, wherein the maximum value and the minimum value of the display chart are the maximum boundary value and the minimum boundary value of the target variable.
S420: and marking a first area in the display chart according to the first node value, and marking a second area in the display chart according to the second node value.
Specifically, when the maximum value and the minimum value of the target variable are set, a node value may be set according to a client requirement, and the node value is located between the maximum value and the minimum value of the target variable. In one embodiment, a first node value and a second node value are set between the maximum value and the minimum value of the target variable, and the first node value and the second node value are also stored in a table file of the model. An area formed by the first node value and the second node value is denoted as a first area, an area formed by the first node value and the minimum value of the target variable and an area formed by the second node value and the maximum value of the target variable are denoted as a second area, and the two areas can be distinguished by using different colors, for example, the first area is displayed in red, and the second area is displayed in green.
If the pointer of the graph is located in the first area to indicate that the target variable is located in the reasonable range, and the pointer of the graph is located in the second area to indicate that the target variable exceeds the reasonable range, a user can judge whether the change of the target variable exceeds the reasonable range more intuitively when using the graph.
It is understood that in other embodiments, the number of node values may be set according to the user's needs, and is not limited herein.
S430: and generating an adjusting element of the influence factor according to the boundary value of the influence factor.
S440: and receiving an adjusting event of the influence factor through the adjusting original.
S450: in response to an adjustment event, the value of the target variable associated with the impact factor changes in the corresponding display chart.
Steps S430 to S450 are already described in the third embodiment, and please refer to the third embodiment for details, which are not described herein.
Referring to fig. 5, fig. 5 is a flowchart illustrating a fifth embodiment of a method for displaying a target variable and an influence factor according to the present application. The display method may further include:
s510: and generating a display chart of the target variable according to the boundary value of the target variable.
S520: and generating an adjusting element of the influence factor according to the boundary value of the influence factor.
S530: and receiving an adjusting event of the influence factor through the adjusting original.
S540: in response to the adjustment event, the target variable associated with the impact factor is determined to be a changed value according to the operational formula to change in the corresponding display chart.
Steps S510 to S530 are already described in detail in the third embodiment, and are not described herein again.
After the value of the influence factor changes, the equipment can firstly acquire cell information where the influence factor is located, acquire an operation formula containing the cell information in the model based on the cell information, and position the operation formula to a cell corresponding to the operation formula; and triggering the operation engine of the control, automatically recalculating the operation formula related to the influence factor by the operation engine, and writing the calculation result into the cell corresponding to the operation formula. The cell corresponding to the operation formula is the cell where the target variable corresponding to the changed influence factor is located. If the cell corresponding to the operation formula already has a numerical value, the numerical value is updated. And updating the display chart according to the updated value of the target variable. When the display chart is an instrument panel, the first pointer is an original value of the target variable, the second pointer is a value of the corresponding target variable after the influence factor is changed, the position of the second pointer in the instrument panel is updated according to the updated value of the target variable, the difference between the original value of the target variable and the updated value of the target variable is calculated, the influence degree of the influence factor on the target variable can be judged according to the difference between the two values, the influence degree of the influence factor on the target variable can also be judged through an angle formed by the first pointer and the second pointer in the instrument panel, and the larger the angle is, the larger the influence degree of the influence factor on the target variable is.
The value of the adjusting original can be changed for many times, the value changed by the adjusting original each time is written into the cell of the influence factor corresponding to the adjusting original, if a numerical value exists in the cell of the influence factor, the numerical value is updated to the value changed by the adjusting original for the last time, the value of the corresponding target variable at the moment is recorded, and the display chart of the target variable is updated according to the value.
Referring to fig. 6, fig. 6 is a schematic diagram of a frame structure of an electronic device according to the present application.
The electronic device 60 comprises a memory 61 and a processor 62 coupled to each other, the memory 61 storing program instructions, and the processor 62 being configured to execute the program instructions stored in the memory 61 to implement the steps of any of the above-described method embodiments. In one particular implementation scenario, electronic device 60 may include, but is not limited to: a microcomputer, a server, and in addition, the electronic device 60 may also include a mobile device such as a notebook computer, a tablet computer, and the like, which is not limited herein.
Specifically, the processor 62 is configured to control itself and the memory 61 to implement the steps of any one of the above-mentioned display method embodiments of the target variable and the impact factor. The processor 62 may also be referred to as a CPU (Central Processing Unit). The processor 62 may be an integrated circuit chip having signal processing capabilities. The Processor 62 may also be a general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. In addition, the processor 62 may be collectively implemented by an integrated circuit chip.
Referring to fig. 7, fig. 7 is a block diagram of a computer storage medium according to an embodiment of the present invention.
The computer readable storage medium 70 stores program instructions 71, and the program instructions 71, when executed by the processor, are configured to implement the steps of any of the above-described method embodiments.
The computer-readable storage medium 70 may be a medium that can store a computer program, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, or may be a server that stores the computer program and can send the stored computer program to another device for running or can run the stored computer program by itself.
In the several embodiments provided in the present application, it should be understood that the disclosed method and apparatus may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of modules or units is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some interfaces, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, a network device, or the like) or a processor (processor) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above description is only for the purpose of illustrating embodiments of the present application and is not intended to limit the scope of the present application, and all modifications of equivalent structures and equivalent processes, which are made by the contents of the specification and the drawings of the present application or are directly or indirectly applied to other related technical fields, are also included in the scope of the present application.
Claims (10)
1. A display method of a target variable and an influence factor is characterized by comprising the following steps:
receiving a selection event of the target variable or the influence factor through a table file; a plurality of target variables and a plurality of influence factors are stored in the table file, the target variables are stored in cells of the table file in the form of an operation formula, the influence factors are also stored in the cells of the table file, and the cells of the influence factors are used as operation cells of the operation formula;
in response to the selection event, highlighting the impact factor associated with the selected target variable or highlighting the target variable associated with the selected impact factor based on an operational formula.
2. The display method according to claim 1, wherein the highlighting of the influence factor associated with the selected target variable or the highlighting of the target variable associated with the selected influence factor based on an operation formula in response to the selection event comprises:
determining the row and column information of the cells of the relevant influence factors in the operational formula of the selected target variable to highlight the cells of the relevant influence factors;
or determining the target variable corresponding to the operation formula with the selected influence factor and the cell row and column information of the target variable to highlight the cell of the corresponding target variable.
3. The display method according to claim 1, wherein a boundary value of each of the objective variables and a boundary value of each of the influence factors are stored in the table file.
4. The display method according to claim 3, further comprising:
generating a display chart of the target variable according to the boundary value of the target variable;
generating an adjusting element of the influence factor according to the boundary value of the influence factor;
receiving, by the adjustment element, an adjustment event for the impact factor;
in response to the adjustment event, the value of the target variable associated with the impact factor changes in the corresponding display chart.
5. The display method according to claim 4, wherein a first node value and a second node value of a target variable are saved in the table file; the display method further comprises the following steps:
marking a first region in the display graph according to the first node value, and marking a second region in the display graph according to the second node value.
6. The display method according to claim 5, wherein the first region and the second region are different in color.
7. The display method according to claim 4, wherein the changing of the value of the target variable related to the influence factor in the corresponding display chart in response to the adjustment event comprises:
the target variable associated with the impact factor determines a changed value according to an operational formula to change in the corresponding display chart.
8. The display method according to claim 4, wherein the display chart is a dashboard, and the adjustment member is a slide bar.
9. An electronic device, characterized in that the device comprises a memory and a processor, which are connected to each other, wherein,
the memory is to store program instructions;
the processor is used for executing the program instructions to realize the display method of the target variable and the influence factor according to any one of claims 1 to 8.
10. A computer storage medium for storing program instructions executable to implement a method of displaying a target variable and an impact factor according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111172936.9A CN114089934A (en) | 2021-10-08 | 2021-10-08 | Target variable and influence factor display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111172936.9A CN114089934A (en) | 2021-10-08 | 2021-10-08 | Target variable and influence factor display method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114089934A true CN114089934A (en) | 2022-02-25 |
Family
ID=80296542
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111172936.9A Pending CN114089934A (en) | 2021-10-08 | 2021-10-08 | Target variable and influence factor display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114089934A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140372854A1 (en) * | 2013-06-14 | 2014-12-18 | Microsoft Corporation | Smart Selection Engine |
| US20150261736A1 (en) * | 2014-03-14 | 2015-09-17 | Microsoft Corporation | Enhanced Indicators for Identifying Affected Data |
| CN110020277A (en) * | 2017-08-28 | 2019-07-16 | 远光软件股份有限公司 | The method for being associated with tree query index incidence relation and numerical value reason of changes by index |
| CN112395532A (en) * | 2020-11-18 | 2021-02-23 | 平安普惠企业管理有限公司 | Webpage table display method and device, computer equipment and storage medium |
| WO2021079966A1 (en) * | 2019-10-24 | 2021-04-29 | 日本電気株式会社 | Analysis device, control method, and program |
-
2021
- 2021-10-08 CN CN202111172936.9A patent/CN114089934A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140372854A1 (en) * | 2013-06-14 | 2014-12-18 | Microsoft Corporation | Smart Selection Engine |
| US20150261736A1 (en) * | 2014-03-14 | 2015-09-17 | Microsoft Corporation | Enhanced Indicators for Identifying Affected Data |
| CN110020277A (en) * | 2017-08-28 | 2019-07-16 | 远光软件股份有限公司 | The method for being associated with tree query index incidence relation and numerical value reason of changes by index |
| WO2021079966A1 (en) * | 2019-10-24 | 2021-04-29 | 日本電気株式会社 | Analysis device, control method, and program |
| CN112395532A (en) * | 2020-11-18 | 2021-02-23 | 平安普惠企业管理有限公司 | Webpage table display method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200117675A1 (en) | Obtaining of Recommendation Information | |
| CN108363602B (en) | Intelligent UI (user interface) layout method and device, terminal equipment and storage medium | |
| US10990511B2 (en) | Apparatus and application interface traversing method | |
| CN107766309B (en) | Data table generation method and device, storage medium and electronic device | |
| CN109508420B (en) | Method and device for cleaning attributes of knowledge graph | |
| US20080189639A1 (en) | Dynamically detecting exceptions based on data changes | |
| CN111027294A (en) | Table summarizing method, device and system | |
| CN107797963B (en) | Expression processing method and device and terminal | |
| CN116823409B (en) | Intelligent screening method and system based on target search data | |
| CN110968813A (en) | Index page display method and device | |
| CN111782953A (en) | Recommendation method, device, equipment and storage medium | |
| CN114579912A (en) | Page layout method, device, equipment and medium | |
| CN110806866A (en) | Generation method and device of front-end management system | |
| CN110889737A (en) | Method and device for recommending rental roommates, server and storage medium | |
| CN112784529B (en) | Mobile terminal sorting table based on BetterScroll and construction method thereof | |
| CN114089934A (en) | Target variable and influence factor display method and device | |
| CN105824606B (en) | Rolling input method and terminal | |
| JP2011095946A (en) | Prediction error-evaluating device, prediction error-evaluating method, and prediction error-evaluating program | |
| CN111881049A (en) | Acceptance method and device for application program interface and electronic equipment | |
| CN108664550B (en) | Funnel analysis method and device for user behavior data | |
| CN109358919A (en) | Dynamic Configuration, device, computer equipment and the storage medium of Universal page | |
| CN112784552A (en) | Table editing method and device | |
| CN114692581A (en) | Electronic form sub-table display method, device, equipment and storage medium | |
| CN110110280A (en) | To curve integral, device, equipment and the storage medium of coordinate | |
| CN116629980B (en) | Pricing method of software engineering, terminal equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |