Differential data task billboard method and device, electronic equipment and storage medium

Abstract

The invention provides a difference data task billboard method and device, electronic equipment and a storage medium, and relates to the technical field of computers. The difference data task billboard method comprises the following steps: in response to an operation of configuring parameters of to-be-displayed billboard data through a visual interface, obtaining the parameters of the to-be-displayed billboard data; in response to a display instruction for the to-be-displayed Kanban data, determining the to-be-displayed Kanban data based on the parameters of the to-be-displayed Kanban data; and displaying the to-be-displayed billboard data by using the visual interface. According to the method, the billboard task of the difference data can be efficiently established, and the timeliness and the operation efficiency of a development project are effectively improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular, to a method, apparatus, electronic device, and storage medium for a differential data task dashboard. Background Art

[0002] During the development of major projects, a dedicated data difference dashboard page needs to be constructed for each business going live to monitor and display the difference status of business data.

[0003] In the related art, the construction process of the dashboard needs to be completed by backend developers writing code. The developers need to clearly specify the business difference data tables to be queried, obtain the difference data according to specific business requirements, and perform data comparison and analysis on the fields to be compared. This process not only takes a long time but also requires a large amount of development and testing resources. Each time a dashboard task is constructed, a scheduling plan needs to be made, which is particularly inconvenient when business requirements are urgent and affects the development progress of the project. In addition, since a separate dashboard needs to be constructed for each business going live, it is particularly cumbersome and inefficient when dealing with multiple businesses going live simultaneously.

[0004] Therefore, how to efficiently build a dashboard task for differential data to improve the timeliness and operation efficiency of the development project is a technical problem to be solved urgently. Summary of the Invention

[0005] In view of the above problems existing in the prior art, the present invention provides a method, apparatus, electronic device, and storage medium for a differential data task dashboard to efficiently build a dashboard task for differential data and improve the timeliness and operation efficiency of the development project.

[0006] The present invention provides a method for a differential data task dashboard, including the following steps.

[0007] In response to an operation of configuring parameters of the dashboard data to be displayed through a visual interface, determine the parameters of the dashboard data to be displayed; in response to a display instruction for the dashboard data to be displayed, based on the parameters of the dashboard data to be displayed, determine the dashboard data to be displayed; and use the visual interface to display the dashboard data to be displayed.

[0008] A method for a differential data task dashboard according to the present invention, wherein the dashboard data to be displayed is integrated data obtained by processing fields in a business data table using specified aggregation conditions; the determining of the parameters of the dashboard data to be displayed in response to an operation of configuring the parameters of the dashboard data to be displayed through a visual interface includes: in response to receiving a query instruction carrying the identification information of the business data table and the information of the grouping fields for the business data table from the visual interface, obtaining the identification information of the fields in the business data table grouped according to the grouping fields from a target database; wherein the aggregation condition is a condition or rule for performing aggregation processing on the fields; through the visual interface, displaying the identification information of the fields and various selectable aggregation conditions; in response to receiving, from the visual interface, the identification information of the fields to be displayed determined from the identification information of the fields and the target aggregation condition selected based on the various selectable aggregation conditions, taking the identification information of the fields to be displayed and the target aggregation condition as the parameters of the dashboard data to be displayed.

[0009] A method for a differential data task dashboard according to the present invention, the determining of the dashboard data to be displayed in response to a display instruction for the dashboard data to be displayed based on the parameters of the dashboard data to be displayed includes: in response to a display instruction for the dashboard data to be displayed, obtaining the content of the fields to be displayed from the target database based on the identification information of the fields to be displayed; and processing the content of the fields to be displayed based on the aggregation condition to obtain the dashboard data to be displayed.

[0010] A method for a differential data task dashboard according to the present invention, the parameters of the dashboard data to be displayed further include the task identification of the dashboard data to be displayed received from the visual interface; the method further includes: storing the dashboard data to be displayed as a dictionary with the task identification of the dashboard data to be displayed as the key and the dashboard data to be displayed as the value; the displaying of the dashboard data to be displayed using the visual interface includes: parsing the dictionary to obtain the task identification of the dashboard data to be displayed and the dashboard data to be displayed; and displaying the dashboard data to be displayed using the visual interface according to the task identification of the dashboard data to be displayed.

[0011] A method for a differential data task dashboard according to the present invention, the displaying of the dashboard data to be displayed using the visual interface includes: receiving, from the visual interface, the parameters of the chart for displaying the dashboard data to be displayed; and drawing the chart representing the dashboard data on the visual interface according to the parameters of the chart and the dashboard data to be displayed.

[0012] A method for a differential data task dashboard according to the present invention, wherein the data pairs to be displayed on the dashboard include multiple sets of associated fields; the step of using the visualization interface to display the data pairs to be displayed on the dashboard further includes: respectively along the first direction and the second direction of the coordinate axis, displaying the data pairs composed of the multiple sets of associated fields on the visualization interface.

[0013] A method for a differential data task dashboard according to the present invention, wherein the data pairs to be displayed on the dashboard are the marked quantity and the total quantity of differential data of a business data table within a preset time period; the step of determining the parameters of the data pairs to be displayed on the dashboard in response to an operation of configuring the parameters of the data pairs to be displayed on the dashboard through a visualization interface includes: obtaining the identification information of the business data table through the visualization interface; using the identification information of the business data table as the parameters of the data pairs to be displayed on the dashboard; the step of determining the data pairs to be displayed on the dashboard based on the parameters of the data pairs to be displayed on the dashboard includes: obtaining the business data table from the target database based on the identification information of the business data table; determining the marked quantity and the total quantity of differential data of the business data table within the preset time period according to the business data table.

[0014] The present invention also provides a differential data task dashboard device, including the following modules: A first determination module, configured to determine the parameters of the data pairs to be displayed on the dashboard in response to an operation of configuring the parameters of the data pairs to be displayed on the dashboard through a visualization interface; a second determination module, configured to determine the data pairs to be displayed on the dashboard based on the parameters of the data pairs to be displayed on the dashboard in response to a display instruction for the data pairs to be displayed on the dashboard; a display module, configured to use the visualization interface to display the data pairs to be displayed on the dashboard.

[0015] A differential data task dashboard device provided according to the present invention, wherein the dashboard data to be displayed is integrated data obtained by processing fields in the service data table using specified aggregation conditions; the operation of determining the parameters of the dashboard data to be displayed in response to configuring the parameters of the dashboard data to be displayed through a visualization interface includes: in response to receiving a query instruction carrying the identification information of the service data table and the information of the grouping fields for the service data table from the visualization interface, obtaining the identification information of the fields in the service data table grouped according to the grouping fields from a target database; wherein, the aggregation condition is a condition or rule for performing aggregation processing on fields; through the visualization interface, displaying the identification information of the fields and various selectable aggregation conditions; in response to receiving, from the visualization interface, the identification information of the fields to be displayed determined from the identification information of the fields and the target aggregation condition selected based on the various selectable aggregation conditions, using the identification information of the fields to be displayed and the target aggregation condition as the parameters of the dashboard data to be displayed.

[0016] A differential data task dashboard device provided according to the present invention, the operation of determining the dashboard data to be displayed in response to a display instruction for the dashboard data to be displayed based on the parameters of the dashboard data to be displayed includes: in response to a display instruction for the dashboard data to be displayed, obtaining the content of the fields to be displayed from the target database based on the identification information of the fields to be displayed; and processing the content of the fields to be displayed based on the aggregation condition to obtain the dashboard data to be displayed.

[0017] A differential data task dashboard device provided according to the present invention, the parameters of the dashboard data to be displayed further include the task identifier of the dashboard data to be displayed received from the visualization interface; the device further includes: storing the dashboard data to be displayed as a dictionary with the task identifier of the dashboard data to be displayed as the key and the dashboard data to be displayed as the value; the operation of displaying the dashboard data to be displayed using the visualization interface includes: parsing the dictionary to obtain the task identifier of the dashboard data to be displayed and the dashboard data to be displayed; and displaying the dashboard data to be displayed using the visualization interface according to the task identifier of the dashboard data to be displayed.

[0018] A differential data task dashboard device provided according to the present invention, the operation of displaying the dashboard data to be displayed using the visualization interface includes: receiving, from the visualization interface, the parameters of the chart for displaying the dashboard data to be displayed; and drawing the chart representing the dashboard data on the visualization interface according to the parameters of the chart and the dashboard data to be displayed.

[0019] A differential data task dashboard device provided by the present invention, wherein the to-be-displayed dashboard data includes data pairs composed of multiple groups of associated fields; using the visualization interface to display the to-be-displayed dashboard data further includes: respectively along the first direction and the second direction of the coordinate axis, displaying the data pairs composed of the multiple groups of associated fields on the visualization interface.

[0020] A differential data task dashboard device provided by the present invention, wherein the to-be-displayed dashboard data is the marked quantity and total quantity of differential data of a business data table within a preset time period; responding to an operation of configuring parameters of the to-be-displayed dashboard data through a visualization interface to determine the parameters of the to-be-displayed dashboard data includes: obtaining the identification information of the business data table through the visualization interface; using the identification information of the business data table as the parameters of the to-be-displayed dashboard data; based on the parameters of the to-be-displayed dashboard data, determining the to-be-displayed dashboard data includes: based on the identification information of the business data table, obtaining the business data table from the target database; according to the business data table, determining the marked quantity and total quantity of differential data of the business data table within the preset time period.

[0021] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, it implements the differential data task dashboard method as described in any one of the above.

[0022] The present invention also provides a non-transitory computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it implements the differential data task dashboard method as described in any one of the above.

[0023] The present invention also provides a computer program product, including a computer program. When the computer program is executed by a processor, it implements the differential data task dashboard method as described in any one of the above.

[0024] The differential data task dashboard method provided by the present invention responds to an operation of configuring parameters of the to-be-displayed dashboard data through a visualization interface to determine the parameters of the to-be-displayed dashboard data; responds to a display instruction for the to-be-displayed dashboard data, and based on the parameters of the to-be-displayed dashboard data, determines the to-be-displayed dashboard data; and uses the visualization interface to display the to-be-displayed dashboard data. Since the parameters of the to-be-displayed dashboard data are configured by the user through the visualization interface, the user does not need to directly operate the database or write complex database operation instructions, and can flexibly complete various complex data configurations of the to-be-displayed dashboard data through simple interface operations. Thus, the dashboard task of differential data can be efficiently built, effectively improving the timeliness and operation efficiency of the development project. Description of the Drawings

[0025] To more clearly illustrate the technical solutions in the present invention or the prior art, the following will briefly introduce the accompanying drawings required for use in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other accompanying drawings can be obtained based on these drawings.

[0026] Figure 1 It is one of the schematic flowcharts of the differential data task kanban method provided by the present invention.

[0027] Figure 2 It is another schematic flowchart of the differential data task kanban method provided by the present invention.

[0028] Figure 3 It is the third schematic flowchart of the differential data task kanban method provided by the present invention.

[0029] Figure 4 It is one of the schematic diagrams for configuring the parameters of the kanban data to be displayed through a visual interface provided by the present invention.

[0030] Figure 5 It is another schematic diagram for configuring the parameters of the kanban data to be displayed through a visual interface provided by the present invention.

[0031] Figure 6 It is the schematic diagram of the process for determining the kanban data to be displayed provided by the present invention.

[0032] Figure 7 It is the schematic diagram of the display page of the kanban data to be displayed provided by the present invention.

[0033] Figure 8 It is the schematic structural diagram of the differential data task kanban device provided by the present invention.

[0034] Figure 9 It is the schematic structural diagram of the electronic device provided by the present invention. Detailed Embodiments

[0035] To make the objectives, technical solutions, and advantages of the present invention clearer, the following will clearly and completely describe the technical solutions in the present invention in conjunction with the accompanying drawings in the present invention. Obviously, the described embodiments are some, but not all, of the embodiments of the present invention. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts fall within the scope of protection of the present invention.

[0036] The following will describe the differential data task kanban method of the present invention in conjunction with Figures 1-7 Describe the differential data task kanban method of the present invention.

[0037] Figure 1 One of the flow diagrams of the differential data task dashboard method provided by the present invention.

[0038] This method is applied to a dashboard terminal, which at least includes a display screen and can output and display a visual interface on the display screen. As Figure 1 shown, this method includes the following: Step 101: In response to an operation of configuring parameters of the dashboard data to be displayed through the visual interface, determine the parameters of the dashboard data to be displayed.

[0039] The dashboard data to be displayed is the data for which a dashboard task needs to be executed.

[0040] In a specific implementation process, the operation of configuring the parameters of the dashboard data to be displayed can be achieved in various ways, not limited by the description in this specification.

[0041] For example, a text box can be displayed on the visual interface, and the user can input the parameters of the dashboard data to be displayed (such as the task name) through the text box. Another example is that a drop-down menu can be displayed on the visual interface, and the user can select other parameters of the dashboard data to be displayed (such as the aggregation condition) through the drop-down menu. Another example is that, as Figure 4 shown, a drop-down box of a query system can be displayed on the visual interface, and the user can select a certain query system (such as an order management system) from it, and then select a business data table in the system.

[0042] For different types of dashboard data to be displayed, their parameters are also different.

[0043] In some embodiments, the dashboard data to be displayed is integrated data obtained by processing fields in a business data table using a specified aggregation condition. The aggregation condition is a condition or rule for aggregating fields. For example, summation, subtraction, absolute value, percentage, etc. This type of dashboard data to be displayed needs to be obtained by aggregating field data of different business data tables to meet complex data analysis requirements. Therefore, the parameters of the dashboard data to be displayed need to include the field identification information of different business data tables and the specified aggregation condition. For the method of obtaining the parameters of this type of dashboard data to be displayed, see Figure 2 the relevant content in, which will not be elaborated here.

[0044] In some embodiments, the dashboard data to be displayed is the marked quantity and total quantity of differential data in a business data table within a preset time period. The preset time period can be one day, one week, one month, etc. This type of dashboard data to be displayed only needs to process the same business data table, and the parameter setting is relatively simple, only needing to specify the identifier of the business data table corresponding to the dashboard data to be displayed. For the method of obtaining the parameters of this type of dashboard data to be displayed, seeFigure 3 The relevant content in [reference] will not be elaborated here.

[0045] In this step, the parameters of the kanban data to be displayed obtained are stored in the target database. The target database is a database for storing business data and can be implemented based on multiple databases. For example, an SQL database.

[0046] Step 102: In response to a display instruction for the kanban data to be displayed, determine the kanban data to be displayed based on the parameters of the kanban data to be displayed.

[0047] In the specific implementation process, the user can issue a display instruction for the kanban data to be displayed in various ways, which is not limited by the description in this specification.

[0048] For example, a button representing the display instruction can be displayed on the visualization interface, and the user issues a display instruction for the kanban data to be displayed by clicking this button.

[0049] In the specific implementation process, a business data table can be obtained from the target database (such as an SQL database) based on the parameters of the kanban data to be displayed, and the kanban data to be displayed is determined based on the processing of the fields in the business data table.

[0050] Regarding different types of kanban data to be displayed, the methods for determining the kanban data to be displayed based on the parameters of the kanban data to be displayed are also different. For two embodiments of this step, see Figure 2 and Figure 3 The relevant content in [reference] will not be elaborated here.

[0051] In the specific implementation process, as Figure 6 shown, a thread pool can be used to concurrently execute the data processing tasks of this step to improve the data processing efficiency.

[0052] Step 103: Use the visualization interface to display the kanban data to be displayed.

[0053] In some embodiments, the parameters of the kanban data to be displayed include the task identifier (such as the task name) of the kanban data to be displayed received from the visualization interface.

[0054] In step 102, as Figure 6 shown, using the task identifier of the kanban data to be displayed as the key and the kanban data to be displayed as the value, the kanban data to be displayed is stored as a dictionary (such as a MAP object implemented in the JAVA language). In this step, the dictionary is parsed to obtain the task identifier of the kanban data to be displayed and the kanban data to be displayed; according to the task identifier of the kanban data to be displayed, the visualization interface is used to display the kanban data to be displayed.

[0055] In the specific implementation process, the data to be displayed on the dashboard can be displayed on the visualization interface in various ways according to different types of data to be displayed on the dashboard, without being limited by the description in this specification. For two embodiments of displaying the data to be displayed on the visualization interface, see Figure 2 and Figure 3 for the relevant content therein, which will not be elaborated here.

[0056] Figure 2 FIG. 8 is a second flowchart of the method for the differential data task dashboard provided by the present invention.

[0057] In this embodiment, the data to be displayed on the dashboard is integrated data obtained by processing the fields in the business data table using specified aggregation conditions. As Figure 2 shown, the method includes the following: Step 201, in response to a query instruction received from the visualization interface carrying the identification information of the business data table and the information of the grouping fields for the business data table, obtain the identification information of the fields in the business data table grouped according to the grouping fields from the target database.

[0058] The identification information of the business data table may include the rule code of the business data table. Through the rule code, the business data table queried by the user can be uniquely determined.

[0059] The grouping field refers to the field specified by the user for grouping and analyzing data when querying the business data table.

[0060] Merely as an example, the business data table is a "real estate information table" for storing and managing real estate-related data, which contains detailed information about real estate, such as real estate ID, real estate name, address, area, type (such as light custody, non-custody), current status (such as property received, rented, vacant, etc.) and other fields. The type field (such as light custody, non-custody) or the current status field (such as property received, rented, vacant, etc.) can be used as the grouping field. The user can select one or more of these fields as the grouping basis according to their own needs.

[0061] When the user specifies a grouping field, the data in the business data table is grouped according to the value of this field. For example, if the user selects "type" as the grouping field, then the system will group the data in the "real estate information table" into two types: "light custody" and "non-custody". The grouped data still contains all the fields in the original business data table, such as real estate ID, real estate name, address, area, etc. The user can further analyze or process the grouped data, such as calculating the number of real estate of each type, the average area, etc.

[0062] In the specific implementation process, the identification information of the field can be represented by the field name.

[0063] Step 202: Through the visualization interface, display the identification information of the fields and various aggregating conditions to be selected.

[0064] In the specific implementation process, it can be done in various ways, such as Figure 4 the dropdown box shown in the figure to display the identification information of the fields and various aggregating conditions to be selected.

[0065] Step 203: In response to the identification information of the fields to be displayed determined from the identification information of the fields received from the visualization interface and the target aggregating condition selected based on various aggregating conditions to be selected, use the identification information of the fields to be displayed and the target aggregating condition as the parameters of the data of the dashboard to be displayed.

[0066] Only as an example, the identification information of the fields obtained in Step 202 includes: property ID, property name, address, area, type (such as light trusteeship, non-trusteeship), current status (such as receiving property, renting, vacant, etc.); the identification information of the fields to be displayed determined by the user from the identification information of the fields includes: type and current status.

[0067] Step 204: In response to the display instruction for the data of the dashboard to be displayed, based on the identification information of the fields to be displayed, obtain the content of the fields to be displayed from the target database.

[0068] Step 205: Based on the aggregating condition, process the content of the fields to be displayed to obtain the data of the dashboard to be displayed.

[0069] For example, select two fields, namely city and total Huijin amount, from the contract business table and the expense item dimension data table; add up the total Huijin amounts of all cities to obtain the overall total Huijin amount.

[0070] Step 206: Use the visualization interface to display the data of the dashboard to be displayed.

[0071] In some embodiments, it is possible to receive the parameters of the chart for displaying the data of the dashboard to be displayed from the visualization interface; according to the parameters of the chart, draw the representation of the chart on the visualization interface based on the data of the dashboard to be displayed.

[0072] The parameters of the chart can include: type of the chart (such as pie chart, bar chart, column chart, scatter plot, etc.), title of the chart, x-axis and y-axis settings of the graph, color, etc. As Figure 7 shown in the figure, various types of charts (pie chart, column chart, etc.) for representing the data of the dashboard to be displayed can be shown on the display page according to the type of the chart set by the user.

[0073] In some embodiments, the kanban data to be displayed includes data pairs composed of multiple sets of associated fields, and the data pairs composed of multiple sets of associated fields can be displayed on the visualization interface along the first direction and the second direction of the coordinate axes respectively. For example, the "city" field is displayed on the x-axis, and the "total amount" field is displayed on the y-axis.

[0074] Figure 3 It is the third flow diagram of the differential data task kanban method provided by the present invention.

[0075] In this embodiment, the kanban data to be displayed is the number of differential data markings and the total amount of differential data in the business data table within a preset time period (for example, daily or monthly), as Figure 3 shown, the method includes the following: Step 301: Through the visualization interface, obtain the identification information of the business data table, and use the identification information of the business data table as a parameter of the kanban data to be displayed.

[0076] The identification information of the business data table can be a rule code.

[0077] Only as an example, as Figure 5 shown, under the "basic information" tab page, a drop-down box named "verification category" is displayed. The user needs to select a specific verification category from this drop-down box. For example, if the user needs to obtain the identification information of the business data table related to "order status verification", they need to select "order status verification" in the drop-down box. When the user selects a certain verification category, the system will automatically display the rule code corresponding to this verification category in the next drop-down box named "rule code". This rule code is the identification information of the business data table that the user needs to obtain.

[0078] Step 302: In response to the display instruction for the kanban data to be displayed, obtain the business data table from the target database based on the identification information of the business data table.

[0079] Step 303: Determine the number of differential data markings and the total amount of differential data in the business data table within the preset time period according to the business data table.

[0080] Only as an example, taking an SQL database as an example, an SQL query can be used to determine the number of records marked as differential in the specified business data table, that is, the number of differential data markings; an SQL statement is used to calculate the sum of the amounts or data volumes corresponding to the marked records.

[0081] Step 304: Use the visualization interface to display the kanban data to be displayed.

[0082] In the embodiments provided by the present invention, the data to be displayed on the kanban is divided into two categories: the first category is the integrated data obtained by processing the fields in the business data table using specified aggregation conditions; the second category is the marked quantity of the differential data and the total amount of the differential data in the business data table within a preset time period. Since the parameter settings of the second category of data to be displayed on the kanban are simpler than those of the first category, configuring and displaying these two types of data separately can not only effectively simplify the data processing process but also meet complex data analysis requirements. In the specific implementation process, as Figure 4 and Figure 5 shown, the kanban task processing for one of the data to be displayed on the kanban can be selected through the "task category" option displayed on the visual interface.

[0083] The differential data task kanban device provided by the present invention will be described below. The differential data task kanban device described below can be correspondingly referred to the differential data task kanban method described above.

[0084] Figure 8 is a schematic structural diagram of the differential data task kanban device provided by the present invention.

[0085] As Figure 8 shown, the device 800 includes the following modules.

[0086] The first determination module 810 is configured to determine the parameters of the data to be displayed on the kanban in response to an operation of configuring the parameters of the data to be displayed on the kanban through the visual interface.

[0087] The second determination module 820 is configured to determine the data to be displayed on the kanban based on the parameters of the data to be displayed on the kanban in response to a display instruction for the data to be displayed on the kanban.

[0088] The display module 830 is configured to display the data to be displayed on the kanban using the visual interface.

[0089] In some embodiments, the kanban data to be displayed is integrated data obtained by processing fields in the service data table using specified aggregation conditions; determining the parameters of the kanban data to be displayed in response to an operation of configuring the parameters of the kanban data to be displayed through a visual interface includes: in response to receiving a query instruction carrying the identification information of the service data table and information about the grouping fields for the service data table from the visual interface, obtaining the identification information of the fields in the service data table grouped according to the grouping fields from the target database; wherein, the aggregation condition is a condition or rule for aggregating fields; through the visual interface, displaying the identification information of the fields and various selectable aggregation conditions; in response to receiving, from the visual interface, the identification information of the fields to be displayed determined from the identification information of the fields and the target aggregation condition selected based on the various selectable aggregation conditions, using the identification information of the fields to be displayed and the target aggregation condition as the parameters of the kanban data to be displayed.

[0090] In some embodiments, determining the kanban data to be displayed based on the parameters of the kanban data to be displayed in response to a display instruction for the kanban data to be displayed includes: in response to a display instruction for the kanban data to be displayed, obtaining the content of the fields to be displayed from the target database based on the identification information of the fields to be displayed; and processing the content of the fields to be displayed according to the aggregation condition to obtain the kanban data to be displayed.

[0091] In some embodiments, the parameters of the kanban data to be displayed further include the task identifier of the kanban data to be displayed received from the visual interface; the apparatus further includes: storing the kanban data to be displayed as a dictionary with the task identifier of the kanban data to be displayed as the key and the kanban data to be displayed as the value; using the visual interface to display the kanban data to be displayed includes: parsing the dictionary to obtain the task identifier of the kanban data to be displayed and the kanban data to be displayed; and using the visual interface to display the kanban data to be displayed according to the task identifier of the kanban data to be displayed.

[0092] In some embodiments, using the visual interface to display the kanban data to be displayed includes: receiving, from the visual interface, parameters of a chart for displaying the kanban data to be displayed; and drawing a representation of the chart on the visual interface according to the parameters of the chart based on the kanban data to be displayed.

[0093] In some embodiments, the kanban data to be displayed includes data pairs composed of multiple sets of associated fields; displaying the kanban data to be displayed by using the visualization interface further includes: respectively displaying the data pairs composed of the multiple sets of associated fields in a first direction and a second direction along the coordinate axes on the visualization interface.

[0094] In some embodiments, the kanban data to be displayed is the marked quantity and total quantity of differential data in a business data table within a preset time period; determining the parameters of the kanban data to be displayed in response to an operation of configuring the parameters of the kanban data to be displayed through a visualization interface includes: obtaining the identification information of the business data table through the visualization interface; using the identification information of the business data table as the parameters of the kanban data to be displayed; determining the kanban data to be displayed based on the parameters of the kanban data to be displayed includes: obtaining the business data table from the target database based on the identification information of the business data table; and determining the marked quantity and total quantity of differential data in the business data table within the preset time period according to the business data table.

[0095] Figure 9 An example of a schematic physical structure diagram of an electronic device is as Figure 9 shown. The electronic device may include: a processor 910, a communication interface 920, a memory 930, and a communication bus 940. Among them, the processor 910, the communication interface 920, and the memory 930 communicate with each other through the communication bus 940. The processor 910 can call the logical instructions in the memory 930 to execute the differential data task kanban method, and the method includes: determining the parameters of the kanban data to be displayed in response to an operation of configuring the parameters of the kanban data to be displayed through a visualization interface; determining the kanban data to be displayed based on the parameters of the kanban data to be displayed in response to a display instruction for the kanban data to be displayed; and displaying the kanban data to be displayed by using the visualization interface.

[0096] In addition, when the logical instructions in the above-mentioned memory 930 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or a part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage medium includes: various media such as USB flash drives, mobile hard disks, read-only memories (ROM, Read-Only Memory), random access memories (RAM, Random Access Memory), magnetic disks, or optical discs that can store program codes.

[0097] On the other hand, the present invention also provides a computer program product. The computer program product includes a computer program that can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can execute the differential data task kanban method provided by the above-mentioned various methods. The method includes: in response to an operation of configuring parameters of the kanban data to be displayed through a visualization interface, determining the parameters of the kanban data to be displayed; in response to a display instruction for the kanban data to be displayed, based on the parameters of the kanban data to be displayed, determining the kanban data to be displayed; and using the visualization interface to display the kanban data to be displayed.

[0098] In yet another aspect, the present invention also provides a non-transitory computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it is implemented to execute the differential data task kanban method provided by the above-mentioned various methods. The method includes: in response to an operation of configuring parameters of the kanban data to be displayed through a visualization interface, determining the parameters of the kanban data to be displayed; in response to a display instruction for the kanban data to be displayed, based on the parameters of the kanban data to be displayed, determining the kanban data to be displayed; and using the visualization interface to display the kanban data to be displayed.

[0099] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separated. The components shown as units may or may not be physical units, that is, they may be located in one place or distributed to multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art can understand and implement it without creative efforts.

[0100] Through the description of the above embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus a necessary general hardware platform, and of course, it can also be implemented by hardware. Based on this understanding, the essence of the above technical solution, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, magnetic disk, optical disk, etc., and includes several instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0101] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for a differential data task dashboard, characterized in that Including: In response to an operation of configuring parameters of the to-be-displayed dashboard data through a visualization interface, determining the parameters of the to-be-displayed dashboard data; In response to a display instruction for the to-be-displayed dashboard data, determining the to-be-displayed dashboard data based on the parameters of the to-be-displayed dashboard data; And Using the visualization interface to display the to-be-displayed dashboard data.

2. The differential data task dashboard method according to claim 1, wherein The to-be-displayed dashboard data is integrated data obtained by processing fields in a business data table using specified aggregation conditions; The determining the parameters of the to-be-displayed dashboard data in response to an operation of configuring parameters of the to-be-displayed dashboard data through a visualization interface includes: In response to a query instruction received from the visualization interface carrying the identification information of the business data table and the information of the grouping fields for the business data table, obtaining the identification information of the fields in the business data table grouped according to the grouping fields from the target database; Through the visualization interface, displaying the identification information of the fields and multiple selectable aggregation conditions; wherein the aggregation condition is a condition or rule for aggregating fields; In response to the identification information of the to-be-displayed fields determined from the identification information of the fields and the target aggregation condition selected based on the multiple selectable aggregation conditions received from the visualization interface, taking the identification information of the to-be-displayed fields and the target aggregation condition as the parameters of the to-be-displayed dashboard data.

3. The differential data task dashboard method according to claim 2, wherein The determining the to-be-displayed dashboard data in response to a display instruction for the to-be-displayed dashboard data based on the parameters of the to-be-displayed dashboard data includes: In response to a display instruction for the to-be-displayed dashboard data, based on the identification information of the to-be-displayed fields, obtaining the content of the to-be-displayed fields from the target database; and Based on the aggregation condition, processing the content of the to-be-displayed fields to obtain the to-be-displayed dashboard data.

4. The differential data task dashboard method according to claim 3, wherein The parameters of the to-be-displayed dashboard data further include the task identification of the to-be-displayed dashboard data received from the visualization interface; The method further includes: Using the task identification of the to-be-displayed dashboard data as the key and the to-be-displayed dashboard data as the value, storing the to-be-displayed dashboard data as a dictionary; The using the visualization interface to display the to-be-displayed dashboard data includes: Parsing the dictionary to obtain the task identification of the to-be-displayed dashboard data and the to-be-displayed dashboard data; According to the task identification of the to-be-displayed dashboard data, using the visualization interface to display the to-be-displayed dashboard data.

5. The differential data task kanban method according to any one of claims 4, characterized in that, The using the visualization interface to display the to-be-displayed dashboard data includes: Receiving from the visualization interface parameters of a chart for displaying the to-be-displayed dashboard data; According to the parameters of the chart, based on the to-be-displayed dashboard data, drawing the chart on the visualization interface.

6. The differential data task dashboard method according to claim 5, wherein The to-be-displayed dashboard data includes data pairs composed of multiple groups of associated fields; The using the visualization interface to display the to-be-displayed dashboard data further includes: Respectively along the first direction and the second direction of the coordinate axis, displaying on the visualization interface the data pairs composed of the multiple groups of associated fields.

7. The differential data task dashboard method according to claim 1, wherein, The to-be-displayed dashboard data is the marked quantity and total quantity of differential data in the business data table within a preset time period; Responding to the operation of configuring the parameters of the to-be-displayed dashboard data through the visualization interface, determining the parameters of the to-be-displayed dashboard data, including: Obtaining the identification information of the business data table through the visualization interface; Using the identification information of the business data table as the parameter of the to-be-displayed dashboard data; Based on the parameters of the to-be-displayed dashboard data, determining the to-be-displayed dashboard data, including: Based on the identification information of the business data table, obtaining the business data table from the target database; According to the business data table, determining the marked quantity and total quantity of differential data in the business data table within the preset time period.

8. A differential data task dashboard device, characterized in that, Including: A first determination module, configured to respond to the operation of configuring the parameters of the to-be-displayed dashboard data through the visualization interface, and determine the parameters of the to-be-displayed dashboard data; A second determination module, configured to respond to the display instruction for the to-be-displayed dashboard data, and determine the to-be-displayed dashboard data based on the parameters of the to-be-displayed dashboard data; A display module, configured to use the visualization interface to display the to-be-displayed dashboard data.

9. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the differential data task dashboard method according to any one of claims 1 to 7.

10. A non-transitory computer-readable storage medium storing a computer program thereon, characterized in that, When the computer program is executed by the processor, it implements the differential data task dashboard method according to any one of claims 1 to 7.

Images