CN113420538B - Numerical value format intelligent display method, equipment terminal and computer readable storage medium - Google Patents
Numerical value format intelligent display method, equipment terminal and computer readable storage medium Download PDFInfo
- Publication number
- CN113420538B CN113420538B CN202110964538.4A CN202110964538A CN113420538B CN 113420538 B CN113420538 B CN 113420538B CN 202110964538 A CN202110964538 A CN 202110964538A CN 113420538 B CN113420538 B CN 113420538B
- Authority
- CN
- China
- Prior art keywords
- type
- value
- field
- numerical value
- format
- 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.)
- Active
Links
Images
Classifications
-
- 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/20—Natural language analysis
- G06F40/279—Recognition of textual entities
- G06F40/284—Lexical analysis, e.g. tokenisation or collocates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/16—Real estate
Abstract
The invention discloses a numerical value format intelligent display method, a device terminal and a computer readable storage medium, wherein the numerical value format intelligent display method comprises the following steps: in the field of real estate BI, a BI system can intelligently identify whether the numerical value of a field has a corresponding fixed format or not by building a classifier of the special field in a report, so that the numerical value is displayed by using the corresponding fixed format; for values without fixed format, the BI system uses an adaptive format scheme to maintain a suitable reference number for the digits displayed in the report for the values without fixed format. The requirement of personalized display of special field values in the industry is met, and the use experience of different users in looking up the report is improved.
Description
Technical Field
The invention relates to the field of BI reports, in particular to a numerical format intelligent display method, a device terminal and a computer readable storage medium.
Background
In the field of real estate BI (Business Intelligence), a large amount of data in marketing, design, engineering, cost, operation and other systems of a house enterprise needs to be made into reports by using a BI tool for displaying, and the data often has the following characteristics: in the same report, the data presents the authority hierarchical characteristics. If the sales report is formed, the data seen by the group leader is the data of all the areas of the group, the data seen by the area company leader is the data of the area to which the data belongs, and the data seen by the first-line sales manager is the data of a plurality of floors in charge; some data have a relatively fixed format and some data have a non-fixed format. Based on the characteristics of the data, the quantity of the numbers is large or small when the numerical value of partial data is displayed in the existing report display mode, so that the looking up experience of a user is influenced.
Disclosure of Invention
The invention mainly aims to provide a numerical format intelligent display method to solve the problem that viewing experience of a user is influenced due to large or small numbers when numerical values of partial data are displayed in the existing report display mode.
In order to achieve the above object, the present invention provides an intelligent display method for numerical formats, comprising:
obtaining chart data of a database, wherein the chart data comprises: a chart value and an attribute field of the chart value;
judging whether the attribute field of the chart numerical value belongs to a preset field type or not;
if the attribute field belongs to a preset field type, displaying the chart numerical value in a BI report in a preset field format;
and if the attribute field does not belong to the preset field type, displaying in a BI report in a self-adaptive display format according to the absolute value of the chart numerical value.
Further, the determining whether the attribute field of the graph value belongs to a preset field type includes:
determining an attribute field of the chart numerical value in the chart, and judging whether the attribute field is consistent with the meaning of a preset field;
if the meanings are consistent, the attribute field of the chart numerical value belongs to a preset field type and is a first type numerical value;
and if the meanings are not consistent, the attribute field of the chart numerical value does not belong to the preset field type and is the second type numerical value.
Further, the determining whether the attribute field is consistent with a preset field meaning includes:
comparing the attribute field with a preset field table, and judging whether the attribute field exists in the preset field table;
if the attribute field exists in the preset field table, the meanings are consistent;
and if the attribute field does not exist in the preset field table, calculating whether the attribute field is consistent with the meaning of the preset field by using an SVM algorithm.
Further, the calculating, by using the SVM algorithm, whether the attribute field is consistent with the meaning of the preset field includes:
calculating whether the attribute field can be classified into one type with any preset field by using a binary classifier constructed for each type of preset field by using an SVM algorithm;
if they can be classified into one category, the meanings are consistent;
if they can not be classified as a group, the meanings are not consistent.
Further, the displaying the chart value in the BI report in the format of the preset field includes:
and displaying the first type value in the BI report according to the unit and the effective digit of the preset field type to which the first type value belongs.
Further, the displaying in the BI report in the adaptive display format according to the absolute value of the chart value includes:
adaptively determining the unit of the second type numerical value according to the absolute value of the second type numerical value;
adjusting the position of a decimal point of the second type numerical value according to the unit of the second type numerical value to obtain an adjusted second type numerical value;
and displaying the adjusted second type numerical value in a BI report according to a preset effective digit.
Further, the displaying the adjusted second type value in the BI report according to the preset significance includes:
obtaining the integer number of the adjusted second type numerical value according to the adjusted second type numerical value;
if the user does not define the significant digit by self, using a preset significant digit;
if the user defines the effective digit, the user-defined effective digit is used;
subtracting the result of the integer digits from the significant digits to obtain decimal digits;
if the decimal digit obtained by calculation is less than zero, the decimal digit takes zero;
if the decimal place obtained by calculation is greater than or equal to zero, the decimal place is unchanged;
and displaying the adjusted second type numerical value in a BI report according to the integer number and the decimal number.
Further, the adaptively determining the unit of the second type of value according to the absolute value of the second type of value includes:
if the absolute value of the second type of numerical value is less than 10000, the unit of the second type of numerical value is one;
if the absolute value of the second type of value is greater than or equal to 10000 and less than 100000000, the unit of the second type of value is ten thousand;
the units of the second type of value are in billion if the absolute value of the second type of value is greater than or equal to 100000000 and less than 1000000000000;
the second type of value has units of trillions if the absolute value of the second type of value is greater than or equal to 1000000000000.
In addition, to achieve the above object, the present invention also provides an apparatus terminal, including: the intelligent display method comprises a memory, a processor and a numerical format intelligent display program which is stored on the memory and can run on the processor, wherein when the numerical format intelligent display program is executed by the processor, the steps of the intelligent display method are realized.
In addition, to achieve the above object, the present invention further provides a readable storage medium, in which a numerical format intelligent display program is stored, and the numerical format intelligent display program, when executed by a processor, implements the steps of the numerical format intelligent display method described above.
The invention provides an intelligent display method of numerical formats, in the field of real estate BI, a BI system can intelligently identify whether the numerical value of a field has a corresponding fixed format or not by building a binary classifier of a special field in a report, so that the numerical value is displayed by using the corresponding fixed format; for values without a fixed format, the BI system uses an adaptive format scheme to maintain a suitable number of references to the digits displayed in the report for the value without a fixed format. The method meets the individual display requirement of special field values in the industry, and also improves the use experience of different users when looking up the report.
Drawings
Fig. 1 is a schematic diagram of a device terminal structure of a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a method for intelligently displaying numerical formats according to a first embodiment of the present invention;
FIG. 3 is a flowchart illustrating a detailed process of step S20 in the first embodiment of the intelligent value format display method according to the present invention;
FIG. 4 is a flowchart illustrating a detailed process of step S30 in the first embodiment of the intelligent value format display method according to the present invention;
fig. 5 is a flowchart illustrating a detailed process of step S40 in the first embodiment of the intelligent value format display method according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be described in detail below. It is to be understood that the described embodiments are merely exemplary of the invention, and that not all embodiments are intended to be exhaustive. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present invention without making innovative efforts, are within the scope of the present invention.
The technical solution of the present invention is further described in detail by the accompanying drawings and examples.
As shown in fig. 1, fig. 1 is a schematic structural diagram of a device terminal in a hardware operating environment according to an embodiment of the present invention.
The terminal of the embodiment of the invention can be a PC, and can also be a mobile terminal device with a display function, such as a smart phone, a tablet computer, an electronic book reader or a portable computer.
As shown in fig. 1, the terminal may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, a communication bus 1002. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Optionally, the terminal may further include a camera, a Radio Frequency (RF) circuit, a sensor, an audio circuit, a WiFi module, and the like. Such as light sensors, motion sensors, and other sensors. Specifically, the light sensor may include an ambient light sensor that may adjust the brightness of the display screen according to the brightness of ambient light, and a proximity sensor that may turn off the display screen and/or the backlight when the mobile terminal is moved to the ear. As one of the motion sensors, the gravity acceleration sensor can detect the magnitude of acceleration in each direction (generally, three axes), detect the magnitude and direction of gravity when the mobile terminal is stationary, and can be used for applications (such as horizontal and vertical screen switching, related games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer and tapping) and the like for recognizing the attitude of the mobile terminal; of course, the mobile terminal may also be configured with other sensors such as a gyroscope, a barometer, a hygrometer, a thermometer, and an infrared sensor, which are not described herein again.
Those skilled in the art will appreciate that the terminal structure shown in fig. 1 is not intended to be limiting and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and a numerical format smart display program.
In the terminal shown in fig. 1, the network interface 1004 is mainly used for connecting to a backend server and performing data communication with the backend server; the user interface 1003 is mainly used for connecting a client (user side) and performing data communication with the client; and the processor 1001 may be configured to call the intelligent display program in numerical format stored in the memory 1005, and perform the following operations:
obtaining chart data of a database, wherein the chart data comprises: a chart value and an attribute field of the chart value;
judging whether the attribute field of the chart numerical value belongs to a preset field type or not;
if the attribute field belongs to a preset field type, displaying the chart numerical value in a BI report in a preset field format;
and if the attribute field does not belong to the preset field type, displaying in a BI report in a self-adaptive display format according to the absolute value of the chart numerical value.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the judging whether the attribute field of the chart numerical value belongs to a preset field type comprises the following steps:
determining an attribute field of the chart numerical value in the chart, and judging whether the attribute field is consistent with the meaning of a preset field;
if the meanings are consistent, the attribute field of the chart numerical value belongs to a preset field type and is a first type numerical value;
and if the meanings are not consistent, the attribute field of the chart numerical value does not belong to the preset field type and is the second type numerical value.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the judging whether the attribute field is consistent with the preset field meaning comprises the following steps:
comparing the attribute field with a preset field table, and judging whether the attribute field exists in the preset field table;
if the attribute field exists in the preset field table, the meanings are consistent;
and if the attribute field does not exist in the preset field table, calculating whether the attribute field is consistent with the meaning of the preset field by using an SVM algorithm.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the calculating whether the attribute field is consistent with the preset field meaning by using the SVM algorithm comprises the following steps:
calculating whether the attribute field can be classified into one type with any preset field by using a binary classifier constructed for each type of preset field by using an SVM algorithm;
if they can be classified into one category, the meanings are consistent;
if they can not be classified as a group, the meanings are not consistent.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the displaying the chart value in a BI report form in a format of a preset field comprises:
and displaying the first type value in the BI report according to the unit and the effective digit of the preset field type to which the first type value belongs.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the displaying in the BI report in the adaptive display format according to the absolute value of the chart value includes:
adaptively determining the unit of the second type numerical value according to the absolute value of the second type numerical value;
adjusting the position of a decimal point of the second type numerical value according to the unit of the second type numerical value to obtain an adjusted second type numerical value;
and displaying the adjusted second type numerical value in a BI report according to a preset effective digit.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the displaying the adjusted second type value in a BI report according to a preset effective digit comprises:
obtaining the integer number of the adjusted second type numerical value according to the adjusted second type numerical value;
if the user does not define the significant digit by self, using a preset significant digit;
if the user defines the effective digit, the user-defined effective digit is used;
subtracting the result of the integer digits from the significant digits to obtain decimal digits;
if the decimal digit obtained by calculation is less than zero, the decimal digit takes zero;
if the decimal place obtained by calculation is greater than or equal to zero, the decimal place is unchanged;
and displaying the adjusted second type numerical value in a BI report according to the integer number and the decimal number.
Further, the processor 1001 may call the intelligent display program in numerical format stored in the memory 1005, and further perform the following operations:
the adaptively determining the unit of the second type of value according to the absolute value of the second type of value comprises:
if the absolute value of the second type of numerical value is less than 10000, the unit of the second type of numerical value is one;
if the absolute value of the second type of value is greater than or equal to 10000 and less than 100000000, the unit of the second type of value is ten thousand;
the units of the second type of value are in billion if the absolute value of the second type of value is greater than or equal to 100000000 and less than 1000000000000;
the second type of value has units of trillions if the absolute value of the second type of value is greater than or equal to 1000000000000.
Referring to fig. 2, a first embodiment of the present invention provides an intelligent display method for a report numerical format, where the intelligent display method for a report numerical format includes:
step S10, obtaining chart data of the database, where the chart data includes: a chart value and an attribute field of the chart value;
it is understood that the implementation subject in the present embodiment is Business Intelligence (BI), also called Business Intelligence or Business Intelligence, which refers to data analysis using modern data warehouse technology, online analysis processing technology, data mining and data presentation technology to realize Business value, and in the present embodiment, mainly relates to data presentation.
The database includes various forms such as a cloud database or a local database, and the chart data file may be CSV (Comma-Separated Values, character Separated Values, storing tabular data in a plain text form) or excel (microsoft Office excel), or the like. The BI system obtains the chart value in the chart and the field corresponding to the chart value, the field represents the meaning of the corresponding chart value, and the value display format used by different fields may be different according to the actual situation (such as 1234567 yuan). The values and fields are obtained to determine in what format the values should be displayed.
Step S20, judging whether the attribute field of the chart value belongs to a preset field type;
in different industries, industry terms are often used for communication convenience, and the industry terms appear in forms or reports in the form of fields. It is possible that the value of a portion of a field will have a fixed format for its business attribute. The preset field type is a special field with a fixed format and numerical values with industry attributes. Creating special field tables of different types in a BI system, wherein each special field has expression of different character descriptions, comparing an attribute field of an acquired graph value with the special field tables, if the attribute field has the same character expression that the graph value belongs to a preset field type, and if the attribute field does not have the same character expression, further judging whether a field consistent with the meaning of the acquired attribute field can be found in the special field tables by using an SVM (Support Vector Machine) algorithm. The BI system will identify whether the attribute field of the retrieved chart value is a fixed format field with its industry attribute to determine whether the chart value under the attribute field needs to be displayed using a fixed format.
Such as: if the graph value acquired by the BI system in the real estate field is 123456789 yuan, the corresponding attribute field is the total amount of the contract, the BI system can find the description that the total amount of the contract is the same in the existing special field table, or can find the field which has the same meaning as the total amount of the contract in the special field table after the SVM algorithm is used but the description is not found, then the BI system judges that the attribute field of the graph value belongs to the type of the preset field, and displays the value by using the fixed format corresponding to the field.
It can be understood that the judgment of whether the attribute field of the obtained chart value belongs to the preset field type is to determine whether the chart value needs to use a fixed format.
Step S30, if the attribute field belongs to the preset field type, displaying the chart value in a BI report form in a preset field format;
when the BI system determines that the field of the acquired numerical value belongs to a fixed format field type, namely a preset field type, the numerical value is defined as a first type numerical value, the fixed formats corresponding to different types of the first type numerical value may also be different, and the fixed format corresponding to the first type numerical value is used for displaying in a BI report.
Such as: the total amount of the field contract in the real estate field is determined as a first type value, and the fixed format corresponding to the first type value of the total amount type of the contract is as follows: unit and decimal place are not omitted, the first type value is in unit of unit and decimal place is not omitted when displayed in the BI report.
It can be understood that most data formats in the financial system reports in the real estate industry are displayed in a form of reserving two decimal places, and if the method is not used, the total amount of the contract is likely to have the phenomenon that a part of decimal places are omitted, so that the total amount is not displayed fully, and the accuracy of the financial data is reduced.
And step S40, if the attribute field does not belong to the preset field type, displaying in a BI report in a self-adaptive display format according to the absolute value of the chart numerical value.
When the BI system determines that the field of the acquired numerical value does not belong to the fixed format field type, namely the preset field type, the numerical value is defined as a second type numerical value, and for the second type numerical value without the fixed display format, if a user does not perform self-defining setting on the data format, the default format of the system, namely the self-adaptive display numerical value format, is used, the numerical value unit is self-adaptively converted according to the absolute value of the second numerical value, and the numerical value unit is displayed in the BI report according to the format of the preset effective number.
Such as: in the field of real estate BI, sales data are displayed in a BI report, and a BI system judges that the sales field type does not belong to a preset field type and defines the sales field type as a second type value, namely the sales data value has no fixed display format. Because of the characteristic of the hierarchical presentation of the report, the sales volume values displayed when users with different authorities see the same report are different, at the moment, the sales volume of a part of sales areas seen by the users with low authorities entering the report is 54.57 ten thousand yuan after the self-adaptive conversion of the BI system if the original data is 545667 yuan, the sales volume of all the sales areas will be displayed when the users with high authorities enter the report, and the sales volume is 11.50 hundred million yuan after the self-adaptive conversion of the BI system if the original data is 1149844032 yuan. If the digit is not displayed according to the absolute value of the numerical value in a self-adaptive manner, the experience of the user for watching the report is poorer, the same low-authority user and the high-authority user enter the same report in the above example, the report uses a unified unit of ten thousand yuan, the sale amount of the low-authority user in the report is 54.57 ten thousand yuan, and the sale amount of the high-authority user in the report is 114984.40 ten thousand yuan. At this time, for a high-authority user, the actual size of the numerical value cannot be clearly reflected at the first moment, the numerical value unit needs to be converted by the user, and the risk of error caused by looking at the numerical value less or looking more exists by converting the numerical value unit by the user.
In this embodiment, the BI system may divide the value into the first type value and the second type value according to whether the field corresponding to the obtained value has the fixed format. The first type value is displayed in a BI report in a fixed format corresponding to the first type value, and the second type value is displayed in the BI report in a mode of self-adapting to a numerical unit according to the numerical absolute value and presetting a significant digit. On one hand, the individualized format display requirement of the numerical value of the fixed format field with the industry attribute is met, and the display accuracy is ensured; on the other hand, for the numerical values without the fixed format field types, the BI system can control the display digits of the numerical values of the second type by converting numerical value units and setting effective digits according to the absolute values of the numerical values, so that the problem that the viewing experience of the report of the user is influenced by too large or too small quantity of the digits in the report of the display numerical values is avoided.
Further, referring to fig. 3, in the first embodiment of the intelligent display method for numerical format according to the present invention, step S20 includes:
step S21: determining an attribute field of the chart value in the chart;
when the BI system acquires data, the acquired data often has a field name and specific numerical values, such as: the field sales amount corresponds to a specific value of 1345885; the field refund amount corresponds to a base value of 23445605. first, the BI system will take the field sales or refund amount.
Step S22: judging whether the attribute field is consistent with the preset field meaning or not;
comparing the attribute field with a preset field table, and judging whether the attribute field exists in the preset field table; if the attribute field exists in the preset field table, the meanings are consistent; and if the attribute field does not exist in the preset field table, calculating whether the attribute field is consistent with the meaning of the preset field by using an SVM algorithm. Calculating whether the attribute field can be classified into one type with any preset field by using a binary classifier constructed for each type of preset field by using an SVM algorithm; if they can be classified into one category, the meanings are consistent; if they can not be classified as a group, the meanings are not consistent.
The preset field table is made according to fields with fixed display formats, such as: the price field represents a type of preset field in the table, namely a type of special field with the same fixed format, the commodity room selling price, the March's price and the March's price belong to the preset field of price types, and if the character description of the attribute field to which the acquired chart value belongs is consistent with any description of the commodity room selling price, the March's price and the March's price, the meaning is considered consistent. And using SVM algorithm to further judge the description inconsistency. Before data is acquired, the BI system utilizes an SVM algorithm to construct a two-classifier of each preset field, and the construction of the two-classifier is to train the two-classifier of each preset field according to actual requirements. Such as: in the real estate field, a preset field is the price, the statement display of the price in the BI system has a fixed format, but the possible text descriptions of the attribute field of the acquired chart value are the commodity room selling price, the March's price, the April's price and the certain year's price, etc., and they are all assumed to belong to the price field type, and the same fixed format is used for display, but in the above example, the commodity room selling price, the March's price and the March's price exist in the preset field table, and can judge whether they belong to the preset field, but can not find the description consistent with the certain year's price, in order to identify whether the certain year's price field is consistent with the field's price meaning, a model for the field's price is trained for the characteristics of the field's price, that is the BI system uses the field's classifier to calculate the certain year's price and the price meaning are consistent, and classifies it into one class, thereby judging that the rate of the house in a certain year belongs to the preset field type. Meanwhile, a two-classifier of the field is constructed for the preset field of each type, and the BI system calculates whether the obtained field meaning is consistent with each preset field meaning.
Step S23: if the meanings are consistent, the attribute field of the chart numerical value belongs to a preset field type and is a first type numerical value;
if the BI system calculates based on the acquired fields, if the BI system can find the preset fields with the same meanings as the preset fields or calculate the preset fields, the BI system defines the preset fields as first numerical values for distinguishing data displayed by using a default format.
Step S24: and if the meanings are not consistent, the attribute field of the chart numerical value does not belong to the preset field type and is the second type numerical value.
If the BI system calculates based on the acquired fields, the preset fields with the same meaning as the acquired fields cannot be found or calculated, the value is defined as a second value, and the second value is displayed in a BI report by using a default display format.
It can be understood that in this embodiment, the BI system utilizes the SVM algorithm to train the features having the fixed format field types, and constructs the corresponding two classifiers for the different fixed format field types, so that the BI system can intelligently identify the preset field, and thereby display the numerical value using the fixed format thereof, and meet the requirements of individuation of the report forms in different industries.
Further, referring to fig. 4, in the first embodiment of the intelligent display method for numerical format according to the present invention, step S30 includes:
step S31: determining a preset field type to which the first type value belongs;
in the above example, the BI system constructs two classifiers for each preset field, and after calculation, the BI system can identify the preset field type to which the first type value belongs.
Step S32: and displaying the first type value in the BI report according to the unit and the effective digit of the preset field type to which the first type value belongs.
Each preset field corresponds to different fixed formats, and the unit and the effective digit of the type of the preset field are determined by the industry attribute of the field. Such as: the total amount of the contract in the real estate BI report is a preset field type, and in order to ensure the accuracy of the number, the fixed format of the total amount of the contract is as follows: a single bit and not a few decimal places.
In the embodiment, the numerical value of each preset field is displayed in a corresponding fixed format, so that the requirement of a client on the personalized display of the report is met.
Further, referring to fig. 5, in the first embodiment of the intelligent display method for numerical format according to the present invention, step S40 includes:
step S41: adaptively determining the unit of the second type numerical value according to the absolute value of the second type numerical value;
for no fixed format field type, i.e. the second numerical value, the BI system is provided with an adaptive default display scheme. First, the unit of the second value is determined: if the absolute value of the second type of numerical value is less than 10000, the unit of the second type of numerical value is one; if the absolute value of the second type of value is greater than or equal to 10000 and less than 100000000, the unit of the second type of value is ten thousand; the units of the second type of value are in billion if the absolute value of the second type of value is greater than or equal to 100000000 and less than 1000000000000; the second type of value has units of trillions if the absolute value of the second type of value is greater than or equal to 1000000000000.
Compared with the current report uniformly using ten thousand units, the BI system in the embodiment determines the numerical unit according to the absolute value of the numerical value, so that the integral number of the numerical unit can be always kept in a proper viewing range, and the user can reflect the actual size of the numerical value at the first time when looking up the report.
Step S42: adjusting the position of a decimal point of the second type numerical value according to the unit of the second type numerical value to obtain an adjusted second type numerical value;
the unit of the chart value acquired by the BI system may be determined after passing through step S41. Such as: the obtained second type numerical value is 123456 yuan, and if the unit determined after the step S41 is ten thousand yuan, the decimal point is moved four bits to the left, so that the adjusted second type numerical value is 12.3456 ten thousand yuan.
The integral number of the numerical point is always kept in a proper viewing range through the adjustment of the numerical point, so that the actual size of the numerical value can be reflected at the first time when a user looks up the report.
Step S43: and displaying the adjusted second type numerical value in a BI report according to a preset effective digit.
Obtaining the integer number of the adjusted second type numerical value according to the adjusted second type numerical value; if the user does not define the significant digit by self, using a preset significant digit; if the user defines the effective digit, the user-defined effective digit is used; subtracting the result of the integer digits from the significant digits to obtain decimal digits; if the decimal digit obtained by calculation is less than zero, the decimal digit takes zero; if the decimal place obtained by calculation is greater than or equal to zero, the decimal place is unchanged; and displaying the adjusted second type numerical value in a BI report according to the integer number and the decimal number.
The integer number of bits is 2 as in the above example according to the adjusted second type value of 12.3456 ten thousand dollars. If the user does not set the significant digit when looking up the report, the BI system uses the preset significant digit 4 to display. Using the equation: the set numeric significance = the decimal place number + the numeric integer number of numeric display, knowing the significance 4 and the integer number 2, and the decimal place number of numeric display = the significand of numeric display-the numeric integer number of numeric display according to the equation numeric value, the decimal place number of numeric display can be calculated to be 2, so 12.3456 ten thousand yuan is actually displayed to be 12.34 ten thousand yuan according to the decimal place number of numeric display being 2; if the calculated decimal place is less than 0, the decimal place takes 0, if the adjusted second type numerical value is 123.456 ten thousand, the user-defined significant digit is 2 digits, the known integer digit is 3 digits, the decimal place of the numerical value display obtained after the calculation of the equation is-1 digit, the decimal place displayed at the moment takes 0 digit according to the method, and therefore the actual display is 123 ten thousand. More data types can be referred to in table 1 below.
TABLE 1
It will be appreciated that the above method of determining the actual display significand is set by computer logic. The concept of significant digits is introduced when the report is displayed, so that the data is concise and clear when a user refers to the report.
The BI system of this embodiment establishes a format adaptation scheme for the second value without a fixed format. The BI system enables the numerical value to be displayed in a report in a concise manner by converting units during numerical value display and introducing a numerical value display significant digit concept, and the accuracy of the numerical value is not influenced.
The invention also provides an equipment terminal, comprising: the intelligent display method comprises a memory, a processor and a numerical format intelligent display program which is stored on the memory and can run on the processor, wherein when the numerical format intelligent display program is executed by the processor, the steps of the intelligent display method are realized.
The invention also provides a readable storage medium, wherein the readable storage medium is stored with a numerical format intelligent display program, and the numerical format intelligent display program realizes the steps of the numerical format intelligent display method when being executed by a processor.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a computer, a mobile phone, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (7)
1. The numerical value format intelligent display method is characterized by comprising the following steps:
obtaining chart data of a database, wherein the chart data comprises: a chart value and an attribute field of the chart value;
judging whether the attribute field of the chart numerical value belongs to a preset field type or not;
determining an attribute field of the chart numerical value in the chart, and judging whether the attribute field is consistent with the meaning of a preset field;
if the meanings are consistent, the attribute field of the chart numerical value belongs to a preset field type and is a first type numerical value;
if the meanings are not consistent, the attribute field of the chart numerical value does not belong to the preset field type and is a second type numerical value;
if the attribute field belongs to a preset field type, displaying the first type value in a BI report in a format of the preset field;
if the attribute field does not belong to the preset field type, displaying in a BI report in a self-adaptive display format according to the absolute value of the second type numerical value;
wherein the displaying in the BI report in the adaptive display format according to the absolute value of the second type of value comprises:
adaptively determining the unit of the second type numerical value according to the absolute value of the second type numerical value;
adjusting the position of a decimal point of the second type numerical value according to the unit of the second type numerical value to obtain an adjusted second type numerical value;
obtaining the integer number of the adjusted second type numerical value according to the adjusted second type numerical value;
if the user does not define the significant digit by self, using a preset significant digit;
if the user defines the effective digit, the user-defined effective digit is used;
subtracting the result of the integer digits from the significant digits to obtain decimal digits;
if the decimal digit obtained by calculation is less than zero, the decimal digit takes zero;
if the decimal place obtained by calculation is greater than or equal to zero, the decimal place is unchanged;
and displaying the adjusted second type numerical value in a BI report according to the integer number and the decimal number.
2. The intelligent numerical format display method of claim 1, wherein the determining whether the attribute field is consistent with a preset field meaning comprises:
comparing the attribute field with a preset field table, and judging whether the attribute field exists in the preset field table;
if the attribute field exists in the preset field table, the meanings are consistent;
and if the attribute field does not exist in the preset field table, calculating whether the attribute field is consistent with the meaning of the preset field by using an SVM algorithm.
3. The intelligent numerical format display method of claim 2, wherein the calculating using the SVM algorithm whether the attribute field is consistent with the preset field meaning comprises:
calculating whether the attribute field can be classified into one type with any preset field by using a binary classifier constructed for each type of preset field by using an SVM algorithm;
if they can be classified into one category, the meanings are consistent;
if they can not be classified as a group, the meanings are not consistent.
4. The intelligent value format display method of claim 3, wherein the displaying the first type of value in the BI report in the format of the preset field comprises:
and displaying the first type value in the BI report according to the unit and the effective digit of the preset field type to which the first type value belongs.
5. The numerical format intelligent display method of claim 1, wherein the adaptively determining the unit of the second type of numerical value based on the absolute value of the second type of numerical value comprises:
if the absolute value of the second type of numerical value is less than 10000, the unit of the second type of numerical value is one;
if the absolute value of the second type of value is greater than or equal to 10000 and less than 100000000, the unit of the second type of value is ten thousand;
the units of the second type of value are in billion if the absolute value of the second type of value is greater than or equal to 100000000 and less than 1000000000000;
the second type of value has units of trillions if the absolute value of the second type of value is greater than or equal to 1000000000000.
6. A device terminal, characterized in that the device terminal comprises: a memory, a processor and a numerical format smart display program stored on the memory and executable on the processor, the numerical format smart display program when executed by the processor implementing the steps of the numerical format smart display method of any one of claims 1 to 5.
7. A readable storage medium, wherein a numerical format intelligent display program is stored on the readable storage medium, and when executed by a processor, the numerical format intelligent display program implements the steps of the numerical format intelligent display method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110964538.4A CN113420538B (en) | 2021-08-23 | 2021-08-23 | Numerical value format intelligent display method, equipment terminal and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110964538.4A CN113420538B (en) | 2021-08-23 | 2021-08-23 | Numerical value format intelligent display method, equipment terminal and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113420538A CN113420538A (en) | 2021-09-21 |
| CN113420538B true CN113420538B (en) | 2021-12-14 |
Family
ID=77719051
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110964538.4A Active CN113420538B (en) | 2021-08-23 | 2021-08-23 | Numerical value format intelligent display method, equipment terminal and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113420538B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508839A (en) * | 2011-09-22 | 2012-06-20 | 用友软件股份有限公司 | Data processing device and data processing method |
| CN112287638A (en) * | 2020-10-28 | 2021-01-29 | 云账户技术(天津)有限公司 | Digital display method and device |
| CN112434505A (en) * | 2020-11-24 | 2021-03-02 | 文思海辉智科科技有限公司 | Template generation method and device, computer equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4428488B2 (en) * | 1999-05-31 | 2010-03-10 | 株式会社ターボデータラボラトリー | Tabular data combination method, storage medium storing program for realizing the above method, and apparatus for combining tabular data |
-
2021
- 2021-08-23 CN CN202110964538.4A patent/CN113420538B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508839A (en) * | 2011-09-22 | 2012-06-20 | 用友软件股份有限公司 | Data processing device and data processing method |
| CN112287638A (en) * | 2020-10-28 | 2021-01-29 | 云账户技术(天津)有限公司 | Digital display method and device |
| CN112434505A (en) * | 2020-11-24 | 2021-03-02 | 文思海辉智科科技有限公司 | Template generation method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113420538A (en) | 2021-09-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109993627B (en) | Recommendation method, recommendation model training device and storage medium | |
| CN110866008B (en) | Data processing method, device and system | |
| CN111831675A (en) | Storage model training method and device, computer equipment and storage medium | |
| US11748452B2 (en) | Method for data processing by performing different non-linear combination processing | |
| CN113849848B (en) | Data permission configuration method and system | |
| US20210073871A1 (en) | Search Result-Based Listing Generation In A Single View | |
| CA2920407A1 (en) | Promoter system and method for processing product and service data | |
| US11663394B2 (en) | Systems for generating instances of variable fonts | |
| CN112529679A (en) | Construction method, device and equipment of enterprise trust model and readable storage medium | |
| CN113420538B (en) | Numerical value format intelligent display method, equipment terminal and computer readable storage medium | |
| CN107977876B (en) | Method and device for processing order information | |
| CN110392115B (en) | Block chain node management method, device and readable storage medium | |
| CN113327134B (en) | Commodity information recommendation method and device, electronic equipment and medium | |
| CN111612385A (en) | Method and device for clustering to-be-delivered articles | |
| CN115222444A (en) | Method, apparatus, device, medium and product for outputting model information | |
| CN111291555B (en) | Commodity specification identification method, commodity specification identification device and computer readable storage medium | |
| CN111831179B (en) | Signing method, device and computer readable medium | |
| CN113673916B (en) | Risk data identification method, terminal device and computer-readable storage medium | |
| CN111680628A (en) | Text box fusion method, device, equipment and storage medium | |
| CN110674994A (en) | Data value evaluation method, terminal, device and readable storage medium | |
| CN111667208A (en) | Article storage control method, device, equipment and medium | |
| KR102475123B1 (en) | Apparatus for webtoon simulation viewer | |
| CN113469374B (en) | Data prediction method, device, equipment and medium | |
| US11907508B1 (en) | Content analytics as part of content creation | |
| CN114841740A (en) | Consumer demand induction method, device and computer readable 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| EE01 | Entry into force of recordation of patent licensing contract | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20210921 Assignee: Chengdu Jingjian Technology Co.,Ltd. Assignor: Shenzhen Mingyuan Cloud Technology Co.,Ltd. Contract record no.: X2022980027716 Denomination of invention: Intelligent display method of numerical format, device terminal and computer-readable storage medium Granted publication date: 20211214 License type: Common License Record date: 20230106 Application publication date: 20210921 Assignee: Shenzhen Woxiang Technology Co.,Ltd. Assignor: Shenzhen Mingyuan Cloud Technology Co.,Ltd. Contract record no.: X2022980027715 Denomination of invention: Intelligent display method of numerical format, device terminal and computer-readable storage medium Granted publication date: 20211214 License type: Common License Record date: 20230106 |
|
| EE01 | Entry into force of recordation of patent licensing contract | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20210921 Assignee: Shenzhen Mingyuan cloud chain Internet Technology Co.,Ltd. Assignor: Shenzhen Mingyuan Cloud Technology Co.,Ltd. Contract record no.: X2023980038712 Denomination of invention: Intelligent display method for numerical format, device terminal, and computer-readable storage medium Granted publication date: 20211214 License type: Common License Record date: 20230727 |