CN110489732A - Method for processing report data and equipment - Google Patents
Method for processing report data and equipment Download PDFInfo
- Publication number
- CN110489732A CN110489732A CN201910667542.7A CN201910667542A CN110489732A CN 110489732 A CN110489732 A CN 110489732A CN 201910667542 A CN201910667542 A CN 201910667542A CN 110489732 A CN110489732 A CN 110489732A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- dimension
- identification
- graphic
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/23—Clustering techniques
Abstract
The present invention is suitable for computer application technology, provide a kind of method for processing report data, equipment and computer readable storage medium, by the Data Identification for obtaining report data and the report data to be processed, dimension division is carried out to Data Identification, obtain at least one data dimension of report data, the graphic style for obtaining being suitble to report data is matched in preset image style library according to data dimension, statistical chart is finally generated according to graphic style and report data, improve the efficiency of data sheet image conversion, the workload that the business of decreasing is given a report, reduce the probability of human error.
Description
Technical field
The invention belongs to computer application technology more particularly to a kind of method for processing report data, equipment and calculating
Machine readable storage medium storing program for executing.
Background technique
21 century is Internet information age, and all trades and professions all be unable to do without information, carrier of the report as Information Statistics, with
Simple and clear mode reflects various information, is very important a part in various information system.Report is to letter
When breath carries out statistics and analysis, data can be counted, inquired, checked and analyzed by various forms, so that user can
It is obtained for information about in a manner of intuitive, comprehensive.With the development of society, between enterprise and enterprise interactive information frequency by
Cumulative to add, people require report to can be realized multi-level multi-faceted data acquisition the raising of the general control degree of information, converge
Always, it excavates, extraction and the output of multiple format, the design for deeply also requiring report of the degree of office automation will be convenient for operation
And it safeguards simple.
In the prior art by providing the report data downloading of Excel format, business personnel needs pair after taking data
The data such as achievement, number of packages, retention ratio are analyzed, then by being associated with multiple reports come garbled data, finally manually in figure life
Statistical chart is generated at the suitable graphics template of data after selecting and screening in software, this mode is generated according to data
During statistical chart, graphic hotsopt process CIMS is cumbersome, efficiency is lower, and is easy error.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of method for processing report data, equipment and computer-readable storages
Medium, during solving in the prior art to be patterned data, graphic hotsopt process CIMS is cumbersome, efficiency is lower is asked
Topic.
The first aspect of the embodiment of the present invention provides a kind of method for processing report data, comprising:
Obtain the Data Identification of report data and the report data to be processed；
The Data Identification is clustered, obtains the data dimension of the report data, and according to the data dimension
The graphic style for being suitble to the data dimension is determined in preset graphic style library；The graphic style passes through figure for indicating
Shape shows the mode of the report data；It include graphic element in the graphic style；
The Data Identification of graphic element and the report data in the graphic style is matched one by one, determine with
The corresponding graphic element of each Data Identification, and according to the corresponding report data of each Data Identification, graphic element
Statistical chart is generated with graphic style.
The second aspect of the embodiment of the present invention provide a kind of report data processing equipment, including memory, processor with
And the computer program that can be run in the memory and on the processor is stored, the processor executes the calculating
It is performed the steps of when machine program
Obtain the Data Identification of report data and the report data to be processed；
The Data Identification is clustered, obtains the data dimension of the report data, and according to the data dimension
The graphic style for being suitble to the data dimension is determined in preset graphic style library；The graphic style passes through figure for indicating
Shape shows the mode of the report data；It include graphic element in the graphic style；
The Data Identification of graphic element and the report data in the graphic style is matched one by one, determine with
The corresponding graphic element of each Data Identification, and according to the corresponding report data of each Data Identification, graphic element
Statistical chart is generated with graphic style.
The third aspect of the embodiment of the present invention provides a kind of report data processing equipment, comprising:
Acquiring unit, for obtaining the Data Identification of report data and the report data to be processed；
Pattern unit obtains the data dimension of the report data for clustering to the Data Identification, and according to
The data dimension determines the graphic style for being suitble to the data dimension in preset graphic style library；The graphic style is used
By way of indicating the report data described in the graphical display；It include graphic element in the graphic style；
Generation unit, for the Data Identification of graphic element and the report data in the graphic style to be carried out one
One matching, determining graphic element corresponding with each Data Identification, and according to the corresponding report of each Data Identification
Data, graphic element and graphic style generate statistical chart.
The fourth aspect of the embodiment of the present invention provides a kind of computer readable storage medium, the computer storage medium
It is stored with computer program, the computer program includes program instruction, and described program instruction makes institute when being executed by a processor
State the method that processor executes above-mentioned first aspect.
Existing beneficial effect is the embodiment of the present invention compared with prior art:
The Data Identification that the embodiment of the present invention passes through acquisition report data and the report data to be processed；To described
Data Identification is clustered, and obtains the data dimension of the report data, and according to the data dimension in preset figure sample
The graphic style for being suitble to the data dimension is determined in formula library；By the graphic element and the report data in the graphic style
Data Identification matched one by one, determining graphic element corresponding with each Data Identification, and according to each number
Statistical chart is generated according to corresponding report data, graphic element and graphic style is identified.By obtain report data to be processed with
And the Data Identification and its Data Identification of the report data, dimension division is carried out to Data Identification, obtains report data extremely
A few data dimension, the figure sample for obtaining being suitble to report data is matched according to data dimension in preset image style library
Formula finally generates statistical chart according to graphic style and report data, improves the efficiency of data sheet image conversion, decrease industry
The workload that business is given a report, reduces the probability of human error.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description is only of the invention some
Embodiment for those of ordinary skill in the art without any creative labor, can also be according to these
Attached drawing obtains other attached drawings.
Fig. 1 is the flow chart for the method for processing report data that the embodiment of the present invention one provides；
Fig. 2 is the flow chart of method for processing report data provided by Embodiment 2 of the present invention；
Fig. 3 is the schematic diagram for the report data processing equipment that the embodiment of the present invention three provides；
Fig. 4 is the schematic diagram for the report data processing equipment that the embodiment of the present invention four provides.
Specific embodiment
In being described below, for illustration and not for limitation, the tool of such as particular system structure, technology etc is proposed
Body details, to understand thoroughly the embodiment of the present invention.However, it will be clear to one skilled in the art that there is no these specific
The present invention also may be implemented in the other embodiments of details.In other situations, it omits to well-known system, device, electricity
The detailed description of road and method, in case unnecessary details interferes description of the invention.
In order to illustrate technical solutions according to the invention, the following is a description of specific embodiments.
It is the flow chart for the method for processing report data that the embodiment of the present invention one provides referring to Fig. 1, Fig. 1.In the present embodiment
The executing subject of method for processing report data is report data processing equipment.Report data processing equipment includes but is not limited to intelligence
The mobile terminals such as mobile phone, tablet computer, wearable device can also be server, desktop computer etc..Report number as shown in the figure
It may comprise steps of according to processing method:
S101: the Data Identification of report data and the report data to be processed is obtained.
System, which refers to, at present provides the report data downloading of Excel format, and business is needed after taking data to achievement, part
The data such as number, retention ratio are analyzed, and multiple report garbled datas are associated with, and are then generated figure further according to data and are given a report, work
It is cumbersome to make process CIMS, is easy error.By different function Reports modules in the present embodiment, analyze and count in advance, and
It is shown on different page assemblies, makes to see corresponding figure when business login system, see various index variations at a glance,
Multiple dimensions show the rule of data variation, the timely various index changing rules of active push.
The report data processing equipment Data Identification that obtains report data and the report data to be processed first, this
Report data in embodiment, which can be, directly acquires the mode of table to obtain, and is also possible to directly obtain by burying the modes such as a little
Take the data in application system.In practical applications, report data may include number of different types, such as data generation time,
Numerical values recited, cycle duration etc., each of these report datas have its corresponding Data Identification, by the number for obtaining report data
According to mark, dimension division is carried out to report data according to Data Identification.It should be noted that in report data in the present embodiment
Each data have its corresponding Data Identification, to distinguish different types of data by Data Identification.
In practical applications, to be shown or processing report data can be obtained in real time.Specifically, if pending data
When computer system perhaps data processing system operation data then can be burying a little or by way of crawler capturing come in real time
Obtain report data.Daily report be basically largely used in routine work, format and content is compared to relatively fixed
Data analytical table.Being used primarily in personal management, sale, inventory, balance of payment position etc. in enterprise's day-to-day operation influences enterprise operation
Great data.Summary data be due to report may it is very more, project is many and diverse, in order to improve the data that report is stated
Ability improves the various resources in service efficiency saving report exploitation, it would be desirable to carry out process of refinement to data information.
Other than most basic daily report, we can also obtain analysis mode report, and analysis mode report is not only
Data exhibiting is only extracted from database to us, but after carrying out data screening according to business rule, obtains some analysis modes
Report data.These analysis mode data will be used by the business personnel of enterprise and management level personnel, and the report of analysis mode
What is accomplished is exactly accurately, accurately, timely to report data to user, this requires very the accurate and fine of data
Strictly, user has a very high requirement to the accuracy of data, some data it is inaccurate, it would be possible to lead to the mistake of decision
Accidentally.
S102: clustering the Data Identification, obtains the data dimension of the report data, and according to the data
Dimension determines the graphic style for being suitble to the data dimension in preset graphic style library；The graphic style is for indicating logical
Cross the mode of report data described in graphical display；It include graphic element in the graphic style.
Graphic style in the present embodiment may include graphics shape, graphic element etc..Illustratively, graphics shape can be with
Including but not limited to: cake chart, histogram, line chart, more Y-axis charts, bar chart, cake chart, bubble diagram, Gantt chart, scatterplot
Figure and crater blasting etc..Wherein, each type of graphic style includes different pictorial element, the graphic element in the present embodiment
It may include each data element or the data label etc. in figure, each data element or data label in figure are being reported
Data type, the i.e. the first row or first row of report are corresponded in table.Further, since different types of figure is highlighted
Emphasis it is different, such as pie chart main saliency is data accounting, and what line chart highlighted is data situation, therefore, this reality
Applying the graphic element in example can also include the data element that figure emphasis highlights, and corresponding in report is that user thinks emphasis
Highlighted data characteristic or some Data Identification.
Before the graphic style for determining report number according to report data, it is preset with graphic style library in the present embodiment, schemes
Graphic style in shape style library can be divided and be managed according to different pattern dimensions, for example, different figure samples
It may include different data dimension quantity and the corresponding display mode of each data dimension in formula, we pass through according to each
The quantity of the corresponding data dimension of graphic style determines the corresponding data dimension situation of graphic style, can also be according to each figure
The dimension of pattern shows that situation determines pattern catalogue of the graphic style in graphic style library.Due to different types of figure sample
The corresponding data of formula are different, more accurately and rapidly determine that is matched with current report data shows in the present embodiment
Show mode, when determining suitable graphic style according to report data, the data type according to included in report data is determined
The data dimension of current report data, determines suitable graphic style further according to data dimension.
S103: the Data Identification of graphic element and the report data in the graphic style is matched one by one,
Determining graphic element corresponding with each Data Identification, and according to the corresponding report data of each Data Identification, figure
Shape element and graphic style generate statistical chart.
After the graphic style for determining report number according to report data, we according in graphic style graphic element and
The Data Identification of report data is matched one by one, obtains the corresponding Data Identification of each graphic element, by each data mark
Each graphic element in the report data and graphic style of knowledge corresponds, finally according to the corresponding report of each Data Identification
Data, graphic element and graphic style generate statistical chart, and after generating statistical chart, statistical chart is sent to preset management eventually
End.
Specifically, first determining and comparing the member of graphic element when being matched one by one to graphic element and Data Identification
The mark quantity of prime number amount and Data Identification, for example, the line number or column of the fan-shaped quantity and report that divide in cake chart
Whether number is consistent.If inconsistent, the determining consistent graphic style of data dimension with report in step S102 is come back to；If
Quantity is consistent, then carries out in next step.The independent variable and dependent variable in graphic element and Data Identification are determined, for example, in line chart
In, horizontal axis is independent variable, and the longitudinal axis is dependent variable；In Data Identification, the time is independent variable, and the moon output value is dependent variable.Finally, will
Same type of variable corresponds, that is, horizontal axis of the time of independent variable in line chart, dependent variable the moon output value in line chart
In the longitudinal axis, with this process, Lai Shixian graphic element and data indicate the matching one by one of mark, to determine each Data Identification pair
The graphic element answered.
The report data that can have both been submitted by client in the present embodiment, can also pass through facing in server-side database
When data set obtain data, and then according to requiring to generate statistical chart, and statistical chart is sent to user terminal, to be shown to user.
The statistical chart of generation would generally be stored in server end with common picture format, and user can issue in client
Check the request of statistical chart, statistical chart is sent to user terminal after receiving the request with the format of binary data by server end,
In this way user can be checked in client, download statistics figure.Simultaneously as although statistical chart is passed with binary data stream
It is defeated, but client acquisition is a complete image file, so client does not need to install other plug-in units, the statistics of output
Figure image is an interim binary data stream, dynamic generation when really being requested by server response client, to protect
Demonstrate,prove the high efficiency of transmission of statistical chart image.
It should be noted that being automatic by the process for generating statistical chart in this present embodiment, therefore can be according to report
Data and multiple graphic styles generate the statistical chart of multiple and different patterns, and the statistical chart of these different patterns is sent to management
Terminal so that user can select or modify in management terminal, and then determine final data displaying scheme, improve
The hommization and visualization that data are shown.
Above scheme, by the Data Identification for obtaining report data and the report data to be processed；To the number
It is clustered according to mark, obtains the data dimension of the report data, and according to the data dimension in preset graphic style
The graphic style for being suitble to the data dimension is determined in library；By the graphic element and the report data in the graphic style
Data Identification is matched one by one, determining graphic element corresponding with each Data Identification, and according to each data
It identifies corresponding report data, graphic element and graphic style and generates statistical chart.By obtain report data to be processed and
The Data Identification and its Data Identification of the report data carry out dimension division to Data Identification, obtain report data at least
One data dimension matches the graphic style for obtaining being suitble to report data according to data dimension in preset graphic style library,
Statistical chart is finally generated according to graphic style and report data, the efficiency of data sheet image conversion is improved, decreases business
The workload given a report reduces the probability of human error.
Referring to fig. 2, Fig. 2 is the flow chart of method for processing report data provided by Embodiment 2 of the present invention.In the present embodiment
The executing subject of method for processing report data is report data processing equipment.Report data processing equipment includes but is not limited to intelligence
The mobile terminals such as mobile phone, tablet computer, wearable device can also be server, desktop computer etc..Report number as shown in the figure
It may comprise steps of according to processing method:
S201: the Data Identification of report data and the report data to be processed is obtained.
The implementation of S101 is identical in S201 embodiment corresponding with Fig. 1 in the present embodiment, specifically refers to
The associated description of S101 in the corresponding embodiment of Fig. 1, details are not described herein.
S202: the report data in preset period of time is determined as target data, and when obtaining the generation of the target data
Between.
In practical applications, report data accessed by data processing equipment is very more, wherein may including
Data within a very long time, it is also possible to the report data of many types is contained, in this case, we determined that out one
A period selects corresponding report data as target data by this period.
Further, the length when period chosen in the present embodiment can be one is also possible to two moment
Between period, the quantity of report data is limited by the time.In addition to this it is possible to pass through the number of selection report data
According to type or Data Identification, determine that the corresponding report data of data type is target data.It should be noted that according to when
Between section and data type when being screened to report data, can choose one such pair of report number of period and data type
According to being screened, it is also possible to together screen report data according to period and data type two, does not limit herein
It is fixed.
S203: it according to the size of the target data and the generation time, determines described within the preset period of time
The changing rule of target data.
After target data has been determined according to the report data in preset period of time, we can first be carried out target data
Analysis again shows the situation of change of report data with the data situation obtained according to analysis.
In addition to directly displaying the analysis mode report after the report data of system, or display customer analysis in the present embodiment
Except data, data analysis can also be carried out according to report data and its data dimension, obtain the changing rule of report data.
Illustratively, included information is the numerical value change situation in certain time in report data, if directly
It connects and shows numerical value, then relatively simple, user has no idea obtain from figure after watching report pattern
More information, therefore, we can calculate average value, variance, data according to the data in certain time and increase or reduce
The parameters such as rate can also calculate the data volumes such as data rate of rise most fast period, obtain the changing rule of report data,
According to changing rule and preset changing rule Show Styles, the rule variation figure of report data is generated, with more clearly
To user's display data situation of change.
S204: according to the changing rule and preset changing rule Show Styles, the rule variation of report data is generated
Figure.
The changing rule Show Styles of report data is preset in the present embodiment, changing rule Show Styles is for indicating each
The information such as the situation of change of the report data of a type, such as pace of change, variation tendency, user can be by terminal devices very
The situation of change of data intuitively is got, and then makes resolution, the intuitive of data can be improved in this way, be convenient for
Data management and processing.
After obtaining the changing rule of report data, we advise according to the changing rule of report data and preset variation
Show Styles is restrained, the rule variation figure of report data is generated.Illustratively, after obtaining report data changing rule, if
It include the information such as data growth or the reduction rate of report data in the changing rule of report data, then it is aobvious in changing rule
Show in style library search about data increase or reduce rate regular Show Styles, determined regular Show Styles it
Afterwards, increase or reduce rate and regular Show Styles according to data, generate the rule variation figure of report data.
S205: clustering the Data Identification, obtains the data dimension of the report data, and according to the data
Dimension determines the graphic style for being suitble to the data dimension in preset graphic style library.
Before the graphic style for determining report number according to report data, it is preset with graphic style library in the present embodiment, schemes
Graphic style in shape style library can be divided and be managed according to different pattern dimensions.Due to different types of figure
The corresponding data of pattern are different, match to more accurately and rapidly determine with current report data in the present embodiment
Display mode, when determining suitable graphic style according to report data, the data type according to included in report data is true
The data dimension of settled preceding report data determines suitable graphic style further according to data dimension.
Further, the step S205 in the present embodiment can specifically include step S2051~S2052:
S2051: identifying the corresponding data type of each Data Identification, according to the data type to the Data Identification into
Row cluster, determines the Data Identification for including in the data dimension in the report data and each data dimension；Belong to
The Data Identification of same data dimension is used to cluster display in the statistical chart.
Each report data in the present embodiment has its corresponding Data Identification, and Data Identification can be data name,
Or the forms such as data number, data are labeled and are recognized to play the role of, the form of Data Identification is not done herein
It limits.When obtaining the Data Identification of report data, it can be the mode for directly reading each gauge outfit title in table, pass through knowledge
The other entitled Data Identification of gauge outfit, to determine the Data Identification of report data.The data class of identification report data can also be passed through
The mode of type and size of data determines the Data Identification of report data.
We determine each Data Identification pair according to Data Identification after getting the Data Identification of report data
The data type answered, then the Data Identification of same data type is clustered, obtain data dimension and each data dimension
In include Data Identification.It should be noted that the data type in the present embodiment is for indicating that different data mark is corresponding
Data volume, such as according to the difference of Data Identification, data type is divided into speed type, time type and vehicles class
Type.The Data Identification for belonging to uniform data dimension in the present embodiment is used to cluster display in statistical chart, to realize statistical chart
Comparison between middle uniform data type.
Illustratively, in practical applications, it may include the report data of many types in report data, such as the time,
Quantity, temperature, area etc., it is subdivided in detail a bit, the time can be that unit be measured according to per first quarter, hour, ground
Domain can be Beijing, Shanghai, Guangzhou etc..Illustratively, when the temperature in a report data including per first quarter different geographical
When angle value, our available Data Identifications therein include temperature, time, Beijing, Guangzhou, Shanghai, corresponding data class
Type is respectively temperature, time and region, we cluster according to the different pairs of data type according to mark, obtains three data
Dimension, respectively temperature, time and region, wherein include three Data Identifications in the dimension of region, respectively Beijing, Guangzhou,
Shanghai.At this moment, we can be with time (first quarter, the second quarter, the third season and fourth quarter) for horizontal axis, with temperature
Degree is the longitudinal axis, and according to the difference in each season, the temperature of different cities in the same period, which is clustered, to be indicated, i.e., by contemporaneity
The temperature conditions of different cities put together display, to indicate each city in the temperature variations of different time.
Further, it when the Data Identification for including in report data respectively corresponds to different data types, then needs to lead to
It crosses two-dimensional graphic style to show, B={ ti；Xi}；Wherein, tiAt the time of for indicating different, XiFor indicating with one-dimensional
The corresponding Data Identification of same data type in degree.Similarly, when the Data Identification in list data includes: time, unit name
Claim, warehouse title, materiel code, name of an article specification etc., we determine its corresponding data dimension, use A by identification Data Identification
={ ti；Xi；Yi；…；Zi } indicate data dimension；Wherein, Xi；Yi；…；Zi is for indicating in different moments different dimensions
Data Identification.
It further, can also include: the corresponding data type of each Data Identification of identification in step S2051；The number
It is used to indicate the data class of different data amount according to type；The report data of same data type is divided in same data dimension
In, obtain at least one corresponding data dimension of the report data.
In practical applications, since report in many cases has the comparison between the data of same type, these numbers
According to may Data Identification it is different, but data type be it is identical, we can identify the data type of all Data Identifications, will be same
The report data of one data type is divided in identical dimensional, i.e. C={ ti；Xi；…；Yi, wherein Xi、YiFor indicating different numbers
According to dimension, and wherein contain the Data Identification of corresponding same type, it may be assumed that Xi={ X1；X2；…；Xk},；Yi={ Y1；Y2；…；
Yk}；Wherein, X1；X2；…；XkFor indicating XiData Identification in dimension, Y1；Y2；…；YkFor indicating YiData in dimension
Mark.
It is preset with graphic style library in the present embodiment, the corresponding figure of different data dimension is stored in graphic style library
Pattern, for example, one-dimensional graphic style can be cake chart, perhaps the graphic style of line chart two dimension or multidimensional can be column
Shape figure etc..In report data has been determined after different data dimensions, preset figure is integrated into according to all data dimensions
The graphic style for being suitble to report data is searched in shape style library.
S2052: the graphic element in each graphic style in the data dimension and the graphic style library is carried out
Matching, the determining and matched graphic style of the data dimension.
After data dimension has been determined, the case where we are according to data dimension, determines in preset graphic style library
Graphic style corresponding with data dimension, specifically, we can be by each figure sample in data dimension and graphic style library
The graphic element of formula is matched, to determine and the matched graphic style of data dimension.
Specifically, determining the figure in graphic style library with identical quantity graphic element first according to the quantity of data dimension
Shape pattern completes the initial option of graphic style.The graphic style for again coming out the dimension name of data dimension and initial option
In graphic element matched, specific matching process, which can be, to be calculated between each dimension name and pictorial element title
Text similarity, selecting corresponding pictorial element corresponding graphic style when text similarity maximum is final graphic style.
Before the graphic style for determining report number according to report data, it is preset with graphic style library in the present embodiment, schemes
Graphic style in shape style library can be divided and be managed according to different pattern dimensions, for example, different figure samples
It may include different data dimension quantity and the corresponding display mode of each data dimension in formula, we pass through according to each
The quantity of the corresponding data dimension of graphic style determines the corresponding data dimension situation of graphic style, can also be according to each figure
The dimension of pattern shows that situation determines pattern catalogue of the graphic style in graphic style library.Due to different types of figure sample
The corresponding data of formula are different, more accurately and rapidly determine that is matched with current report data shows in the present embodiment
Show mode, when determining suitable graphic style according to report data, the data type according to included in report data is determined
The data dimension of current report data, determines suitable graphic style further according to data dimension.
S206: the Data Identification of graphic element and the report data in the graphic style is matched one by one,
Determining graphic element corresponding with each Data Identification, and according to the corresponding report data of each Data Identification, figure
Shape element and graphic style generate statistical chart.
The implementation of S103 is identical in S206 embodiment corresponding with Fig. 1 in the present embodiment, specifically refers to
The associated description of S103 in the corresponding embodiment of Fig. 1, details are not described herein.
Further, after step S206, can also include:
S2061: data value in the report data is changed into the corresponding Data Identification of maximum data volume as number of targets
According to mark.
After the graphic style for determining report number according to report data, we generate according to graphic style and report data
Statistical chart.The statistical chart of generation would generally be stored in server end with common picture format, and user can be in client to service
Device end issues the request for checking statistical chart, and statistical chart is sent to by server end with the format of binary data after receiving the request
User terminal, such user can check in client, download statistics figure.
We after determining the data dimension of report data, can with combined data dimension, the data type of report data,
Report data is analyzed, determines the corresponding Data Identification of at least one data volume that data value changes greatly, i.e. number of targets
According to mark, and using these Data Identifications as the emphasis data volume for display of giving prominence to the key points, i.e. target data amount.According to emphasis data
The quantity of amount, data dimension determine matched graphic style, and after determining graphic style, according to the graphic style and emphasis
Data volume highlights emphasis data volume, enhances the display effect of report data.
Specifically, we can data value changes maximum data volume at identification in report data, and by its data mark
Know and identified as target data, is shown with carrying out emphasis.It should be noted that the target data amount in the present embodiment is for indicating
The data variation data volume more extreme with respect to other data variation amplitudes can be the maximum data volume of variation, can also be with
It is the smallest data volume of amplitude of variation, herein without limitation.Meanwhile the quantity of target data amount can be one, be also possible to
It is multiple, when target data amount is multiple situation, more clear it can comprehensively represent data situation.
S2062: the target data is identified and is shown in the statistical chart according to the preset pattern that highlights.
It is identified data value in report data is changed the corresponding Data Identification of maximum data volume as target data
Afterwards, target data is identified and is shown in statistical chart according to the preset pattern that highlights by we, and statistical chart is sent to pre-
If management terminal.
In the present embodiment, the comparative pattern of data result can be generated by the report data of separate sources.For example, current
Year-on-year figure, current year-on-year figure are used to indicate the number that the comparison of the current-period data of current year current-period data and upper one year obtains
According to.Since current year-on-year data are compared with the contemporaneous data of last year this season, so not needing to adjust to period when relatively.
It reflects the case where 2 years current all data runs but except the data feelings of the external factors such as seasonality influence combined
Condition.
Above scheme, by the Data Identification for obtaining report data and the report data to be processed；It determines default
Report data in period obtains the generation time of the target data as target data；According to the target data
Size and the generation time determine the changing rule of the target data described within the preset period of time；According to the variation
Regular and preset changing rule Show Styles generates the rule variation figure of report data.The Data Identification is gathered
Class obtains the data dimension of the report data, and is determined and be suitble in preset graphic style library according to the data dimension
The graphic style of the data dimension；The Data Identification of graphic element and the report data in the graphic style is carried out
It matches one by one, determining graphic element corresponding with each Data Identification, and according to the corresponding report of each Data Identification
Table data, graphic element and graphic style generate statistical chart.By obtaining report data and the report data to be processed
Data Identification and its Data Identification, to Data Identification carry out dimension division, obtain at least one data dimension of report data,
The graphic style for obtaining being suitble to report data is matched in preset graphic style library according to data dimension, finally according to figure sample
Formula and report data generate statistical chart, improve the efficiency of data sheet image conversion, the workload that the business of decreasing is given a report,
Reduce the probability of human error.
It is a kind of schematic diagram for report data processing equipment that the embodiment of the present invention three provides referring to Fig. 3, Fig. 3.Report number
The each unit for including according to processing equipment is used to execute each step in the corresponding embodiment of FIG. 1 to FIG. 2.Referring specifically to Fig. 1~
Associated description in the corresponding embodiment of Fig. 2.For ease of description, only the parts related to this embodiment are shown.This
The report data processing equipment 300 of embodiment includes:
Acquiring unit 301, for obtaining the Data Identification of report data and the report data to be processed；
Pattern unit 302 obtains the data dimension of the report data for clustering to the Data Identification, and
The graphic style for being suitble to the data dimension is determined in preset graphic style library according to the data dimension；The figure sample
By way of formula is for indicating the report data described in the graphical display；It include graphic element in the graphic style；
Generation unit 303, for by the Data Identification of graphic element and the report data in the graphic style into
Row matches one by one, determining graphic element corresponding with each Data Identification, and corresponding according to each Data Identification
Report data, graphic element and graphic style generate statistical chart.
Further, the pattern unit 302 may include:
Dimension determination unit, the corresponding data type of each Data Identification for identification, according to the data type to institute
It states Data Identification to be clustered, determines in the data dimension in the report data and each data dimension and include
Data Identification；The Data Identification for belonging to same data dimension is used to cluster display in the statistical chart；
Style determination unit, for by the figure in each graphic style in the data dimension and the graphic style library
Shape element is matched, the determining and matched graphic style of the data dimension.
Further, the dimension determination unit may include:
Type determining units, for identification corresponding data type of each Data Identification；The data type is for indicating
The data class of different data amount；
Dimension division unit obtains institute for the report data of same data type to be divided in same data dimension
State at least one corresponding data dimension of report data.
Further, the report data processing equipment can also include:
Target determination unit, for determining that the report data in preset period of time as target data, and obtains the target
The generation time of data；
Regular determination unit is determined according to the size of the target data and the generation time in the preset period of time
Within the target data changing rule；
Irregular pattern unit, for generating report number according to the changing rule and preset changing rule Show Styles
According to rule variation figure.
Further, the report data processing equipment 300 can also include:
Target identification unit, for data value in the report data to be changed the corresponding Data Identification of maximum data volume
It is identified as target data；
Target display unit is shown according to the preset pattern that highlights in the system for identifying the target data
It counts in figure.
Above scheme, by the Data Identification for obtaining report data and the report data to be processed；To the number
It is clustered according to mark, obtains the data dimension of the report data, and according to the data dimension in preset graphic style
The graphic style for being suitble to the data dimension is determined in library；By the graphic element and the report data in the graphic style
Data Identification is matched one by one, determining graphic element corresponding with each Data Identification, and according to each data
It identifies corresponding report data, graphic element and graphic style and generates statistical chart.By obtain report data to be processed and
The Data Identification and its Data Identification of the report data carry out dimension division to Data Identification, obtain report data at least
One data dimension matches the graphic style for obtaining being suitble to report data according to data dimension in preset graphic style library,
Statistical chart is finally generated according to graphic style and report data, the efficiency of data sheet image conversion is improved, decreases business
The workload given a report reduces the probability of human error.
Fig. 4 is the schematic diagram for the report data processing equipment that the embodiment of the present invention four provides.As shown in figure 4, the embodiment
Report data processing equipment 4 include: processor 40, memory 41 and be stored in the memory 41 and can be at the place
The computer program 42 run on reason device 40.The processor 40 realizes above-mentioned each report when executing the computer program 42
Step in data processing method embodiment, such as step 101 shown in FIG. 1 is to 103.Alternatively, the processor 40 executes institute
Realize the function of each module/unit in above-mentioned each Installation practice when stating computer program 42, for example, unit 301 shown in Fig. 3 to
303 function.
Illustratively, the computer program 42 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 41, and are executed by the processor 40, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, which is used for
Implementation procedure of the computer program 42 in the report data processing equipment 4 is described.
The report data processing equipment 4 can be desktop PC, notebook, palm PC and cloud server etc.
Calculate equipment.The report data processing equipment may include, but be not limited only to, processor 40, memory 41.Those skilled in the art
Member is appreciated that Fig. 4 is only the example of report data processing equipment 4, does not constitute the limit to report data processing equipment 4
It is fixed, it may include perhaps combining certain components or different components, such as the report than illustrating more or fewer components
Table data processing equipment can also include input-output equipment, network access equipment, bus etc..
Alleged processor 40 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng.
The memory 41 can be the internal storage unit of the report data processing equipment 4, such as at report data
Manage the hard disk or memory of equipment 4.The memory 41 is also possible to the External memory equipment of the report data processing equipment 4,
Such as the plug-in type hard disk being equipped in the report data processing equipment 4, intelligent memory card (Smart Media Card, SMC),
Secure digital (Secure Digital, SD) card, flash card (Flash Card, FC) etc..Further, the memory 41 is gone back
Can both including the report data processing equipment 4 internal storage unit and also including External memory equipment.The memory 41
For other programs and data needed for storing the computer program and the report data processing equipment.The memory
41 can be also used for temporarily storing the data that has exported or will export.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing
The all or part of function of description.Each functional unit in embodiment, module can integrate in one processing unit, can also
To be that each unit physically exists alone, can also be integrated in one unit with two or more units, it is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.In addition, each function list
Member, the specific name of module are also only for convenience of distinguishing each other, the protection scope being not intended to limit this application.Above system
The specific work process of middle unit, module, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
If the integrated module/unit be realized in the form of SFU software functional unit and as independent product sale or
In use, can store in a computer readable storage medium.Based on this understanding, the present invention realizes above-mentioned implementation
All or part of the process in example method, can also instruct relevant hardware to complete, the meter by computer program
Calculation machine program can be stored in a computer readable storage medium.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features；And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of method for processing report data characterized by comprising
Obtain the Data Identification of report data and the report data to be processed；
The Data Identification is clustered, obtains the data dimension of the report data, and according to the data dimension pre-
If graphic style library in determine and be suitble to the graphic style of the data dimension；The graphic style is for indicating aobvious by figure
Show the mode of the report data；It include graphic element in the graphic style；
The Data Identification of graphic element and the report data in the graphic style is matched one by one, it is determining and each
The corresponding graphic element of the Data Identification, and according to the corresponding report data of each Data Identification, graphic element and figure
Shape pattern generates statistical chart.
2. method for processing report data as described in claim 1, which is characterized in that described to gather to the Data Identification
Class obtains the data dimension of the report data, and is determined and be suitble in preset graphic style library according to the data dimension
The graphic style of the data dimension, comprising:
It identifies the corresponding data type of each Data Identification, the Data Identification is clustered according to the data type, really
The Data Identification for including in data dimension and each data dimension in the fixed report data；Belong to same data
The Data Identification of dimension is used to cluster display in the statistical chart；
The data dimension is matched with the graphic element in each graphic style in the graphic style library, determine with
The matched graphic style of data dimension.
3. method for processing report data as claimed in claim 2, which is characterized in that each Data Identification of identification is corresponding
Data type clusters the Data Identification according to the data type, determines the data dimension in the report data,
And the Data Identification in each data dimension including, comprising:
Identify the corresponding data type of each Data Identification；The data type is used to indicate the data class of different data amount；
The report data of same data type is divided in same data dimension, the report data corresponding at least one is obtained
A data dimension.
4. method for processing report data as described in claim 1, which is characterized in that it is described obtain report data to be processed with
And after the Data Identification of the report data, further includes:
Determine that the report data in preset period of time as target data, and obtains the generation time of the target data；
According to the size of the target data and the generation time, the target data described within the preset period of time is determined
Changing rule；
According to the changing rule and preset changing rule Show Styles, the rule variation figure of report data is generated.
5. method for processing report data according to any one of claims 1-4, which is characterized in that described by the graphic style
In graphic element and the Data Identification of the report data matched one by one, determination is corresponding with each Data Identification
Graphic element, and according to the corresponding report data of each Data Identification, graphic element and graphic style generate statistical chart it
Afterwards, further includes:
Data value in the report data is changed the corresponding Data Identification of maximum data volume as target data to identify；
The target data is identified and is shown in the statistical chart according to the preset pattern that highlights.
6. a kind of report data processing equipment, which is characterized in that including memory and processor, be stored in the memory
The computer program that can be run on the processor, which is characterized in that real when the processor executes the computer program
Existing following steps:
Obtain the Data Identification of report data and the report data to be processed；
The Data Identification is clustered, obtains the data dimension of the report data, and according to the data dimension pre-
If graphic style library in determine and be suitble to the graphic style of the data dimension；The graphic style is for indicating aobvious by figure
Show the mode of the report data；It include graphic element in the graphic style；
The Data Identification of graphic element and the report data in the graphic style is matched one by one, it is determining and each
The corresponding graphic element of the Data Identification, and according to the corresponding report data of each Data Identification, graphic element and figure
Shape pattern generates statistical chart.
7. report data processing equipment as claimed in claim 6, which is characterized in that described to gather to the Data Identification
Class obtains the data dimension of the report data, and is determined and be suitble in preset graphic style library according to the data dimension
The graphic style of the data dimension, comprising:
It identifies the corresponding data type of each Data Identification, the Data Identification is clustered according to the data type, really
The Data Identification for including in data dimension and each data dimension in the fixed report data；Belong to same data
The Data Identification of dimension is used to cluster display in the statistical chart；
The data dimension is matched with the graphic element in each graphic style in the graphic style library, determine with
The matched graphic style of data dimension.
8. report data processing equipment as claimed in claim 7, which is characterized in that each Data Identification of identification is corresponding
Data type clusters the Data Identification according to the data type, determines the data dimension in the report data,
And the Data Identification in each data dimension including, comprising:
Identify the corresponding data type of each Data Identification；The data type is used to indicate the data class of different data amount；
The report data of same data type is divided in same data dimension, the report data corresponding at least one is obtained
A data dimension.
9. a kind of report data processing equipment characterized by comprising
Acquiring unit, for obtaining the Data Identification of report data and the report data to be processed；
Pattern unit obtains the data dimension of the report data, and according to described for clustering to the Data Identification
Data dimension determines the graphic style for being suitble to the data dimension in preset graphic style library；The graphic style is used for table
By way of showing the report data described in the graphical display；It include graphic element in the graphic style；
Generation unit, for carrying out one by one the Data Identification of graphic element and the report data in the graphic style
Match, determining graphic element corresponding with each Data Identification, and according to the corresponding report data of each Data Identification,
Graphic element and graphic style generate statistical chart.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In when the computer program is executed by processor the step of any one of such as claim 1 to 5 of realization the method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910667542.7A CN110489732A (en) | 2019-07-23 | 2019-07-23 | Method for processing report data and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910667542.7A CN110489732A (en) | 2019-07-23 | 2019-07-23 | Method for processing report data and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110489732A true CN110489732A (en) | 2019-11-22 |
Family
ID=68548021
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910667542.7A Pending CN110489732A (en) | 2019-07-23 | 2019-07-23 | Method for processing report data and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110489732A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347747A (en) * | 2020-11-03 | 2021-02-09 | 金蝶云科技有限公司 | Form style processing method and related device |
| CN114115008A (en) * | 2021-11-17 | 2022-03-01 | 国网山东省电力公司电力科学研究院 | 5G network-based power equipment operation data transmission method and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109086397A (en) * | 2018-07-28 | 2018-12-25 | 重庆柚瓣家科技有限公司 | Dynamic report generation method based on inquiry dimension |
| CN109344178A (en) * | 2018-09-18 | 2019-02-15 | 杭州安恒信息技术股份有限公司 | A kind of data sheet real-time statistical method, device, equipment and readable storage medium storing program for executing |
| CN109688437A (en) * | 2018-12-10 | 2019-04-26 | 未来电视有限公司 | A kind of method for exhibiting data, device, electronic equipment and readable storage medium storing program for executing |
-
2019
- 2019-07-23 CN CN201910667542.7A patent/CN110489732A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109086397A (en) * | 2018-07-28 | 2018-12-25 | 重庆柚瓣家科技有限公司 | Dynamic report generation method based on inquiry dimension |
| CN109344178A (en) * | 2018-09-18 | 2019-02-15 | 杭州安恒信息技术股份有限公司 | A kind of data sheet real-time statistical method, device, equipment and readable storage medium storing program for executing |
| CN109688437A (en) * | 2018-12-10 | 2019-04-26 | 未来电视有限公司 | A kind of method for exhibiting data, device, electronic equipment and readable storage medium storing program for executing |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347747A (en) * | 2020-11-03 | 2021-02-09 | 金蝶云科技有限公司 | Form style processing method and related device |
| CN112347747B (en) * | 2020-11-03 | 2024-03-19 | 金蝶云科技有限公司 | Form style processing method and related device |
| CN114115008A (en) * | 2021-11-17 | 2022-03-01 | 国网山东省电力公司电力科学研究院 | 5G network-based power equipment operation data transmission method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10037305B2 (en) | Computer-implemented systems and methods for time series exploration | |
| US9437022B2 (en) | Time-based visualization of the number of events having various values for a field | |
| TWI673680B (en) | Apparatus and method for interactive visual analytics of multi-dimensional temporal data and storage medium | |
| US9244887B2 (en) | Computer-implemented systems and methods for efficient structuring of time series data | |
| US20180189294A1 (en) | Constructing Data Visualization Options for a Data Set According to User-Selected Data Fields | |
| US7265755B2 (en) | Method and system for dynamic visualization of multi-dimensional data | |
| US9934299B2 (en) | Systems and methods for interest-driven data visualization systems utilizing visualization image data and trellised visualizations | |
| EP2410446A1 (en) | Personal music recommendation mapping | |
| US9582573B2 (en) | Interactive composite plot for visualizing multi-variable data | |
| CN107590181A (en) | A kind of intelligent analysis system of big data | |
| US20030018584A1 (en) | System and method for analyzing transaction data | |
| Wise et al. | Providing spatial statistical data analysis functionality for the GIS user: the SAGE project | |
| US20180268082A1 (en) | Discriminative clustering | |
| CN111460011A (en) | Page data display method and device, server and storage medium | |
| CN103853809A (en) | Efficient space allocation for business objects | |
| Tešendić et al. | Business intelligence in the service of libraries | |
| EP3198489A1 (en) | Guided data exploration | |
| CN110489732A (en) | Method for processing report data and equipment | |
| CN112818013A (en) | Time sequence database query optimization method, device, equipment and storage medium | |
| CN108665513A (en) | Drawing practice based on user behavior data and device | |
| CN110245684A (en) | Data processing method, electronic equipment and medium | |
| Ding et al. | Establishing smartphone user behavior model based on energy consumption data | |
| CN112860808A (en) | User portrait analysis method, device, medium and equipment based on data tag | |
| US20090012919A1 (en) | Explaining changes in measures thru data mining | |
| Persson | A survey of methods for visualizing spatio-temporal data |
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 |