CN110737672A - data visualization method and device - Google Patents
data visualization method and device Download PDFInfo
- Publication number
- CN110737672A CN110737672A CN201810805456.3A CN201810805456A CN110737672A CN 110737672 A CN110737672 A CN 110737672A CN 201810805456 A CN201810805456 A CN 201810805456A CN 110737672 A CN110737672 A CN 110737672A
- Authority
- CN
- China
- Prior art keywords
- chart
- data
- combined
- user
- obtaining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides data visualization methods and devices, and the methods include obtaining a plurality of charts, determining each chart to be combined from the obtained plurality of charts, and performing combined display on each chart to be combined, wherein each chart is obtained by obtaining an interface opening instruction, displaying a database connection interface, obtaining connection information of a database to be connected, which is input by a user through the database connection interface, establishing connection with the database to be connected by using the connection information, displaying a data configuration interface after the connection is successfully established, obtaining data table information and chart configuration information input by the user through the data configuration interface, generating query sentences based on the data table information, obtaining data to be displayed by using the query sentences, and rendering the chart configuration information and the data to be displayed to obtain the chart containing the data to be displayed.
Description
Technical Field
The invention relates to the field of data processing, in particular to a data visualization method and device.
Background
With the advent of the big data era, the data types are increasingly diversified, the data amount is increased, how to better present the data becomes a problem for various industries, and the research of data visualization methods becomes more and more important.
At present, the existing data visualization methods are mainly realized by means of visualization tools such as echarts, highchars, d3 and the like, however, the application of these visualization tools requires a front-end development basis of , and for ordinary people without the development basis, the operation process is complex and the universality is not strong.
It is therefore necessary to design new data visualization methods to overcome the above problems.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides data visualization methods and devices to simplify the operation process and improve the universality.
The invention is realized by the following steps:
, the invention provides a method of data visualization, the method comprising:
obtaining a plurality of charts, determining each chart to be combined from the obtained charts, and performing combined display on each chart to be combined;
wherein each graph is obtained by:
acquiring an interface opening instruction, displaying a database connection interface, and acquiring connection information of a database to be connected, which is input by a user through the database connection interface; establishing connection with the database to be connected by using the connection information;
after the connection is successfully established, displaying a data configuration interface, acquiring data table information and chart configuration information input by a user through the data configuration interface, and generating a query statement based on the data table information; obtaining data to be displayed by utilizing the query statement;
and rendering the chart configuration information and the data to be displayed to obtain a chart containing the data to be displayed.
Optionally, the chart configuration information includes at least of a chart type, a color, a border, a position of the chart in the canvas, and a font.
Optionally, determining each chart to be combined from the obtained multiple charts includes:
and after the chart combination instruction is detected, displaying a chart combination configuration interface, acquiring a user selection instruction, and selecting each chart to be combined from the acquired plurality of charts according to the selection instruction.
Optionally, after the charts to be combined are combined and displayed, the method further includes:
and after the dragging instruction is detected, moving the position of the chart to be combined acted by the dragging instruction according to the direction of the dragging instruction.
Optionally, after the charts to be combined are combined and displayed, the method further includes:
and after a size adjusting instruction is detected, adjusting the size of the chart to be combined acted by the size adjusting instruction according to the size parameter in the size adjusting instruction.
Optionally, the data configuration interface includes a data table identifier selection list, a field input box, and a screening condition input box, and the obtaining data table information input by the user through the data configuration interface and generating a query statement based on the data table information includes:
acquiring a data table identifier selected by a user through the data table identifier selection list, a field input through the field input box and a screening condition input through the screening condition input box;
and generating a query statement based on the obtained data table identification, the field and the screening condition.
Optionally, the data configuration interface includes a chart code editing area, and the obtaining of the chart configuration information input by the user through the data configuration interface includes:
obtaining a chart configuration code written by a user through the chart code editing area;
and taking the chart configuration code as chart configuration information.
Optionally, the data configuration interface further includes a chart type selection list and a chart parameter input box, and the obtaining of the chart configuration information input by the user through the data configuration interface includes:
obtaining the chart type selected by the user through the chart type selection list;
and obtaining the chart parameters input by the user through the chart parameter input box.
Optionally, the method further includes:
and correspondingly storing the obtained data table information and the chart configuration information.
In a second aspect, the present invention provides data visualization apparatus, the apparatus comprising:
the obtaining module is used for obtaining a plurality of charts and determining each chart to be combined from the obtained charts;
the display module is used for carrying out combined display on each chart to be combined;
wherein the obtaining module obtains each graph by:
acquiring an interface opening instruction, displaying a database connection interface, and acquiring connection information of a database to be connected, which is input by a user through the database connection interface; establishing connection with the database to be connected by using the connection information;
after the connection is successfully established, displaying a data configuration interface, acquiring data table information and chart configuration information input by a user through the data configuration interface, and generating a query statement based on the data table information; obtaining data to be displayed by utilizing the query statement;
and rendering the chart configuration information and the data to be displayed to obtain a chart containing the data to be displayed.
Optionally, the chart configuration information includes at least of a chart type, a color, a border, a position of the chart in the canvas, and a font.
Optionally, the obtaining module determines each chart to be combined from the obtained multiple charts, specifically:
and after the chart combination instruction is detected, displaying a chart combination configuration interface, acquiring a user selection instruction, and selecting each chart to be combined from the acquired plurality of charts according to the selection instruction.
Optionally, the apparatus further comprises an th combination module for:
after the graphs to be combined are combined and displayed and a dragging instruction is detected, the position of the graph to be combined acted by the dragging instruction is moved according to the direction of the dragging instruction.
Optionally, the apparatus further comprises a second combining module, configured to:
after all the charts to be combined are combined and displayed, and after a size adjusting instruction is detected, the size of the charts to be combined acted by the size adjusting instruction is adjusted according to the size parameters in the size adjusting instruction.
Optionally, the data configuration interface includes a data table identifier selection list, a field input box, and a screening condition input box, the display module obtains data table information input by a user through the data configuration interface, and generates a query statement based on the data table information, specifically:
acquiring a data table identifier selected by a user through the data table identifier selection list, a field input through the field input box and a screening condition input through the screening condition input box;
and generating a query statement based on the obtained data table identification, the field and the screening condition.
Optionally, the data configuration interface includes a chart code editing area, and the display module obtains the chart configuration information input by the user through the data configuration interface, specifically:
obtaining a chart configuration code written by a user through the chart code editing area;
and taking the chart configuration code as chart configuration information.
Optionally, the data configuration interface further includes a chart type selection list and a chart parameter input box, and the display module obtains the chart configuration information input by the user through the data configuration interface, specifically:
obtaining the chart type selected by the user through the chart type selection list;
and obtaining the chart parameters input by the user through the chart parameter input box.
Optionally, the apparatus further includes a storage module, configured to:
and correspondingly storing the obtained data table information and the chart configuration information.
The method has the advantages that the multiple graphs are obtained, each graph to be combined is determined from the multiple obtained graphs, and each graph to be combined is combined and displayed, wherein each graph is obtained through the following steps that firstly, an interface opening instruction is obtained, a database connection interface is displayed, connection information of the database to be connected input by a user through the database connection interface is obtained, connection is established with the database to be connected through the connection information, then, after connection is successfully established, the data configuration interface is displayed, data table information and graph configuration information input by the user through the data configuration interface are obtained, query sentences are generated based on the data table information, data to be displayed are obtained through the query sentences, and accordingly, the graph configuration information and the data to be displayed can be rendered, and the graph containing the data to be displayed is obtained.
Therefore, by applying the embodiment of the invention, the user can generate the chart containing the data to be displayed only by inputting the connection information, the data sheet information and the chart configuration information, the operation process is simplified, the universality is improved, the generated chart can be displayed in a combined manner, the data visualization degree is higher, and the user does not need to write complex codes, so that the data visualization development efficiency is improved, the development cost is saved, and the development period is shortened.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a schematic flow chart of a data visualization method according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a data visualization apparatus provided in an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be described clearly and completely with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only partial embodiments of of the present invention, rather than all embodiments.
It should be noted that the data visualization method provided by the present invention can be applied to electronic devices, wherein in a specific application, the electronic device can be a computer, a personal computer, a tablet, a mobile phone, and the like, which is reasonable.
Referring to fig. 1, an embodiment of the present invention provides data visualization methods, including the following steps:
s101, obtaining a plurality of charts, and determining each chart to be combined from the obtained charts;
and S102, combining and displaying the charts to be combined.
Wherein S101 obtains the per chart by performing S1011-S1013:
s1011, obtaining an interface opening instruction, displaying a database connection interface, and obtaining connection information of the database to be connected, which is input by a user through the database connection interface; establishing connection with the database to be connected by using the connection information;
after the interface opening instruction is obtained, the database connection interface can be displayed. Specifically, the electronic device may determine to obtain the interface opening instruction when detecting a certain operation of the user, for example, may determine to obtain the interface opening instruction when detecting that the start icon is double-clicked, or may determine to obtain the interface opening instruction after detecting that the start icon is right-clicked.
The connection information comprises a database type, an IP address of the database, a port number of the database, a library name of the database, a user name, a password and the like, a user can click a connection button after inputting, and then the electronic equipment can establish connection with the database to be connected by using the connection information. Database types include Oracle database, sybase database, DB2 database, mysql database, sqlite database, and the like.
The number of the databases to be connected may be or more, and when the number of the databases to be connected is multiple, the database types of the respective databases to be connected may be the same or different.
The method can be connected to different databases by setting different connection information, realizes the configuration of the databases, is lighter and more flexible compared with the custom development of the databases of the traditional data visualization method, and is suitable for various databases of different types.
, in order to obtain the connection status and improve the reliability of the method, in the case of unsuccessful connection establishment, the method may further include:
and the step of displaying the data configuration interface is not executed, and prompt information for prompting that the connection is not successfully established is displayed.
In addition, in implementations, in the case that the connection is not successfully established, the reason of the unsuccessful connection can also be displayed, so that the problem of the unsuccessful connection can be solved according to the reason, and the connection can be successfully established next time.
S1012, after the connection is successfully established, displaying a data configuration interface, acquiring data table information and chart configuration information input by a user through the data configuration interface, and generating a query statement based on the data table information; and obtaining the data to be displayed by utilizing the query statement.
The data table information may include at least of data table identifications, fields, screening conditions, SQL (Structured query language) codes, the data table identifications are used for only to identify the data tables, which may be table names, numbers, etc. of the data tables, the data tables in the data table information identify the marked data tables as data tables in the database for which the connection has been successfully established.
After the connection with the database to be connected is successfully established, the data tables in the connected database can be imported, so that when a data table selection instruction is detected by the data configuration interface, the imported data table identifiers can be displayed for the user to select.
For example, the data configuration interface may include a data table identifier input box, and when it is detected that a user clicks the data table identifier input box, it is determined that a data table selection instruction is detected, and then each imported data table identifier is displayed in a list form, and when it is detected that the user clicks a certain data table identifier, it is determined that the obtained data table identifier is: the clicked data table identifies.
Or, the data configuration interface may include a data table identifier display area, and may directly display each imported data table identifier in the data table identifier display area for the user to select.
, the data configuration interface may include a data table identifier selection list, a field input box and a filtering condition input box, obtains data table information input by a user through the data configuration interface, and generates a query statement based on the data table information, including the following steps:
acquiring a data table identifier selected by a user through the data table identifier selection list, a field input through the field input box and a screening condition input through the screening condition input box;
and generating a query statement based on the obtained data table identification, the field and the screening condition.
After the data table identifier is selected, the fields in the data table marked by the selected data table identifier can be displayed on a data configuration interface for a user to select field input, and the fields input by the user can be fields to be counted or fields to be grouped.
The query statement may be an SQL statement or an SQL-like statement, such as a HiveQL (hive structured query Language) statement, and the query statement may be generated by filling the code with the obtained identifier, field, and screening condition of the data table according to a preset query statement generation rule.
In addition, in order to implement the generation of the complex query statement, in implementations, the data configuration interface may further include a query statement editing area, where the user may directly input a query code, obtain the query code input by the user after detecting that the submit button is pressed, determine that the obtained data table information is the query code, and generate the query statement based on the data table information by taking the query code as the query statement.
The generated query statement may be multiple, some of which may be directly the query code input through the query statement edit area, and some of which may be generated based on the obtained data table identification, field, and filter condition.
The data to be displayed can be obtained by utilizing the query statement, the specific implementation mode can be that the query statement is sent to the query terminal so that the query terminal executes the query statement to obtain the data to be displayed and receives the data to be displayed sent by the query terminal, or the query statement can be directly executed to obtain the data to be displayed, and the query terminal can be another server or a server cluster independent of the electronic equipment.
, in order to facilitate user customization of different types of chart configuration information, the data configuration interface includes a chart code editing area, and obtaining the chart configuration information input by the user through the data configuration interface includes:
obtaining a chart configuration code written by a user through the chart code editing area;
and taking the chart configuration code as chart configuration information.
The chart configuration code may set at least of chart configuration information for chart type, color, border, position of the chart within the canvas, font, etc.
By setting the self-defined chart type, the types of the chart types can be expanded, and the user requirements can be better met.
In another implementation manners, the data configuration interface may further include a chart type selection list and a chart parameter input box, and obtaining the chart configuration information input by the user through the data configuration interface includes:
obtaining the chart type selected by the user through the chart type selection list;
and obtaining the chart parameters input by the user through the chart parameter input box.
The chart type selection list may include preset chart types and chart types customized by a user through a chart configuration code, and the preset chart types may include: pie charts, line states, histograms, scatter plots, maps, and other conventional chart types. Chart parameters may include chart title, color, height value, width value, position of the chart in the canvas, font, etc., custom chart types include echarts charts, etc.
To facilitate data reading, the method may further comprise:
and correspondingly storing the obtained data table information and the chart configuration information.
For each chart, the data table information and the chart configuration information for generating the chart can be stored correspondingly, so that the data table information and the chart configuration information for generating the chart can be directly read when the chart is generated next time, and the information of each chart is independently stored.
And S1013, rendering the chart configuration information and the data to be displayed to obtain a chart containing the data to be displayed.
The chart configuration information and the data to be displayed can be rendered based on a graph rendering technology such as Canvas or SVG (Scalable Vector Graphics), so as to obtain a chart containing the data to be displayed.
For the convenience of viewing by the user, after the chart containing the data to be displayed is obtained, the chart can be displayed separately.
Further, the graphs obtained in S1013 may be stored, so that S101 may obtain a plurality of graphs by directly reading the plurality of graphs, or S101 may obtain the graphs obtained in S1013 in real time. A plurality in this application may be two or more.
Therefore, by applying the embodiment of the invention, the user can generate the chart containing the data to be displayed only by inputting the connection information, the data sheet information and the chart configuration information, and can carry out combined display on the generated chart, thereby simplifying the operation process, improving the universality, and the user does not need to write complex codes, thereby improving the visualized development efficiency of the data, saving the development cost and shortening the development period.
For the data visualization development efficiency, in implementation manners, determining each chart to be combined from the obtained multiple charts includes, after a chart combination instruction is detected, displaying a chart combination configuration interface, obtaining a user selection instruction, and selecting each chart to be combined from the obtained multiple charts according to the selection instruction.
In another implementation manners, after the combined display of the charts to be combined, the method further includes:
and after the dragging instruction is detected, moving the position of the chart to be combined acted by the dragging instruction according to the direction of the dragging instruction.
The data configuration interface may include a chart combination menu option, and when it is detected that the chart combination menu option is selected, it may be determined that a chart combination instruction is detected; alternatively, the data configuration interface may include a chart combination button, and when it is detected that the chart combination button is clicked, it may be determined that a chart combination instruction is detected.
The chart combination configuration interface can display the obtained multiple charts, after the fact that the charts are clicked or double-clicked is detected, a user selection instruction can be determined to be obtained, and each clicked or double-clicked chart is selected from the obtained multiple charts to serve as each chart to be combined.
The charts to be combined can be displayed on the chart combination configuration interface, display interfaces can be popped up additionally, the charts to be combined are displayed in the popped up display interfaces, the initial position of each chart to be combined in the display interfaces can be a preset initial position or an initial position obtained randomly.
It should be noted that the dragging instruction may be performed by the user through a terminal device, for example, the terminal device may be a mouse, an electronic pen, or a touch screen device.
Illustratively, the terminal device is a mouse, and when it is detected that the user long-presses the diagram to be combined through the mouse and performs up/down/left/right dragging, the long-pressed diagram to be combined is moved up/down/left/right according to the dragging direction.
The chart to be combined acted by the dragging instruction can be charts to be combined or can be multiple charts to be combined, and the chart to be combined acted by the dragging instruction can be a detected chart to be combined that is selected by the user, for example, the chart to be combined that is being dragged by the user or or more charts to be combined that are selected by the user through a selection box.
In addition, the size, position, chart type, data table information, and the like of the chart to be combined after the position is moved may be stored.
By applying the embodiment of the invention, different charts can be combined and displayed, the positions of the charts can be moved, the data visualization degree is improved, and the charts to be combined are generated charts without reconfiguration, so that the data visualization development efficiency is improved, the development cost is saved, and the development period is shortened.
To further increase the data visualization degree in , in implementations, after displaying each chart to be combined, the method further includes:
and after a size adjusting instruction is detected, adjusting the size of the chart to be combined acted by the size adjusting instruction according to the size parameter in the size adjusting instruction.
When the chart to be combined is detected to be pulled, the fact that the size adjusting instruction is detected can be determined; or, the display interface for displaying each chart to be combined may further include a size input box and a size confirmation button, and after the size input by the user through the size input box is obtained, if it is detected that the size confirmation button is pressed, it is determined that the size adjustment instruction is detected.
The resizing instructions may act on charts to be combined, or simultaneously act on a plurality of charts to be combined, and the charts to be combined acted on by the resizing instructions are detected charts to be combined which are operated by the user, for example, the charts to be combined which are being pulled by the user or the charts to be combined which are selected by the user.
In addition, the size, the position, the data table information, the chart type and the like of the chart to be combined after the size is adjusted can be stored.
By applying the embodiment of the invention, different charts can be combined and displayed, the size of the chart displayed in a combined mode can be adjusted, the data visualization degree is further improved, and the chart to be combined is the generated chart and does not need to be reconfigured, so that the data visualization development efficiency is improved, the development cost is saved, and the development period is shortened.
Specifically, different charts can be displayed in a combined manner by using a large screen, for example, a common projector or a display screen with a display function is used to display different charts in a combined manner.
Corresponding to the above method embodiments, the embodiment of the present invention further provides data visualization apparatuses.
Referring to fig. 2, fig. 2 is a schematic structural diagram of data visualization apparatuses provided in an embodiment of the present invention, where the apparatuses include:
an obtaining module 201, configured to obtain a plurality of charts, and determine each chart to be combined from the obtained plurality of charts;
the display module 202 is configured to perform combined display on each chart to be combined;
wherein the obtaining module 201 obtains each graph by:
acquiring an interface opening instruction, displaying a database connection interface, and acquiring connection information of a database to be connected, which is input by a user through the database connection interface; establishing connection with the database to be connected by using the connection information;
after the connection is successfully established, displaying a data configuration interface, acquiring data table information and chart configuration information input by a user through the data configuration interface, and generating a query statement based on the data table information; obtaining data to be displayed by utilizing the query statement;
and rendering the chart configuration information and the data to be displayed to obtain a chart containing the data to be displayed.
Therefore, by applying the embodiment of the invention, the user can generate the chart containing the data to be displayed only by inputting the connection information, the data sheet information and the chart configuration information, the operation process is simplified, the universality is improved, the generated chart can be displayed in a combined manner, the data visualization degree is higher, and the user does not need to write complex codes, so that the data visualization development efficiency is improved, the development cost is saved, and the development period is shortened.
Optionally, the chart configuration information includes at least of a chart type, a color, a border, a position of the chart in the canvas, and a font.
Optionally, the obtaining module determines each chart to be combined from the obtained multiple charts, specifically:
and after the chart combination instruction is detected, displaying a chart combination configuration interface, acquiring a user selection instruction, and selecting each chart to be combined from the acquired plurality of charts according to the selection instruction.
Optionally, the apparatus further comprises an th combination module for:
after the graphs to be combined are combined and displayed and a dragging instruction is detected, the position of the graph to be combined acted by the dragging instruction is moved according to the direction of the dragging instruction.
Optionally, the apparatus further comprises a second combining module, configured to:
after all the charts to be combined are combined and displayed, and after a size adjusting instruction is detected, the size of the charts to be combined acted by the size adjusting instruction is adjusted according to the size parameters in the size adjusting instruction.
Optionally, the data configuration interface includes a data table identifier selection list, a field input box, and a screening condition input box, the obtaining module 201 obtains data table information input by a user through the data configuration interface, and generates a query statement based on the data table information, specifically:
acquiring a data table identifier selected by a user through the data table identifier selection list, a field input through the field input box and a screening condition input through the screening condition input box;
and generating a query statement based on the obtained data table identification, the field and the screening condition.
Optionally, the data configuration interface includes a chart code editing area, and the obtaining module 201 obtains the chart configuration information input by the user through the data configuration interface, specifically:
obtaining a chart configuration code written by a user through the chart code editing area;
and taking the chart configuration code as chart configuration information.
Optionally, the data configuration interface further includes a chart type selection list and a chart parameter input box, and the obtaining module 201 obtains the chart configuration information input by the user through the data configuration interface, specifically:
obtaining the chart type selected by the user through the chart type selection list;
and obtaining the chart parameters input by the user through the chart parameter input box.
Optionally, the apparatus further includes a storage module, configured to:
and correspondingly storing the obtained data table information and the chart configuration information.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1, A method of data visualization, the method comprising:
obtaining a plurality of charts, determining each chart to be combined from the obtained charts, and performing combined display on each chart to be combined;
wherein each graph is obtained by:
acquiring an interface opening instruction, displaying a database connection interface, and acquiring connection information of a database to be connected, which is input by a user through the database connection interface; establishing connection with the database to be connected by using the connection information;
after the connection is successfully established, displaying a data configuration interface, acquiring data table information and chart configuration information input by a user through the data configuration interface, and generating a query statement based on the data table information; obtaining data to be displayed by utilizing the query statement;
rendering the chart configuration information and the data to be displayed to obtain a chart containing the data to be displayed.
2. The method of claim 1, wherein the chart configuration information comprises at least of a chart type, a color, a border, a position of the chart within the canvas, and a font.
3. The method of claim 1, wherein determining each chart to be combined from the obtained plurality of charts comprises:
and after the chart combination instruction is detected, displaying a chart combination configuration interface, acquiring a user selection instruction, and selecting each chart to be combined from the acquired plurality of charts according to the selection instruction.
4. The method according to claim 1, wherein after the combined display of the charts to be combined, the method further comprises:
and after the dragging instruction is detected, moving the position of the chart to be combined acted by the dragging instruction according to the direction of the dragging instruction.
5. The method according to claim 1, wherein after the combined display of the charts to be combined, the method further comprises:
and after a size adjusting instruction is detected, adjusting the size of the chart to be combined acted by the size adjusting instruction according to the size parameter in the size adjusting instruction.
6. The method of claim 1, wherein the data configuration interface comprises a data table identification selection list, a field input box and a filtering condition input box, and the obtaining data table information input by a user through the data configuration interface and generating a query statement based on the data table information comprises:
acquiring a data table identifier selected by a user through the data table identifier selection list, a field input through the field input box and a screening condition input through the screening condition input box;
and generating a query statement based on the obtained data table identification, the field and the screening condition.
7. The method of claim 1, wherein the data configuration interface comprises a chart code editing area, and obtaining the chart configuration information input by the user through the data configuration interface comprises:
obtaining a chart configuration code written by a user through the chart code editing area;
and taking the chart configuration code as chart configuration information.
8. The method of claim 7, wherein the data configuration interface further comprises a chart type selection list and a chart parameter input box, and obtaining the chart configuration information input by the user through the data configuration interface comprises:
obtaining the chart type selected by the user through the chart type selection list;
and obtaining the chart parameters input by the user through the chart parameter input box.
9. The method of claim 1, further comprising:
and correspondingly storing the obtained data table information and the chart configuration information.
10, A data visualization device, said device comprising:
the obtaining module is used for obtaining a plurality of charts and determining each chart to be combined from the obtained charts;
the display module is used for carrying out combined display on each chart to be combined;
wherein the obtaining module obtains each graph by:
acquiring an interface opening instruction, displaying a database connection interface, and acquiring connection information of a database to be connected, which is input by a user through the database connection interface; establishing connection with the database to be connected by using the connection information;
after the connection is successfully established, displaying a data configuration interface, acquiring data table information and chart configuration information input by a user through the data configuration interface, and generating a query statement based on the data table information; obtaining data to be displayed by utilizing the query statement;
rendering the chart configuration information and the data to be displayed to obtain a chart containing the data to be displayed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810805456.3A CN110737672A (en) | 2018-07-20 | 2018-07-20 | data visualization method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810805456.3A CN110737672A (en) | 2018-07-20 | 2018-07-20 | data visualization method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110737672A true CN110737672A (en) | 2020-01-31 |
Family
ID=69234794
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810805456.3A Pending CN110737672A (en) | 2018-07-20 | 2018-07-20 | data visualization method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110737672A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111309317A (en) * | 2020-02-09 | 2020-06-19 | 北京工业大学 | Code automation method and device for realizing data visualization |
| CN111722844A (en) * | 2020-05-29 | 2020-09-29 | 北京宝兰德软件股份有限公司 | Web-based dynamic rich text component design method and device |
| CN113190561A (en) * | 2021-05-24 | 2021-07-30 | 平安国际智慧城市科技股份有限公司 | Data list configuration method and device, electronic equipment and storage medium |
| CN113220386A (en) * | 2021-04-06 | 2021-08-06 | 北京健康之家科技有限公司 | Instrument board publishing method and related equipment |
| CN114443692A (en) * | 2022-02-15 | 2022-05-06 | 支付宝(杭州)信息技术有限公司 | Data query method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102292719A (en) * | 2009-01-21 | 2011-12-21 | 微软公司 | Extensibility for web based diagram visualization |
| CN107193951A (en) * | 2017-05-22 | 2017-09-22 | 环球智达科技（北京）有限公司 | WEB data visualization methods based on relational database |
| CN107193518A (en) * | 2017-05-23 | 2017-09-22 | 腾讯科技（深圳）有限公司 | The method and terminal device of a kind of presentation of information |
| CN108182063A (en) * | 2017-12-29 | 2018-06-19 | 福建南威软件有限公司 | A kind of implementation method of big data analysis visual configuration |
-
2018
- 2018-07-20 CN CN201810805456.3A patent/CN110737672A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102292719A (en) * | 2009-01-21 | 2011-12-21 | 微软公司 | Extensibility for web based diagram visualization |
| CN107193951A (en) * | 2017-05-22 | 2017-09-22 | 环球智达科技（北京）有限公司 | WEB data visualization methods based on relational database |
| CN107193518A (en) * | 2017-05-23 | 2017-09-22 | 腾讯科技（深圳）有限公司 | The method and terminal device of a kind of presentation of information |
| CN108182063A (en) * | 2017-12-29 | 2018-06-19 | 福建南威软件有限公司 | A kind of implementation method of big data analysis visual configuration |
Non-Patent Citations (1)
| Title |
|---|
| 佚名: "excel怎么合并合并两个折线图表", 《脚本之家》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111309317A (en) * | 2020-02-09 | 2020-06-19 | 北京工业大学 | Code automation method and device for realizing data visualization |
| CN111722844A (en) * | 2020-05-29 | 2020-09-29 | 北京宝兰德软件股份有限公司 | Web-based dynamic rich text component design method and device |
| CN111722844B (en) * | 2020-05-29 | 2024-05-03 | 北京宝兰德软件股份有限公司 | Design method and device of dynamic rich text component based on Web |
| CN113220386A (en) * | 2021-04-06 | 2021-08-06 | 北京健康之家科技有限公司 | Instrument board publishing method and related equipment |
| CN113190561A (en) * | 2021-05-24 | 2021-07-30 | 平安国际智慧城市科技股份有限公司 | Data list configuration method and device, electronic equipment and storage medium |
| CN114443692A (en) * | 2022-02-15 | 2022-05-06 | 支付宝(杭州)信息技术有限公司 | Data query method and device |
| CN114443692B (en) * | 2022-02-15 | 2023-08-04 | 支付宝(杭州)信息技术有限公司 | Data query method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110737672A (en) | data visualization method and device | |
| CN105373522B (en) | Gesture-based on-chart data screening | |
| US8994732B2 (en) | Integration of sketch-based interaction and computer data analysis | |
| JP6018045B2 (en) | Temporary formatting and graphing of selected data | |
| CN102915237B (en) | The method and system of rewrite data quality rule is required according to user application | |
| US20140040797A1 (en) | Widget processing method and apparatus, and mobile terminal | |
| CN105659221A (en) | Graphical user interface having enhanced tool for connecting components | |
| US20140232724A1 (en) | Moving visualizations between displays and contexts | |
| WO2023116216A1 (en) | Data visualization method and apparatus, and device and storage medium | |
| CN111782651A (en) | Visual editing method, device and equipment for data association relation and storage medium | |
| CN111291025B (en) | Method for supporting multi-physical model conversion by logic model and storage device | |
| CN112307109A (en) | Visual chart generation method and device, electronic equipment and storage medium | |
| EP3411811A1 (en) | Systems and methods for using entity/relationship model data to enhance user interface engine | |
| CN117057318A (en) | Domain model generation method, device, equipment and storage medium | |
| CN104951477B (en) | Method and apparatus for crossing filter data | |
| CN108874392A (en) | User's guideline interface generation method and device | |
| CN116466951A (en) | Data visualization large screen implementation method based on industrial algorithm model | |
| CN113656028A (en) | UI component code generation method, CRUD page generation method, device and equipment | |
| CN113407078A (en) | Method and device for editing character icon, storage medium and terminal | |
| CN112527747A (en) | Log template configuration and display method and device | |
| CN111061472A (en) | Method and system for generating visualized edited violin diagram | |
| US11811712B2 (en) | Conversational natural language interfaces for data analysis | |
| CN113704593B (en) | Operation data processing method and related device | |
| CN116991385A (en) | Data instrument panel construction method and device, electronic equipment and storage medium | |
| CN107239459B (en) | Entity contact diagram display method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200131 |
|
| RJ01 | Rejection of invention patent application after publication |