CN110083346B - Screening configuration method and device based on data visualization interface - Google Patents
Screening configuration method and device based on data visualization interface Download PDFInfo
- Publication number
- CN110083346B CN110083346B CN201810072121.5A CN201810072121A CN110083346B CN 110083346 B CN110083346 B CN 110083346B CN 201810072121 A CN201810072121 A CN 201810072121A CN 110083346 B CN110083346 B CN 110083346B
- Authority
- CN
- China
- Prior art keywords
- data
- visual
- screening
- block
- dimension
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000012216 screening Methods 0.000 title claims abstract description 139
- 238000013079 data visualisation Methods 0.000 title claims abstract description 49
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000000007 visual effect Effects 0.000 claims abstract description 173
- 238000001914 filtration Methods 0.000 claims description 71
- 238000012800 visualization Methods 0.000 description 37
- 238000010586 diagram Methods 0.000 description 15
- 230000008569 process Effects 0.000 description 9
- 238000005516 engineering process Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 235000019580 granularity Nutrition 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 229920001690 polydopamine Polymers 0.000 description 2
- 239000004984 smart glass Substances 0.000 description 2
- OKTJSMMVPCPJKN-UHFFFAOYSA-N Carbon Chemical compound [C] OKTJSMMVPCPJKN-UHFFFAOYSA-N 0.000 description 1
- 101000635799 Homo sapiens Run domain Beclin-1-interacting and cysteine-rich domain-containing protein Proteins 0.000 description 1
- 102100030852 Run domain Beclin-1-interacting and cysteine-rich domain-containing protein Human genes 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 229910021389 graphene Inorganic materials 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
One or more embodiments of the present disclosure provide a method and an apparatus for screening and configuring based on a data visualization interface, where the method may include: displaying a visual data display block and a visual screening block in a data visual interface, wherein the visual screening block is bound to any data set; when the data of the visual data display block is derived from any data set, automatically establishing a correlation between the visual data display block and the screening conditions in the visual screening block so that the display content of the visual data display block is linked with the screening result based on the screening conditions.
Description
Technical Field
One or more embodiments of the present disclosure relate to the field of data visualization technologies, and in particular, to a screening configuration method and apparatus based on a data visualization interface.
Background
The data visualization (Data visualization) may enable visual representation of the data by graphical means. For example, by representing each data item as a single primitive element, a large amount of data is formed into a data image, and each attribute value of the data is represented in the form of multi-dimensional data, so that the data can be observed from different dimensions, and further observation and analysis can be performed on the data.
Disclosure of Invention
In view of this, one or more embodiments of the present disclosure provide a method and apparatus for screening configuration based on a data visualization interface.
In order to achieve the above object, one or more embodiments of the present disclosure provide the following technical solutions:
according to a first aspect of one or more embodiments of the present disclosure, a screening configuration method based on a data visualization interface is provided, including:
displaying a visual data display block and a visual screening block in a data visual interface, wherein the visual screening block is bound to any data set;
when the data of the visual data display block is derived from any data set, automatically establishing a correlation between the visual data display block and the screening conditions in the visual screening block so that the display content of the visual data display block is linked with the screening result based on the screening conditions.
According to a second aspect of one or more embodiments of the present disclosure, there is provided a screening configuration apparatus based on a data visualization interface, including:
the block display unit displays a visual data display block and a visual screening block in the data visual interface, wherein the visual screening block is bound to any data set;
And when the data of the visual data display block is derived from any data set, the first association establishing unit automatically establishes association between the visual data display block and the screening conditions in the visual screening block so that the display content of the visual data display block is linked with the screening result based on the screening conditions.
Drawings
Fig. 1 is a schematic diagram of a data visualization system according to an exemplary embodiment.
Fig. 2 is a flowchart of a screening configuration method based on a data visualization interface according to an exemplary embodiment.
FIG. 3 is a schematic diagram of a data visualization interface provided by an exemplary embodiment.
Fig. 4 is a schematic diagram of creating a visual data presentation tile provided by an exemplary embodiment.
Fig. 5 is a schematic diagram of creating a visualization filtering tile, provided by an exemplary embodiment.
Fig. 6 is a schematic diagram of a configuration visualization filtering block according to an exemplary embodiment.
Fig. 7 is a schematic diagram of a method for establishing non-homologous associations provided in an exemplary embodiment.
Fig. 8 is a schematic diagram of an apparatus according to an exemplary embodiment.
Fig. 9 is a block diagram of a screening configuration apparatus based on a data visualization interface according to an exemplary embodiment.
Detailed Description
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with one or more embodiments of the present specification. Rather, they are merely examples of apparatus and methods consistent with aspects of one or more embodiments of the present description as detailed in the accompanying claims.
It should be noted that: in other embodiments, the steps of the corresponding method are not necessarily performed in the order shown and described in this specification. In some other embodiments, the method may include more or fewer steps than described in this specification. Furthermore, individual steps described in this specification, in other embodiments, may be described as being split into multiple steps; while various steps described in this specification may be combined into a single step in other embodiments.
In an embodiment, the screening configuration scheme based on the data visualization interface of the present disclosure may be applied to an electronic device, for example, the electronic device may include a mobile phone, a PC, a tablet device, a notebook computer, a palm computer (PDAs, personal Digital Assistants), a wearable device (such as smart glasses, smart watches, etc.), and the present disclosure is not limited thereto. In the operation process, the electronic equipment can operate a data visualization system, and a screening configuration scheme based on a data visualization interface of the specification is completed based on the data visualization system. Wherein the application of the data visualization system may be pre-installed on the electronic device such that the data visualization system may be started and run on the electronic device.
In one embodiment, the data visualization system may include a server 11, a network 12, and an electronic device 13 as shown in FIG. 1. In the running process, the server 11 may run a program on the server side of the data visualization system to implement related functions such as processing; in the operation process of the electronic device 13, a program on the client side of the data visualization system can be operated to realize related functions such as display, man-machine interaction and the like, so that the data visualization system is realized by cooperation between the server 11 and the electronic device 13.
The server 11 may be a physical server including a separate host, or the server 11 may be a virtual server carried by a host cluster. The electronic device 13 may employ any of the following types of devices: cell phones, PCs, tablet devices, notebook computers, palm top computers (PDAs, personal Digital Assistants), wearable devices (e.g., smart glasses, smart watches, etc.), etc., without limitation to one or more embodiments of the present disclosure. And the network 12 for interaction between the electronic device 13 and the server 11 may comprise various types of wired or wireless networks. In one embodiment, the network 12 may include a public switched telephone network (Public Switched Telephone Network, PSTN) and the internet.
It should be noted that: a program on a client side of the data visualization system may be pre-installed on the electronic device so that the client may be started and run on the electronic device; of course, when an online "client" such as HTML5 technology is employed, the client can be obtained and run without installing a corresponding program on the electronic device.
Fig. 2 is a flowchart of a screening configuration method based on a data visualization interface according to an exemplary embodiment. As shown in fig. 2, the method may include the steps of:
Step 202, a visualization data presentation block and a visualization screening block are presented in a data visualization interface, the visualization screening block being bound to any one data set.
In one embodiment, one or more visual data presentation tiles may be included in the data visualization interface, which is not limited in this disclosure. The visualized data displaying block may include any type, such as a bar graph, a bubble graph, a water level graph, a pie chart, a radar graph, a table, etc., which is not limited in this specification.
In an embodiment, the visualization filtering block may be pre-bound to one or more data sets, e.g., the binding may be default configuration information, or the binding may be user pre-configured information.
In an embodiment, a user may manually configure one or more data sets of the visualization filtering tile binding. For example, an alternative data set may be presented in the data visualization interface, which may include at least one of: as a data set of a data source of the visualized data display block displayed in the data visualization interface, a preset data set, etc., the specification is not limited thereto; the visualization filtering block may then be bound to the selected candidate data set according to the received data set selection instruction.
Step 204, when the data of the visual data display block is derived from the arbitrary data set, automatically establishing a correlation between the visual data display block and the screening condition in the visual screening block, so that the display content of the visual data display block is linked with the screening result based on the screening condition.
In an embodiment, the visualization data presentation block is configured to perform visualization presentation of some or all of the data in the data set, where the data may be sequentially grouped or sorted according to the data presentation dimensions defined in the visualization data presentation block. For example, when the data to be displayed in the data set is attendance data of an enterprise employee, if the data display dimension selected by the visual data display block is a time dimension, the attendance data may be displayed in groups according to days (assuming that the selected display granularity is "day", other display granularities such as week, month and the like may be adopted in other cases of course), and if the data display dimension selected by the visual data display block is a department, the attendance data may be displayed in groups according to the department.
In an embodiment, a data dimension of a visual data display block included in the selected candidate data set and applied to the display in the data visual interface may be displayed, and the selected data dimension may be configured as a filtering condition in the visual filtering block according to the received first dimension selection instruction. For example, when the data dimensions adopted by the visual data display block include a time dimension, a name dimension, a geographic position dimension, and the like, the data dimensions can be displayed, selected by a user and configured as screening conditions; wherein, for example, when the time dimension is configured as a filtering condition, a time period of interest can be set by a user in the visual filtering block for the corresponding filtering condition, so that the data belonging to the time period is displayed in the visual data display block (displayed based on the visual form).
In an embodiment, the filtering condition in the visual filtering block may be a preset dimension, such as a default dimension or a dimension predefined by a user. In one case, the predetermined dimension is not replaceable; in another case, the user can replace the preset dimension according to the actual situation.
In an embodiment, a data presentation dimension of the visual data presentation block and a data screening dimension of the visual screening block as a screening condition may be determined; when the data display dimension comprises the data screening dimension, a correlation can be automatically established between the visual data display block and the screening condition, so that the screening result based on the screening condition can influence the display content of the visual data display block, and linkage between the visual data display block and the screening condition is realized.
In an embodiment, by binding the data set for the visual filtering block and setting the data filtering condition related to the data set, the association between the visual data display block and the visual filtering block can be automatically established under the condition that the data filtering condition is consistent with the data display dimension of the visual data display block, and the association is not required to be manually established one by a user, so that the user operation is greatly simplified, and the configuration efficiency of the visual filtering block is improved.
In an embodiment, in the data visualization interface, an automatically established association between the visualized data display block and the screening condition may be displayed; then, according to the received association releasing instruction, the association relation between the visual data display block and the screening condition is released, so that a user can select whether to associate the visual data display block with the visual screening block according to the requirement, for example, the user can only link with the screening result of the visual screening block in part of the visual data display blocks.
In an embodiment, when the data of the visual data display block is derived from the other data set except for the any data set, the data display dimension of the visual data display block can be displayed on the data visual interface; and then, according to the received second dimension selection instruction, establishing a correlation between the selected data display dimension and the screening condition, so that when the other data sets are screened based on the data screening dimension, the display content in the selected data display dimension is linked with the screening result. Then, even when the visualized data display blocks in the data visualization interface are derived from a plurality of data sets, the association between the visualized filter blocks and the visualized data display blocks can be simply established, so that linkage between the visualized filter blocks and the visualized data display blocks derived from different data sets is realized.
In an embodiment, the condition value of the screening condition configuration may be determined according to the received condition configuration instruction; and then, screening the data set serving as the data source of the visual data display block according to the data display dimension and the condition value, so that the display content of the visual data display block is linked with the screening result. For example, when the data filtering dimension used as the filtering condition is a time dimension, the condition value can be one or more time periods in the time dimension, and the visualized data displaying block can be used for filtering and displaying the data of the one or more time periods; for another example, when the data filtering dimension as the filtering condition is a department dimension, the condition value may be one or more departments in the department dimension, and the visualized data displaying block may screen and display the data of the one or more departments.
For ease of understanding, the presentation scheme of the present specification is described below in connection with the presentation process of data visualization. FIG. 3 is a schematic diagram of a data visualization interface provided by an exemplary embodiment; as shown in fig. 3, the data visualization interface 300 may include a configuration dashboard area 302, a dataset area 304, and a visualization presentation area 306. Dashboard area 302 is configured to provide templates of data charts, controls, etc. (which may be presented in the form of rectangular tiles as shown in FIG. 3) for a user to generate a corresponding data chart or control type of visualization tile by dragging the template to visualization presentation area 306. For example, when the data visualization system detects that a user drags a template in a data diagram to the visual presentation area 306 in the form shown in FIG. 3, a corresponding visual tile may be generated at the visual presentation area 306.
Fig. 4 is a schematic diagram of creating a visual data presentation tile provided by an exemplary embodiment. Assuming that the user configures the templates of the data chart types in the dashboard area 302 by dragging several times, a plurality of visual data display blocks such as "pie chart-111", "cross-table-sql", "line chart-sql", "histogram-321" and the like shown in fig. 4 are created in the visual display area 306, wherein the visual data display block "pie chart-111" adopts a data chart of the "pie chart" type, the visual data display block "cross-table-sql" adopts a data chart of the "cross-table" type, the visual data display block "line chart-sql" adopts a data chart of the "line chart" type, and the visual data display block "histogram-321" adopts a data chart of the "histogram" type.
When dragging a template of a data chart type from the configuration dashboard area 302 to the visual presentation area 306, the created visual data tile initially contains no data, or only default data, and cannot be used for the data desired to be presented to the user, who is required to configure the associated data set and data presentation dimensions for that visual data tile. For example, in the data visualization interface 300 shown in fig. 3-4, an optional dataset, dimensions of data within the dataset, etc., may be presented in the dataset region 304, such as several dimensions of datasets "AAAA" and "report_date", "customer_name" are shown in fig. 3-4 (the dimensions are also fields that the data within the dataset contains).
In one embodiment, the user may select a created visual data tile in the desired visual presentation area 306 and select an associated data presentation dimension in the data set "AAAA" presented in the data set area 304, such as selecting the fields "date_week", "order_number" of the data set "AAAA" for "pie chart-111" as the data presentation dimension of the "pie chart-111". Similarly, the fields "date_week", "customer_name", etc. of the dataset "AAAA" may be selected for the "cross-table-sql" as the data presentation dimension of the "cross-table-sql", and the fields "date_week", "order_number_sum" of the dataset "AAAA" may be selected for the "histogram-321" as the data presentation dimension of the "histogram-321".
In one embodiment, there may be multiple data sets. The user may flip up or down by triggering the "︿" flag to the right of the dataset "AAAA" as shown in fig. 3-4 or "﹀" flag to view other datasets present and their related information. For example, the user may select the fields "18str", "price" etc. of the data set "BBBBBB" for "line drawing-sql" as the data presentation dimension of the "line drawing-sql".
Fig. 5 is a schematic diagram of creating a visualization filtering tile, provided by an exemplary embodiment. Similar to the visualization data tile described above, when it is detected that the user drags the control template in the configuration dashboard area 302 to the visualization presentation area 306, a corresponding control may be created in the visualization presentation area 306, such as when the control is a screening control, a visualization screening tile 308 as shown in fig. 5 may be created.
When the visual filtering block 308 is selected, the configuration dashboard area 302 may show a "data/style" tab page as shown in FIG. 5, for the user to configure the visual filtering block 308. Wherein, when selecting the "style" tab page, the display style of the visual filtering block 308 may be edited; when the "data" tab page is selected, the visualization filtering block 308 may be functionally configured. For example, as shown in FIG. 5, including a "source dataset" configuration option in the "data" tab page may select an associated dataset for the visualization filtering block 308 and configure the fields contained in the dataset as filtering conditions associated with the visualization filtering block 308. In one embodiment, assume that the user selects "source dataset" as dataset "AAAA" and the fields contained in dataset "AAAA" may be shown in the "data" tab page for selection by the user.
Fig. 6 is a schematic diagram of a configuration visualization filtering block according to an exemplary embodiment. When it is detected that the user selects fields such as "date_week" and "customer_name" included in the data set "AAAA" in the "data" tab page, it may be determined that the user associates the visual filtering block 308 with the data set "AAAA" and configures the selected fields as filtering conditions of the visual filtering block 308, so as to create visual condition configuration sub-blocks corresponding to the respective filtering conditions in the visual filtering block 308; for example, when the selected fields include "date_week" and "customer_name", a sub-block 61 corresponding to "date_week" and a sub-block 62 corresponding to "customer_name" may be generated in the visualization filtering block 308.
In one embodiment, the meaning of the field "date_week" expression is: the data in the data set "AAAA" is grouped or classified in units of "week (week)", i.e., the field "date_week" is used to implement data grouping or classification in the time dimension, and the granularity of grouping or classification is "week". Thus, in the corresponding sub-block 61 in the visual filtering block 308, when the field "date_week" is used as a filtering condition, the user may set a value for the filtering condition, including a start time and an end time, for example, the start time is "2015-28 weeks" and the end time is "2017-44 weeks" set in fig. 6, which indicate a period from the 28 th week in 2015 to the 44 th week in 2017.
In one embodiment, the meaning of the field "customer_name" expression is: the customer's name is used to group or sort the data in the dataset "AAAA" according to the customer's name. Thus, in the corresponding sub-block 62 in the visual filtering block 308, when the field "customer_name" is used as the filtering condition, the user may set a value for the filtering condition, such as "alice", "Ai Meifang", "baron" and the like shown in fig. 6, that is, the condition set by the user for the filtering condition.
Before the screening operation has been performed based on the visualization screening block 308, the visualization data presentation block in the visualization presentation area 306, such as "pie-111," "cross-table-sql," "line-sql," "histogram-321," etc., may present all relevant data in the associated dataset (related to the data presentation dimensions of the visualization data presentation block), such as "pie-111," "cross-table-sql," "histogram-321," etc., associated with the dataset "AAAA," may present the data in the dataset "AAAA," while "line-sql" etc., associated with the dataset "BBBB," may present the data in the dataset "BBBB" visually.
And based on the visual screening block 308, the visual data display blocks such as "pie chart-111", "cross table-sql", "line chart-sql", "histogram-321" in the visual display area 306 can be displayed in a linkage manner. Wherein prior to linkage, a visual filtering block 308 is further associated with each visual data display block to determine the fields in each visual data display block for which linkage is to be performed.
As shown in fig. 6, after the visual filtering section 308 establishes an association with the dataset "AAAA" and sets several fields in the dataset "AAAA" as filtering conditions, the configuration dashboard display area 302 may display a "homologous association/non-homologous association" tab page for associating with each visual data display section in the visual filtering section 308 and the visual display area 306. Since the visualization screening area 308 is associated with the dataset "AAAA", and each visualization data presentation area is associated with the presence of an associated dataset, there may be two scenarios: in the first case, "pie chart-111", "cross-table-sql", "histogram-321", etc. are associated with the dataset "AAAA", i.e. these visualized data presentation blocks are associated with the same dataset as the visualized screening block 308, so that the association between the visualized screening block 308 and these visualized data presentation blocks belongs to a "homologous association"; in the second case, "line graph-sql" etc. is associated with the dataset "BBBB", i.e. these visualized data presentation blocks are associated with the visualized filter block 308 to different datasets, so that the association between the visualized filter block 308 and these visualized data presentation blocks belongs to a "non-homologous association".
In the context of homography, since the visual filtering block 308 is associated with the visual data presentation blocks such as "pie chart-111", "cross-table-sql", "histogram-321", etc. to the dataset "AAAA", the association can be automatically established between the visual filtering block 308 and the visual data presentation blocks such as "pie chart-111", "cross-table-sql", "histogram-321", etc. according to the fields selected by the visual filtering block 308 in the dataset "AAAA" (these fields are applied as filtering conditions and may also be referred to as data filtering dimensions) and the fields employed by the respective visual data presentation blocks (these fields are applied as data presentation dimensions). For example, when the visualization filtering block 308 takes the field "date_week", "customer_name" as a filtering condition, if "pie chart-111", "cross table-sql", "histogram-321", etc. takes the field "date_week" as a data presentation dimension, "cross table-sql" etc. takes the field "customer_name" as a data presentation dimension, an association may be automatically established between the sub-block 61 (corresponding to the field "date_week") in the visualization filtering block 308 and the visualized data presentation blocks such as "pie chart-111", "cross table-sql", "histogram-321", etc. and between the sub-block 62 (corresponding to the field "customer_name") in the visualization filtering block 308 and the visualized data presentation blocks such as "cross table-sql".
The association between the fields "date_week" and "customer_name" and each visualized data display block may be shown in the "homologous association" tab page as shown in fig. 6, taking the field "date_week" as an example: three objects, namely "chart-pie-111", "chart-cross-table-sql", "chart-bar-321", are arranged below "source field-date_week", and the option icon "≡" on the left side of each object is shown as "≡" (i.e., selected) ", indicating that an association is established between the field" date_week "of the visualization screening block 308 and the visualization data presentation blocks, such as" pie-111 "," cross-table-sql "," bar-321 ". Of course, the user may cancel the "v" identifier by triggering the option icon "≡" corresponding to any one object, so as to cancel the association between the field "date_week" of the visual filtering block 308 and the corresponding visual data presentation block.
In a non-homologous scenario, an association may be established between the visualization screening block 308 and the visualization data presentation block based on user operations. For example, FIG. 7 is a schematic diagram of one type of establishment of non-homologous association provided by an exemplary embodiment. For the fields "date_week" and "customer_name" as filtering conditions in the visual filtering block 308, the non-homologous visual data displaying block and the fields contained in the non-homologous visual data displaying block can be displayed in the non-homologous association tag page as shown in fig. 7, so that a user can manually select and establish association. In the "non-homologous association" tab page as shown in FIG. 7, the field "date_week" is still taken as an example: under the "source field-date_week", there is shown a "line graph-sql" (corresponding to a non-homologous visual data display block "line graph-sql"), and under the "line graph-sql", there are further shown data display dimensions "18str", "price", etc. employed by the visual data display block "line graph-sql". Corresponding option icons "≡" are arranged on the left sides of the data display dimensions "18str" and "price", when triggering operation of the option icon corresponding to any one data display dimension is detected, association can be established between the any one data display dimension and the sub-region 61 (corresponding to the field "date_week") in the visual filtering block 308, and the "≡" mark can be displayed in the corresponding option icon "≡" to indicate that association is established; of course, the user may trigger the option icon "ζ" to display a "ζ" identifier, so as to cancel the "ζ" identifier and cancel the corresponding association relationship.
Based on the association relationship established between the visual screening block 308 and each visual data display block, the visual screening block 308 can perform data screening, so as to link the display content of the visual data display block. For example, when the filtering conditions in the visual filtering block 308 take the values of the conditions shown in fig. 7, i.e., the field "date_week" takes the values of "2015-28 weeks-2017-44 weeks" and the field "customer_name" takes the values of "alice, ai Meifang, barg … …", the following operations may be performed:
for the data set "AAAA", the data with the field "date_week" conforming to the value of "2015-28 weeks-2017-44 weeks" and the field "customer_name" conforming to the value of "alice, ai Meifang, and brown … …" can be screened out from the data set "AAAA", so that the visual data display blocks such as "pie chart-111", "cross table-sql", "histogram-321" can only visually display the screened data. For the data set "BBBB", assuming that the field "date_week" is associated with the field "18str" in the "line graph-sql", data meeting the values of "2015-28 weeks-2017-44 weeks" under the field "18str" can be screened out in the data set "BBBBBB", so that the visualized data display blocks such as the "line graph-sql" only perform visualized display on the screened data.
It should be noted that: because the field as the screening condition belongs to a specific data screening dimension, for example, the field "date_week" belongs to a time dimension and the field "customer_name" belongs to a name dimension, under the scenario of non-homologous association, a user may associate fields of other dimensions to the screening condition in the process of manual association, so that the association relationship cannot correctly realize data screening of a non-homologous data set, and the corresponding visualized data display blocks cannot correctly realize linkage. Thus, in the "non-homologous association" tab page, only fields belonging to the same dimension as the filtering condition, fields of different dimensions are hidden, such as when field "18str" belongs to the time dimension and field "price" belongs to the price dimension, only field "18str" and hidden field "price" may be shown for "source field-date_week", thereby avoiding that the user establishes an association between fields of different dimensions.
Fig. 8 is a schematic block diagram of an apparatus according to an exemplary embodiment. Referring to fig. 8, at the hardware level, the device includes a processor 802, an internal bus 804, a network interface 806, a memory 808, and a non-volatile storage 810, although other hardware required by the service is also possible. The processor 802 reads the corresponding computer program from the nonvolatile memory 810 into the memory 808 and then runs to form a screening configuration apparatus based on the data visualization interface at the logic level. Of course, in addition to software implementation, one or more embodiments of the present disclosure do not exclude other implementation manners, such as a logic device or a combination of software and hardware, etc., that is, the execution subject of the following processing flow is not limited to each logic unit, but may also be hardware or a logic device.
Referring to fig. 9, in a software implementation, the screening configuration apparatus based on the data visualization interface may include:
the block display unit 901 displays a visual data display block and a visual screening block in a data visual interface, wherein the visual screening block is bound to any data set;
and a first association establishing unit 902, configured to automatically establish an association between the visualized data display block and the screening condition in the visualized screening block when the data of the visualized data display block is derived from the arbitrary data set, so that the display content of the visualized data display block is linked with the screening result based on the screening condition.
Optionally, the method further comprises:
CZ1716527
a data set presenting unit 903 for presenting an alternative data set in the data visualization interface, the alternative data set comprising at least one of the following: the data set is used as a data source of a visual data display block displayed in the data visual interface and a preset data set;
and a binding unit 904 for binding the visual filtering block to the selected alternative data set according to the received data set selection instruction.
Optionally, the method further comprises:
A first dimension display unit 905 for displaying the data dimension of the visualized data display block included in the selected candidate data set and applied to the data visualization interface;
the condition configuration unit 906 configures the selected data dimension as the filtering condition in the visual filtering block according to the received first dimension selection instruction.
Optionally, the first association unit 902 is specifically configured to:
determining the data display dimension of the visual data display block and the data screening dimension serving as a screening condition in the visual screening block;
when the data presentation dimension includes the data screening dimension, an association is automatically established between the visualized data presentation block and the screening condition.
Optionally, the method further comprises:
an association display unit 907 for displaying, in the data visualization interface, an automatically established association between the visualized data display block and the screening condition;
and a de-association unit 908 for de-associating the visualized data display block with the filtering condition according to the received de-association instruction.
Optionally, the method further comprises:
a second dimension display unit 909 that displays, when the data of the visualized data display block originate from a data set other than the arbitrary data set, a data display dimension of the visualized data display block at the data visualization interface;
And a second association establishing unit 910, configured to establish an association between the selected data display dimension and the screening condition according to the received second dimension selection instruction, so that when the other data sets are screened based on the data screening dimension, the display content in the selected data display dimension is linked with the screening result.
Optionally, the method further comprises:
a value determining unit 911 for determining a condition value for the filtering condition configuration according to the received condition configuration instruction;
and the screening unit 912 is used for screening the data set serving as the data source of the visual data display block according to the data display dimension and the condition value, so that the display content of the visual data display block is linked with the screening result.
The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. A typical implementation device is a computer, which may be in the form of a personal computer, laptop computer, cellular telephone, camera phone, smart phone, personal digital assistant, media player, navigation device, email device, game console, tablet computer, wearable device, or a combination of any of these devices.
In a typical configuration, a computer includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, read only compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic disk storage, quantum memory, graphene-based storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by the computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing describes specific embodiments of the present disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
The terminology used in the one or more embodiments of the specification is for the purpose of describing particular embodiments only and is not intended to be limiting of the one or more embodiments of the specification. As used in this specification, one or more embodiments and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any or all possible combinations of one or more of the associated listed items.
It should be understood that although the terms first, second, third, etc. may be used in one or more embodiments of the present description to describe various information, these information should not be limited to these terms. These terms are only used to distinguish one type of information from another. For example, first information may also be referred to as second information, and similarly, second information may also be referred to as first information, without departing from the scope of one or more embodiments of the present description. The word "if" as used herein may be interpreted as "at … …" or "at … …" or "responsive to a determination", depending on the context.
The foregoing description of the preferred embodiment(s) is (are) merely intended to illustrate the embodiment(s) of the present invention, and it is not intended to limit the embodiment(s) of the present invention to the particular embodiment(s) described.
Claims (12)
1. The screening configuration method based on the data visualization interface is characterized by comprising the following steps of:
displaying a visual data display block and a visual screening block in a data visual interface, wherein the visual screening block is bound to any data set;
when the data of the visual data display block is derived from any data set, automatically establishing a correlation between the visual data display block and the screening conditions in the visual screening block so as to enable the display content of the visual data display block to be linked with the screening result based on the screening conditions;
when the data of the visual data display block is derived from other data sets except any data set, displaying the data display dimension of the visual data display block on the data visual interface;
And establishing a correlation between the selected data display dimension and the screening condition according to the received second dimension selection instruction, so that when the other data sets are screened based on the data screening dimension, the display content in the selected data display dimension is linked with the screening result.
2. The method as recited in claim 1, further comprising:
presenting an alternative data set in the data visualization interface, the alternative data set comprising at least one of: the data set is used as a data source of a visual data display block displayed in the data visual interface and a preset data set;
and binding the visual filtering block to the selected alternative data set according to the received data set selection instruction.
3. The method as recited in claim 2, further comprising:
displaying the data dimension of a visual data display block which is contained in the selected alternative data set and is applied to the visual data display block displayed in the data visual interface;
and configuring the selected data dimension as the screening condition in the visual screening block according to the received first dimension selection instruction.
4. The method of claim 1, wherein the automatically establishing an association between the visual data presentation block and the screening conditions in the visual screening block comprises:
determining the data display dimension of the visual data display block and the data screening dimension serving as a screening condition in the visual screening block;
when the data presentation dimension includes the data screening dimension, an association is automatically established between the visualized data presentation block and the screening condition.
5. The method as recited in claim 1, further comprising:
displaying the automatically established association between the visualized data display block and the screening condition in the data visualization interface;
and according to the received association releasing instruction, releasing the association relationship between the visualized data display block and the screening condition.
6. The method of any one of claims 1-5, further comprising:
determining a condition value of the screening condition configuration according to the received condition configuration instruction;
and screening the data set serving as the data source of the visual data display block according to the data display dimension and the condition value, so that the display content of the visual data display block is linked with the screening result.
7. A screening configuration device based on a data visualization interface, comprising:
the block display unit displays a visual data display block and a visual screening block in the data visual interface, wherein the visual screening block is bound to any data set;
the first association establishing unit automatically establishes association between the visual data display block and screening conditions in the visual screening block when the data of the visual data display block are derived from any data set, so that the display content of the visual data display block is linked with the screening result based on the screening conditions;
the second dimension display unit displays the data display dimension of the visual data display block on the data visual interface when the data of the visual data display block is derived from other data sets except any data set;
and the second association establishing unit establishes association between the selected data display dimension and the screening condition according to the received second dimension selection instruction, so that when the other data sets are screened based on the data screening dimension, the display content under the selected data display dimension is linked with the screening result.
8. The apparatus as recited in claim 7, further comprising:
a data set displaying unit for displaying an alternative data set in the data visualization interface, wherein the alternative data set comprises at least one of the following: the data set is used as a data source of a visual data display block displayed in the data visual interface and a preset data set;
and the binding unit binds the visual filtering block to the selected alternative data set according to the received data set selection instruction.
9. The apparatus as recited in claim 8, further comprising:
the first dimension display unit displays the data dimension of the visual data display block which is contained in the selected alternative data set and is applied to the data visual interface;
and the condition configuration unit configures the selected data dimension as the screening condition in the visual screening block according to the received first dimension selection instruction.
10. The apparatus according to claim 7, wherein the first association unit is specifically configured to:
determining the data display dimension of the visual data display block and the data screening dimension serving as a screening condition in the visual screening block;
When the data presentation dimension includes the data screening dimension, an association is automatically established between the visualized data presentation block and the screening condition.
11. The apparatus as recited in claim 7, further comprising:
the association display unit displays the association automatically established between the visualized data display block and the screening condition in the data visualization interface;
and the association canceling unit cancels the association relation between the visual data display block and the screening condition according to the received association canceling instruction.
12. The apparatus according to any one of claims 7-11, further comprising:
the value determining unit is used for determining the condition value of the screening condition configuration according to the received condition configuration instruction;
and the screening unit screens the data set serving as the data source of the visual data display block according to the data display dimension and the condition value, so that the display content of the visual data display block is linked with the screening result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810072121.5A CN110083346B (en) | 2018-01-25 | 2018-01-25 | Screening configuration method and device based on data visualization interface |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810072121.5A CN110083346B (en) | 2018-01-25 | 2018-01-25 | Screening configuration method and device based on data visualization interface |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110083346A CN110083346A (en) | 2019-08-02 |
| CN110083346B true CN110083346B (en) | 2023-10-24 |
Family
ID=67411932
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810072121.5A Active CN110083346B (en) | 2018-01-25 | 2018-01-25 | Screening configuration method and device based on data visualization interface |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110083346B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110717083A (en) * | 2019-10-12 | 2020-01-21 | 北京明略软件系统有限公司 | Visualization method, realization device and storage medium of multi-dimensional data |
| CN111596989B (en) * | 2020-04-28 | 2024-03-29 | 西安震有信通科技有限公司 | Histogram display method, terminal and storage medium |
| CN112084252A (en) * | 2020-08-25 | 2020-12-15 | 北京金堤征信服务有限公司 | Multi-data linkage interaction method and device |
| CN113704288A (en) * | 2021-02-26 | 2021-11-26 | 腾讯科技（深圳）有限公司 | Data display method and device, computer readable medium and electronic equipment |
| CN113064926B (en) * | 2021-03-16 | 2022-12-30 | 青岛海尔科技有限公司 | Data screening method and device, storage medium and electronic device |
| CN113220386A (en) * | 2021-04-06 | 2021-08-06 | 北京健康之家科技有限公司 | Instrument board publishing method and related equipment |
| CN115268901A (en) * | 2021-04-29 | 2022-11-01 | 广东利元亨智能装备股份有限公司 | Kanban generation method, apparatus, device and storage medium |
| CN114416861A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Pie chart-based data visualization method, device, and computer-readable storage medium |
| CN118103812A (en) * | 2022-09-28 | 2024-05-28 | 京东方科技集团股份有限公司 | Method and device for determining electronic billboard |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105488045A (en) * | 2014-09-16 | 2016-04-13 | 中兴通讯股份有限公司 | Data display method and device |
| CN106371814A (en) * | 2015-07-23 | 2017-02-01 | 微软技术许可有限责任公司 | User interface tool for visible exploration of multi-dimensional data |
| CN107450917A (en) * | 2017-07-21 | 2017-12-08 | 浙江华坤道威数据科技有限公司 | A kind of quick framework method in front end and its system |
-
2018
- 2018-01-25 CN CN201810072121.5A patent/CN110083346B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN110083346A (en) | 2019-08-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110083346B (en) | Screening configuration method and device based on data visualization interface | |
| US12008008B2 (en) | Contextual data visualization | |
| US11301623B2 (en) | Digital processing systems and methods for hybrid scaling/snap zoom function in table views of collaborative work systems | |
| US12056666B2 (en) | Collaborative due diligence review system | |
| US9760273B2 (en) | Overview axis having a different graph element type | |
| US9696967B2 (en) | Generation of an application from data | |
| CN105989082B (en) | Tabular views generation method and device | |
| US20130191767A1 (en) | Semantic Zooming of Data Object Representations in a User Interface | |
| WO2015196008A1 (en) | Event visualization on calendar with timeline | |
| CN113011400A (en) | Automatic identification and insight of data | |
| CN104111769B (en) | The display methods and device of a kind of electronic file binder | |
| CN112559576A (en) | Data display method, system, device, storage medium and electronic equipment | |
| US20190147032A1 (en) | Data flow view for a spreadsheet | |
| US9608869B2 (en) | Enterprise applications navigation using tile characteristics that change with applications data | |
| CN108089858B (en) | Method and device for creating visual interface | |
| CN112132654A (en) | Method, device and storage medium for displaying house source information | |
| US8856126B2 (en) | Simplifying grouping of data items stored in a database | |
| CN112748917B (en) | Graph display method and device | |
| CN108279962B (en) | Method and device for creating visual data display interface | |
| CN110147183B (en) | Data screening method and device | |
| US10387465B2 (en) | Display of relevant information from multiple data sources | |
| JP2019113965A (en) | Financing management device, financing management method, and financing management program | |
| HK40010989A (en) | Screening configuration method and device based on data visualization interface | |
| CN113435847A (en) | Information display method and device, electronic equipment and storage medium | |
| JP6499044B2 (en) | Task management apparatus, task management method, task management program, and user interface providing method |
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 | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 40010989 Country of ref document: HK |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |