Dashboard creation system, dashboard creation method, and dashboard creation program

Abstract

To provide a dashboard creation system that can reduce a cost in designing a dashboard by limiting analysis operation to clicking a chart and analysis processing to extraction and emphasis.SOLUTION: A dashboard creation system according to the embodiment includes: setting means that sets, according to operation of a developer on a setting screen, data of an extraction event master for registering a chart, a click event, and an extraction event in association with one another, and an emphasis event master for registering a chart, a click event, and an emphasis event in association with one another; and display control means that refers, when a click event on a chart occurs, to the extraction event master to execute extraction processing, and also refers to the emphasis event master to execute emphasis processing.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a dashboard creation system, a dashboard creation method, and a dashboard creation program. [Background technology]

[0002] In BI tools and business management systems, a management screen that integrates and displays various data showing the status of corporate activities is called a "dashboard." Conventionally, a system for developing dashboards is known, for example, from Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent Publication No. 2021-73556 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the above-mentioned Patent Document 1 does not disclose anything about reducing the cost of designing a dashboard by limiting the analysis operation to clicking on charts and graphs and limiting the analysis processing to extraction and highlighting.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a dashboard creation system, a dashboard creation method, and a dashboard creation program that can reduce the cost of designing a dashboard by limiting analysis operations to clicking on charts and graphs, and analysis processing to extraction and emphasis. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a dashboard creation system equipped with a control unit, wherein the control unit is characterized by comprising: an extraction event master that registers diagrams, click events, and extraction events in association with each other in accordance with operations by a developer on a setting screen; a setting means that sets data for an emphasis event master that registers diagrams, click events, and emphasis events in association with each other; and a display control means that, when a click event occurs on a diagram, refers to the extraction event master to execute extraction processing, and also refers to the emphasis event master to execute emphasis processing.

[0007] According to another aspect of the present invention, the target of the extraction process and the emphasis process may be business data for abnormal value determination.

[0008] According to another aspect of the present invention, the setting screen may be a GUI.

[0009] According to another aspect of the present invention, the control unit is configured to be able to access a diagram master in which a diagram ID, a diagram name, a diagram type ID, and a data acquisition ID are associated and registered; a graph map master in which a diagram ID and a graph map creation definition are associated and registered; a data acquisition master in which a data acquisition ID, a data acquisition name, and a stored procedure name are associated and registered; a data acquisition column master in which a data acquisition ID, a column number, and a column name are associated and registered; and business data for abnormal value determination; and the extraction event in the extraction event master includes an extracted data value ID, an extraction target diagram ID, and an extraction target column number; and when a click event occurs on a diagram, the display control means acquires the clicked diagram ID, click type, and obtainable values, and refers to the diagram master, the graph map master, the data acquisition master, the data acquisition column master, and the extraction event master to draw a graph map and execute the extraction process.

[0010] According to another aspect of the present invention, the display control means may display the value used in extracting the extraction target column of the extracted event master in the title of the drawn graph map.

[0011] Furthermore, according to one aspect of the present invention, the emphasis events of the emphasis event master may include an emphasis target diagram ID, an emphasis target item ID, an emphasis condition data value ID, a target color, an out-of-target color, a target transparency, and an out-of-target transparency, and the display control means may refer to the emphasis event master to perform emphasis processing on the drawn graph / map.

[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a dashboard creation method executed on an information processing device equipped with a control unit, characterized in including: a setting process executed by the control unit to set data for an extraction event master that associates and registers diagrams, click events, and extraction events, and an emphasis event master that associates and registers diagrams, click events, and emphasis events, in accordance with a developer's operations on a setting screen; and a display control process that, when a click event occurs on a diagram, refers to the extraction event master to perform extraction processing, and also refers to the emphasis event master to perform emphasis processing.

[0013] Furthermore, in order to solve the above-mentioned problems and achieve the object, the present invention is a dashboard creation program to be executed on an information processing device having a control unit, wherein the control unit executes a setting process to set data for an extraction event master that associates and registers diagrams, click events, and extraction events, and an emphasis event master that associates and registers diagrams, click events, and emphasis events, in accordance with a developer's operations on a setting screen; and a display control process that, when a click event occurs on a diagram, refers to the extraction event master to execute an extraction process, and also refers to the emphasis event master to execute an emphasis process. [Effects of the Invention]

[0014] According to the present invention, by limiting the analysis operation to clicking on charts and graphs and limiting the analysis processing to extraction and emphasis, it is possible to reduce the cost of designing a dashboard. [Brief explanation of the drawings]

[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a dashboard creation system according to this embodiment. [Figure 2] FIG. 2 is a flow chart showing an example of the overall processing of the control unit of the dashboard creation system according to this embodiment. [Figure 3] FIG. 3 is a diagram for explaining a specific example of processing by the control unit of the dashboard creation system according to this embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 5] FIG. 5 is a diagram for explaining a specific example of processing by the control unit of the dashboard creation system according to this embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 18] FIG. 18 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 19] FIG. 19 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 20] FIG. 20 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 21] FIG. 21 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 22] FIG. 22 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 23] FIG. 23 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 24] FIG. 24 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 25]FIG. 25 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 26] FIG. 26 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 27] FIG. 27 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 28] FIG. 28 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 29] FIG. 29 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 30] FIG. 30 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 31] FIG. 31 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 32] FIG. 32 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 33] FIG. 33 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 34] FIG. 34 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 35] FIG. 35 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 36] FIG. 36 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 37] FIG. 37 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 38]FIG. 38 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 39] FIG. 39 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 40] FIG. 40 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 41] FIG. 41 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 42] FIG. 42 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 43] FIG. 43 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 44] FIG. 44 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 45] FIG. 45 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 46] FIG. 46 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 47] FIG. 47 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 48] FIG. 48 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 49] FIG. 49 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 50] FIG. 50 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 51]FIG. 51 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 52] FIG. 52 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 53] FIG. 53 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 54] FIG. 54 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 55] FIG. 55 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 56] FIG. 56 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 57] FIG. 57 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 58] FIG. 58 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 59] FIG. 59 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 60] FIG. 60 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 61] FIG. 61 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. [Figure 62] FIG. 62 is a diagram for explaining a specific example of the processing of the control unit of the dashboard creation system according to this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0017] [1. Overview] Traditionally, there have been two challenges when developing dashboards. The first is that the design of dashboard operation flow has a high degree of freedom, requiring specialized knowledge. To efficiently analyze judgment results, a dashboard with an appropriate operation flow design is necessary. However, there are many possible operation flow patterns, and the high degree of freedom makes design difficult. As a result, knowledge of UI / UX is required when designing.

[0018] The second problem is that programming development is required for each dashboard. Because the appropriate operational flow differs for each assessment method, a dashboard must be developed for each assessment method. In this case, a development process is required each time a dashboard is designed, resulting in enormous costs.

[0019] Therefore, in this invention, the dashboard operation flow is generalized by narrowing it down to only what is necessary for abnormal value determination analysis, and the operation flow can be set using a GUI.

[0020] This reduces design costs by limiting analysis operations to clicking on charts and graphs, and by limiting analysis processing to extraction and highlighting. Also, development costs can be reduced by allowing operation flow settings to be made on the GUI.

[0021] The dashboard creation system of the present invention is applicable to all industries and business types.

[0022] [2. Configuration] Figure 1 is a diagram showing an outline of the configuration of a dashboard creation system (Web server) 100 according to this embodiment. In Figure 1, dashboard creation system (Web server) 100, developer terminals (clients) 400, and server 200 are connected to network 300 and configured to be able to communicate data with each other. Hereinafter, dashboard creation system 100 may be referred to as the "Web server" and developer terminal 400 may be referred to as the "client."

[0023] The dashboard creation system 100 provides a platform (tool) for dashboard development to the developer terminals 400, and provides a setting screen (for example, a web page) for generating a dashboard.

[0024] The developer terminals 400... are used by developers to access the dashboard creation system 100 and create dashboards. The developer terminals 400... are used to perform operations on a setting screen provided by the dashboard creation system 100, for example, using a browser.

[0025] The dashboard creation system 100 is, for example, a workstation or a commercially available desktop personal computer.

[0026] 1, dashboard creation system 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in dashboard creation system 100 are connected to each other so that they can communicate with each other via any communication path.

[0027] The communication interface unit 104 communicatively connects the dashboard creation system 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of exchanging data with other devices via the communication line. Here, the network 300 has a function of connecting the dashboard creation system 100, the developer terminal 400, and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0028] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0029] The storage unit 106 stores various databases (DB), tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes a DB 106a.

[0030] The DB 106a includes a chart type master 106a1, a chart emphasis item master 106a2, a chart type emphasis item mapping master 106a3, a chart click event master 106a4, a chart type click event mapping master 106a5, a chart click event obtainable value master 106a6, a dashboard definition master 106a7, a data acquisition master 106a8, a data acquisition column master 106a9, a chart layout master 106a10, a chart master 106a11, a line graph master 106a2, a chart click event master 106a3, a dashboard definition master 106a4, a chart type click event mapping master 106a5, a chart click event obtainable value master 106a6, a dashboard definition master 106a7, a data acquisition master 106a8, a data acquisition column master 106a9, a chart layout master 106a10, a chart master 106a11, a line graph master 106a12, a chart layout master 106a13, a chart layout master 106a14, a chart layout master 106a15, a chart layout master 106a16, a chart layout master 106a17, a chart layout master 106a18, a chart layout master 106a19, a chart layout master 106a20, a chart layout master 106a21, a chart layout master 106a22, a chart layout master 106a23, a chart layout master 106a24, a chart layout master 106a25, a chart layout master 106a26, a chart layout master 106a27, a chart layout master 106a28, a chart layout master 106a29, a chart layout master 106a30, a chart layout master 106a31, a chart layout master 106 The master 106a includes a data master 106a12, a bar graph master 106a13, a stacked bar graph master 106a14, an area graph master 106a15, a stacked area graph master 106a16, a pie chart master 106a17, a scatter plot master 106a18, a heat map master 106a19, a bar graph master 106a20, a table column header master 106a21, an extracted event master 106a22, a highlighted event master 106a23, a data source 106b, and a data file 106c.

[0031] Data source 106b is, for example, business data for abnormal value determination, which is used in extraction processing and emphasis processing.

[0032] The control unit 102 is a CPU or the like that performs overall control of the dashboard creation system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0033] The control unit 102 is configured to be able to access the DB 106a stored in the storage unit 106. The DB 106a may be provided in another location (for example, the server 200) as long as it is accessible by the control unit 102.

[0034] The control unit 102 conceptually includes a setting unit 102a and a display control unit 102b.

[0035] In response to a developer's operation on a setting screen provided to the developer terminal 400, the setting unit 102a sets data in an extraction event master 106a22 that associates and registers a diagram, a click event, and an extraction event, and in an emphasis event master 106a23 that associates and registers a diagram, a click event, and an emphasis event, creates the extraction event master 106a22 and the emphasis event master 106a23, and registers them in the DB 106a. The target of the extraction process and the emphasis process may be business data for abnormal value determination. The setting screen may also be a GUI.

[0036] When a click event occurs on a chart, display control unit 102b refers to extraction event master 106a22 to execute extraction processing, and also refers to emphasis event master 106a23 to execute emphasis processing.

[0037] The extraction event in the extraction event master may include an extraction data value ID, an extraction target chart ID, and an extraction target column number. When a click event occurs on a chart, the display control unit 102b may acquire the clicked chart ID, the click type, and the value that can be acquired, and refer to the chart master 106a11, the graph map master (a collective term for the line graph master 106a12, bar graph master 106a13, stacked bar graph master 106a14, area graph master 106a15, stacked area graph master 106a16, pie chart master 106a17, scatter plot master 106a18, heat map master 106a19, and horizontal bar graph master 106a20), data acquisition master 106a8, data acquisition column master 106a9, and extraction event master 106a22 to draw a graph map and perform the extraction process.

[0038] The display control unit 102b may display the value used for extracting the extraction target column of the extracted event master 106a22 in the title of the drawn graph map.

[0039] In addition, the highlight event of the highlight event master 106a23 may include the highlight target diagram ID, the highlight target item ID, the highlight condition data value ID, the target color, the non-target color, the target transparency, and the non-target transparency, and the display control unit 102b may refer to the highlight event master 106a23 to perform highlight processing on the drawn graph map.

[0040] [3. Specific Examples] A specific example of the processing of the control unit 102 of the dashboard creation system 100 of this embodiment will be described with reference to FIGS.

[0041] [3-1. Overall processing flow] An example of the overall processing of control unit 102 of dashboard creation system 100 in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a flowchart showing an example of the overall processing of control unit 102 of dashboard creation system 100 in this embodiment.

[0042] The setting unit 102a executes a dashboard setting process (step S1). Specifically, in the dashboard setting process, the setting unit 102a sets data for an extraction event master 106a22 that associates and registers a chart, a click event, and an extraction event, and data for an emphasis event master 106a23 that associates and registers a chart, a click event, and an emphasis event, in response to a developer's operation on a setting screen provided to the developer terminal 400, to create the extraction event master 106a22 and the emphasis event master 106a23, and register them in the DB 106a. The target of the extraction process and the emphasis process may be business data for abnormal value determination. Furthermore, the setting screen may be a GUI.

[0043] The display control unit 102b executes a preview process (step S2). Specifically, in the preview process, when a click event occurs on a chart, the display control unit 102b executes an extraction process by referring to the extraction event master 106a22, and executes an emphasis process by referring to the emphasis event master 106a23.

[0044] In this case, the extraction event in the extraction event master may include the extraction data value ID, the chart ID to be extracted, and the column number to be extracted, and when a click event occurs on a chart, the display control unit 102b may obtain the clicked chart ID, click type, and obtainable values, and refer to the chart master 106a11, graph map master, data acquisition master 106a8, data acquisition column master 106a9, and extraction event master 106a22 to draw a graph map and perform the extraction process.

[0045] Furthermore, the display control unit 102b may display the value used in extracting the extraction target column of the extracted event master 106a22 in the title of the drawn graph map.

[0046] In addition, the highlight event of the highlight event master 106a23 may include the highlight target diagram ID, the highlight target item ID, the highlight condition data value ID, the target color, the non-target color, the target transparency, and the non-target transparency, and the display control unit 102b may refer to the highlight event master 106a23 to perform highlight processing on the drawn graph map.

[0047] [3-2. Points] The key points of the dashboard creation system 100 will be explained with reference to Figs. 3 to 18. Fig. 3 is a diagram showing an example of a dashboard. The dashboard shown in Fig. 3 consists of three charts. Figure 1 aggregates sales amounts by person in charge and by month, and displays trends for each person in charge. Figure 2 displays monthly sales amounts for only a specific person in charge. Figure 3 displays sales amounts by person in charge and by payee for a specific month and year in a heat map.

[0048] For example, in Figure 1, the sales amount for Person B for March 2021 stands out. Therefore, the analyst will conduct a more detailed analysis of this data. Specifically, he / she will want to extract Person B's data in Figure 2. He / she will want to extract Person B's data for March 2021 in Figure 3. He / she will want to emphasize Person B in Figure 1. He / she will want to emphasize March 2021 in Figure 1. He / she will want to emphasize March 2021 in Figure 2.

[0049] The measures to address this issue will be explained in two parts: (1) dashboard behavior and (2) dashboard settings.

[0050] (1) The following measures have been implemented regarding the behavior of the dashboard. 1. The candidates for dashboard operations have been narrowed down to only those necessary for anomaly detection analysis. 2. The dashboard operation methods were narrowed down to only those necessary and sufficient for outlier detection analysis. 3. How to display selected data

[0051] 1. A detailed explanation of how the process candidates for dashboard operations have been narrowed down to only those required for outlier analysis. In this invention, the process candidates for operations have been narrowed down to two patterns ("extraction" and "highlighting") required for outlier analysis, and the locations to be highlighted and the highlighting methods have been patterned.

[0052] "Extraction" means narrowing down a specific column in the chart's data source to a specific value and displaying it. "Extraction" will be explained with reference to Figures 4 and 5. In the dashboard example, Figure 2-1, as shown in Figure 4, displays only the data for which the "Responsible Person Code" column has the value T001 out of the sales data for all personnel in the data source.

[0053] On the other hand, if you want to display the data for the person in charge B who you are focusing on, display it as shown in Figure 2-2 in Figure 5.

[0054] "Highlighting" means to display data of interest in a darker color on a chart to make it stand out, or conversely, to display data that is not of interest in a lighter color to make it less noticeable. "Highlighting" will be explained with reference to Figure 6. Figure 6 is a diagram showing examples of highlighting patterns. Figure 6 shows a single bar graph, a stacked bar graph, a grouped bar graph, a line graph, an area graph, For stacked area charts, scatter plots, pie charts, heat maps, and bar charts, it shows whether x-axis emphasis, legend emphasis, bar emphasis, point emphasis, cell emphasis, and row emphasis can be set.

[0055] Grouped bar graphs are not used because they are inappropriate for graphically representing abnormality detection results due to the clutter of bars for multiple series (legends).

[0056] X-axis highlight specifies the background color / transparency of the target x-axis. Legend highlight specifies the color / transparency of the target legend and non-target legend. Point highlight specifies the color / transparency of the target point. Bar highlight specifies the color / transparency of the target bar and non-target bar. Cell highlight specifies the background color / transparency of the target cell. Row highlight specifies the background color / transparency of the target row.

[0057] 7 and 8 are diagrams showing examples of dashboard highlighting, with FIG. 7 showing the dashboard before highlighting and FIG. 8 showing the dashboard after highlighting.

[0058] 2. We will explain how the dashboard operation method has been narrowed down to only those necessary and sufficient for outlier detection analysis. In this invention, since necessary and sufficient operations can be performed when focusing on outlier detection analysis, the operation method has been narrowed down to click events on charts, the click events that can be set on each chart, and the values ​​that can be obtained by each click event. In addition, the settings for click events and the values ​​to be obtained can be set using the GUI.

[0059] The reason for limiting the operation method to click events is to enable intuitive operation of the dashboard.

[0060] Figure 9 shows the click events that can be set for each chart (x-axis click, legend click, bar click, point click, cell click) and the values ​​that can be obtained by each click event (x-axis value, legend code, legend value, row number). An x-axis click will obtain the x-axis value; a legend click will obtain the legend code and legend value; a bar click will obtain the x-axis value, legend code and legend value; a point click will obtain the x-axis value, legend code and legend value; and a cell click will obtain the row number.

[0061] 10 to 13 show examples of values ​​that can be obtained by click events. For example, in FIG. 10, with the click event "Legend Click," clicking on, for example, person in charge B will obtain the legend code "T002" and legend value "Person in charge B." With the click event "X-Axis Click," clicking on, for example, the x-axis near 2021 / 05 will obtain the x-value "2021 / 05." With the click event "Point Click," clicking on, for example, the point near 2021 / 03 on the graph for person in charge B will obtain the legend code "T002," legend value "Person in charge B," and x-value "2021 / 03."

[0062] 3. We will explain the innovations in the method of expressing data selected as extraction conditions. In this invention, when the data source of a chart is extracted based on the data selection state, the condition value used for extraction is displayed in the chart title, and the extraction conditions are automatically displayed in the title. Figure 14 shows an example of the display before and after selection. In Figure 14, after selection, "Person in charge B" used for extraction is displayed.

[0063] (2) Dashboard settings This section explains "Improvements to UI operability of the dashboard design screen." In response to the simplification of the dashboard representation and operation method described above, the following points have been devised to make it easier to design them more efficiently. In this invention, the settings can be made on a GUI and the setting flow has been generalized, allowing settings to be made on a single screen regardless of the type of chart or graph, and the settings can be confirmed using a preview display.

[0064] In the present dashboard creation system 100, the setting flow is generalized as follows. 1. Select the chart you want to set up. 2. Select the event click you want to set. 3. Select the action that each chart will take when clicked from Extract or Highlight. 4.(1) For extraction, select the column to extract and the value to extract. The columns to be extracted are selected from the chart's data source. The extracted value is selected from the values ​​that can be obtained by the click event. (2) For highlighting, select the highlight item and highlighting method, the column to narrow down the highlighting target, and the value to narrow down the highlighting target. The items and methods of emphasis are selected from options specific to each chart. The columns to highlight are selected from the chart's data source. The value to narrow down the emphasis target is selected from the values ​​that can be obtained by the click event.

[0065] Figure 15 shows an example of the extraction settings screen. In Figure 15, in area A1, 1. select the chart you want to configure. In area A2, 2. select the click event you want to configure. The UI is simplified by limiting events to clicks. While selectable click events vary depending on the chart type, generalization allows for display in a tabular format. This allows for configuration of various chart types and reduces the learning curve for operating the settings screen. In area A3, 3. select the process each chart performs from extraction and emphasis. In this figure, extraction is selected. In area A3, 4. (1) For extraction, select the column to extract and the value to extract. The column to extract is selected from the chart's data source. The value to extract is selected from the values ​​available for click events. While the available fields vary depending on the chart type and click event, generalization allows for display in a tabular format. This allows for configuration of various chart types and click events on a single screen, reducing the learning curve for operating the settings screen. Area A4 allows you to preview the settings to confirm their operation. This makes it easier to create a dashboard that meets the user's expectations.

[0066] Figure 16 shows an example of the highlighting settings screen. Explanations common to Figure 15 will be omitted. Highlighting is selected in area A3. In area A3, for 4.(2) highlighting, select the highlighting location and highlighting method, the column to narrow down the highlighting target, and the value to narrow down the highlighting target. "Item name" selects the chart item you want to highlight. "Item to use" sets the value to use to extract the highlighting target. "Highlighted data" sets the color and transparency of the data you want to focus on. "Not highlighted" sets the color and transparency of the data you do not want to focus on.

[0067] The item names and items that can be selected vary depending on the type of chart and click event, but by generalizing them, they can be displayed in a table format. This allows you to set various chart types and click events on a single screen, reducing the learning cost of operating the setting screen.

[0068] An example of a preview will be described with reference to Figures 17 and 18. Figure 17 shows an example of the screen before clicking. In Figure 17, when you click on "Responsible Person B x 2021 / 03" in Figure 1, a screen like the one shown in Figure 18 is displayed. In Figure 18, for emphasis, the legend code (=Responsible Person B's code) obtained at the clicked point causes the transparency of the legends other than that of Responsible Person B to be 200. The x-axis for 2021 / 03 is displayed in gray due to the x-value (=2021 / 03) obtained at the clicked point.

[0069] In Figure 2, for emphasis, the x-axis for 2021 / 03 is displayed in gray due to the x-value (= 2021 / 03) obtained at the clicked point, and the transparency of bars other than 2021 / 03 is set to 200. For extraction, the legend code (= code for person in charge B) obtained at the clicked point is used to extract from the person in charge code column of the data source in Figure 2, and only person in charge B is displayed. In addition, the extraction condition value "person in charge B" is displayed in the title section.

[0070] In Figure 3, the legend code (=Responsible Person B's code) obtained at the clicked point is used to extract from the responsible person code column of the data source of Figure 3, and only responsible person B is displayed. The x value (=2021 / 03) obtained at the clicked point is used to extract from the accounting year / month column of the data source of Figure 3, and only 2021 / 03 is displayed. The extraction condition value "2021 / 03 Responsible Person B" is displayed in the title section.

[0071] "3-3. Master Configuration] The master configuration of the dashboard creation system 100 will be described with reference to Fig. 19 to Fig. 41. The masters include a master of unified behavior settings that is predetermined by the system, tables that must be set in advance, and masters set in this embodiment, and will be described in order below. Fig. 19 to Fig. 41 are diagrams showing examples of the configuration of each master.

[0072] (Master of uniform behavior settings predefined by the system) The chart type master 106a1 is a master for managing chart types, and can be configured as a table in which chart type IDs and chart type names are registered in association with each other, as shown in Fig. 19. In the example shown in the figure, the first line contains the chart type ID "Bar" and the chart type name "Single Bar Graph."

[0073] The chart highlight item master 106a2 is a master for managing highlightable items in charts, and can be configured as a table in which highlight item IDs and highlight item names are registered in association with each other, as shown in Fig. 20. In the example shown in the figure, the first row contains the highlight item "IDXAxisHighlight" and the highlight item name "x-axis highlight."

[0074] The diagram type highlight item mapping master 106a3 is a master for managing which items in the diagram highlight item master can be used by each diagram type in the diagram type master 106a1, and can be configured as a table in which diagram type IDs and highlight item IDs are registered in association with each other, as shown in Fig. 21. In the example shown in the same figure, the first row has the diagram type ID "Bar" and the highlight item ID "XAxisHighlight."

[0075] The chart click event master 106a4 is a master for managing click events, and can be configured as a table in which click event IDs and click event names are registered in association with each other, as shown in Fig. 22. In the example shown in the figure, the first row has the click event ID "XAxisClick" and the click event name "x-axis click."

[0076] The diagram type click event mapping master 106a5 is a master for managing which click events in the diagram click event master can be used by each diagram type in the diagram type master, and can be configured as a table in which diagram type IDs and click event IDs are registered in association with each other, as shown in Fig. 23. In the example shown in the same figure, the first row has the diagram type ID "Bar" and the click event ID "XAxisClick."

[0077] The chart click event obtainable value master 106a6 is a master for managing values ​​that can be obtained by each click event of the chart click event master, and can be configured as a table in which click event IDs, obtainable value IDs, and obtainable value names are associated and registered, as shown in Fig. 24. In the example shown in the same figure, the first row contains the click event ID "XAxisClick," the obtainable value ID "XValue," and the obtainable value name "x value."

[0078] (Master must be pre-configured) The dashboard definition master 106a7 is a master for managing dashboard definitions, and can be configured as a table in which dashboard definition IDs, dashboard names, and abnormality judgment definition IDs are associated and registered, as shown in Fig. 25. In the example shown in the figure, the first line contains the dashboard definition ID "Dashboard1," the dashboard name "Dashboard1," and the abnormality judgment definition ID "AbnormalJudgement1."

[0079] The data acquisition master 106a8 is a master for managing data acquisition definitions, and can be configured with a table or the like in which data acquisition IDs, data acquisition names, and stored procedure names are associated and registered, as shown in Fig. 26. Here, the "data acquisition ID" is an ID that uniquely determines the data acquisition definition, the "data acquisition name" is the name of the data acquisition definition, and the "stored procedure name" is the name of the stored procedure executed by the data acquisition definition. In the example shown in the same figure, the first line contains the data acquisition ID "DataSelection1", the data acquisition name "Sales amount by person in charge x fiscal year and month", and the stored procedure name "StoredProcedure1".

[0080] The data acquisition column master 106a9 is a master for managing column information acquired by each definition in the data acquisition definition master 106a8, and can be configured as a table in which data acquisition IDs, column numbers, and column names are associated and registered, as shown in FIG. 27. The "data acquisition ID" is the ID of the data acquisition definition master and represents the data in the associated data acquisition master 106a8. The "column number" is a sequential number. The "column name" is the name of the column. In the example shown in the same figure, the first row has the data acquisition ID "DataSelection1," the column number "0," and the column name "fiscal year / month."

[0081] The chart layout master 106a10 is a master for managing the layout of charts on a dashboard, and can be configured with a table or the like that associates and registers dashboard definition IDs, chart IDs, Top, Left, width, and height, as shown in FIG. 28. The "dashboard definition ID" is the dashboard definition ID for placing the chart. The "chart ID" is the chart definition ID to be placed on the dashboard. "Top" is the vertical position when placing the chart, and specifies the distance from the top edge. "Left" is the horizontal position when placing the chart, and specifies the distance from the left edge. "Width" is the width of the chart. "Height" is the height of the chart. In the example shown in the same figure, the first line contains the dashboard definition ID "Dashboard1", chart ID "Figure1", Top "0px", Left "0px", Width "300px", and Height "100px".

[0082] The diagram master 106a11 is a master for managing diagram definitions, and as shown in Figure 29, can be composed of a table in which diagram IDs, diagram names, diagram type IDs, and data acquisition IDs are associated and registered. The "diagram ID" is an ID that uniquely determines a diagram definition. The "diagram name" is the name of the diagram definition and is used as the title. The "diagram type ID" is the ID of the diagram type master and represents the diagram type of the diagram definition. The "data acquisition ID" is the ID of the data acquisition master and represents the data acquisition definition used as the data source for the diagram definition. In the example shown in the same figure, the first line has the diagram ID "Figure1", the diagram name "Trends in sales amount by person in charge", the diagram type ID "Polyline", and the data acquisition ID "DataSelection1".

[0083] The line graph master 106a12 is a master for managing definitions related to line graphs among the chart definitions, and can be composed of a table or the like that associates and registers chart IDs, x-axis data column numbers, y-axis data column numbers, legend code data column numbers, and legend value data column numbers, as shown in Figure 30. The "chart ID" is the ID of the record in the chart master to which the line graph definition is linked. The "x-axis data column number" is the number of the column in the data source used for the x-axis. The "y-axis data column number" is the number of the column in the data source used for the y-axis. The "legend code data column number" is the number of the column in the data source used for the legend code. The "legend value data column number" is the number of the column in the data source used for the legend value. In the example shown in the figure, the first row contains the chart ID "Figure 1," the x-axis data column number "0: accounting year / month," the y-axis data column number "3: sales amount," the legend code data column number "1: person in charge code," and the legend value data column number "2: person in charge name."

[0084] The bar graph master 106a13 is a master for managing definitions related to bar graphs among the chart definitions, and can be configured as a table or the like in which chart IDs, x-axis data column numbers, and y-axis data column numbers are associated and registered, as shown in Fig. 31. In the example shown in the same figure, the first row has the chart ID "Figure2," the x-axis data column number "0: accounting year / month," and the y-axis data column number "3: sales amount."

[0085] The stacked bar graph master 106a14 is a master for managing definitions related to stacked bar graphs among the chart definitions, and can be composed of a table or the like in which chart IDs, x-axis data column numbers, y-axis data column numbers, legend code data column numbers, and legend value data column numbers are associated and registered, as shown in FIG. 32.

[0086] The area graph master 106a15 is a master for managing definitions related to area graphs among the chart definitions, and can be composed of a table or the like in which chart IDs, x-axis data column numbers, y-axis data column numbers, legend code data column numbers, and legend value data column numbers are associated and registered, as shown in FIG. 33.

[0087] The stacked area graph master 106a16 is a master for managing definitions related to stacked area graphs among the chart definitions, and can be composed of a table or the like in which chart IDs, x-axis data column numbers, y-axis data column numbers, legend code data column numbers, and legend value data column numbers are associated and registered, as shown in Figure 34.

[0088] The pie chart master 106a17 is a master for managing definitions related to pie charts among the chart definitions, and can be composed of a table or the like in which chart IDs, value data column numbers, legend code data column numbers, and legend value data column numbers are associated and registered, as shown in FIG. 35.

[0089] The scatter diagram master 106a18 is a master for managing definitions related to scatter diagrams among the diagram definitions, and can be composed of a table or the like in which the diagram ID, x-axis data column number, y-axis data column number, legend code data column number, and legend value data column number are associated and registered, as shown in FIG.

[0090] Heat map master 106a19 is a master for managing definitions related to heat maps among the chart definitions, and can be configured as a table that associates and registers chart IDs, x-axis data column numbers, and gradation data column numbers, as shown in Fig. 37. In the example shown in the same figure, the first row has chart ID "Figure 3," x-axis data column number "4: Payee name," and gradation data column number "5: Sales amount."

[0091] The horizontal bar graph master 106a20 is a master for managing definitions related to horizontal bar graphs among the chart definitions, and can be composed of a table or the like in which chart IDs, x-axis data column numbers, and gradation data column numbers are associated and registered, as shown in Figure 38.

[0092] The table column header master 106a21 is a master for managing the column header information of the heat map master or bar graph master, and can be configured as a table or the like in which chart IDs, column numbers, and data column numbers are associated and registered, as shown in Figure 39. The "chart ID" is the ID of the record in the chart master to which the heat map definition or bar graph definition is linked. The "column number" is a sequential number and is used in the order in which they are displayed as column headers. The "data column number" is the number of the column in the data source to be used as the column header. In the example shown in the same figure, the first row has the chart ID "Figure3," column number "1," and data column number "1: Person in Charge Code."

[0093] (Master set in this example) The extracted event master 106a22 is a master for managing extracted event definitions that are linked to each record of the diagram definition master, and can be composed of a table or the like that associates and registers diagram IDs, click event IDs, extracted data value IDs, extracted target diagram IDs, and extracted target column numbers, as shown in Figure 40.

[0094] "Figure ID" is the ID of the diagram definition in the diagram master that triggers the extraction event. "Click event ID" is the record ID in the diagram click event master to which the extraction event definition is linked. "Extracted data value ID" is the ID of the obtainable value used in the extraction event in the diagram click event obtainable value master. "Extraction target diagram ID" is the diagram definition ID in the diagram master for which extraction is performed by the extraction event. "Extraction target column number" is the number of the column for which extraction is performed in the data acquisition column master (the data acquisition definition is obtained from the data acquisition definition ID column of the diagram definition linked to the diagram ID column). In the example shown in the same figure, the first row has the diagram ID "Figure1", click event ID "PointClick", extracted data value ID "LegendCode", extraction target diagram ID "Figure2", and extraction target column number "1: Person in charge code".

[0095] The highlight event master 106a23 is a master for managing highlight event definitions linked to each record in the diagram master 106a11. As shown in FIG. 41, it can be configured as a table or the like that associates and registers a diagram ID, a click event ID, a highlight target diagram ID, a highlight target item ID, a highlight condition data value ID, a target color, a non-target color, a target transparency, and a non-target transparency. The "diagram ID" is the ID of the diagram definition in the diagram master that triggers the highlight event. The "click event ID" is the record ID to which the highlight event definition is linked in the diagram click event master. The "highlight target diagram ID" is the ID of the diagram definition in the diagram master that is highlighted by the highlight event. The "highlight target item ID" is the ID of the diagram highlight item definition in the diagram highlight item master that is highlighted by the highlight event. The "highlight condition data value ID" is the ID of the obtainable value used to extract the highlight target in the diagram click event obtainable value master. The "target color" is the color of the highlight target. "Color outside the target" is the color outside the target for emphasis. "Transparency of target" is the transparency of the target for emphasis. "Transparency outside the target" is the transparency of the target for emphasis. In the example shown in the same figure, the first line contains the figure ID "Figure1", click event ID "PointClick", figure ID to be highlighted "Figure1", item ID to be highlighted "LegendHighlight", highlight condition data value ID "LegendCode", transparency of target "0", and transparency of the target for emphasis "200".

[0096] [3-4. System Control] 42 to 54, the system control of the dashboard creation system 100 will be described. In the system control, the flow of the setting screen for registering the master shown in [3-3. Master Configuration] will be described.

[0097] Fig. 42 is a diagram showing an example of a screen transition diagram for the setting screens for "master that must be set in advance" and "master that is set in this embodiment." The "master that must be set in advance" is set on the dashboard definition setting screen, data acquisition definition setting screen, and chart setting / layout setting screen of Fig. 42 (A) to (C), and the "master that is set in this embodiment" is set on the chart click setting screen of Fig. 42 (D). The screen that is characteristic of the present invention is the chart click setting screen.

[0098] 43 to 54, the system control on the chart click setting screen will be described in the order of (1) how to create an extraction event master, (2) how to create an emphasis event master, and (3) how to preview.

[0099] With reference to FIG. 43, (1) a method for creating an extraction event master will be described. FIG. 43 is a diagram showing an example of a display on a diagram click setting screen for explaining a method for creating an extraction event master. In FIG. 43, in area A1, (1) select a diagram for which you want to set a click event from the diagrams in the diagram master 106a11. In area A2, (2) click events that can be selected from the diagram type of the diagram selected in (1) are displayed. Select the click event you want to set from these. In area A3, (3) select a diagram for which you want to extract data when clicked from the selected diagram. (4) Select the item you want to extract from the list of data acquisition column definitions in the data acquisition definition linked to the selected diagram. (5) The diagram type and click event are determined from the contents selected in (1) and (2). This displays a list of items that can be acquired, and you can select the item you want to use.

[0100] In this way, by operating the diagram click setting screen, for example, an extracted event master 102a22 as shown in FIG. 44 is created.

[0101] With reference to Figure 45, (1) a method for creating an emphasis event master will be described. Figure 45 is a diagram showing an example of the display of a diagram click setting screen to explain how to create an emphasis event master. In Figure 45, explanations of parts common to Figure 43 will be omitted. In area A3, (3) select the diagram you want to emphasize when clicked from the selected diagram. (4) Display a list of emphasis points based on the diagram type of the diagram selected in (3), and select the point you want to emphasize. (5) The diagram type and click event are determined from the contents selected in (1) and (2). This determines the items that can be acquired. Display a list of items that can be acquired, and select the item you want to use. (6) Set the emphasis method as target or non-target. Also, set the color and transparency.

[0102] In this way, by operating the diagram click setting screen, for example, an emphasis event master 102a23 as shown in FIG. 46 is created.

[0103] The operation of the preview will be described with reference to Figures 47 to 54. The preview is displayed in area A4 at the bottom of the diagram click setting screen shown in Figure 47. The preview is displayed based on the data acquisition definition, diagram definition, extraction event definition, and emphasis event definition that have been set up until now.

[0104] The process flow of the preview operation will be explained below. In the preview operation, the following processes are performed.

[0105] (1) When a chart is clicked, the clicked chart ID, click type, and selected value are sent to the web server. (2) Obtain the data of the extracted event master and emphasis event master from the chart ID and click type. (3) Obtain the chart definition and data acquisition definition for each chart. (4) Obtain data for drawing charts and graphs from the data acquisition definition. (5) Using the extracted event master, data for drawing charts is extracted. (6) Create a chart from the chart drawing data and chart master. (7) Use the highlight event master to change the style of the created chart.

[0106] Each process will be described in detail.

[0107] (1) When a chart is clicked, the clicked chart ID, click type, and selected value are sent to the web server. For example, in Figure 48, when the point for 2021 / 03 on the graph for person in charge B in Figure 1, which shows the sales amount by person in charge, is clicked, the clicked chart ID "Figure 1," click event ID "PointClick," obtainable value "Legend code → T002," legend value "person in charge B," and x value "2021 / 03" are obtained and sent to the web server. The web server performs the following process.

[0108] (2) Data from the extraction event master 106a22 and the emphasis event master 106a23 is obtained from the figure ID and click type. For example, as shown in Figure 49, using the figure ID "Figure1" and the click event ID "PointClick" as keys, data from the first to third rows is obtained from the extraction event master 106a22, and data from the first to fourth rows is obtained from the emphasis event master 106a23.

[0109] (3) Obtain the chart definition and data acquisition definition for each chart. The charts to be processed are Figures 1 to 3, but for simplicity of explanation, only Figure 2 will be described below as an example. For example, as shown in FIG. 50, using the chart ID "Figure 2" as a key, the second row of data is obtained from the chart master 106a11, and the first row of data is obtained from the bar graph master 106a13. Also, using the data acquisition ID "DataSelection1" obtained from the chart master 106a11 as a key, the first row of data is obtained from the data acquisition master 106a8, and the first to fourth rows of data are obtained from the data acquisition column master 106a9.

[0110] (4) Data for drawing a chart is acquired from the data acquisition definition. For example, as shown in Fig. 51, the business data of the data source 106b is identified using the stored procedure name "storedprocedure1" acquired from the data acquisition column master 106a9 as a key, and from the identified business data, data for the columns of column number "0", column name "accounting year / month", column number "1", column name "person in charge code" acquired from the data acquisition column master 106a9, column number "2", column name "person in charge name", column number "3", and column name "sales amount" acquired from the data acquisition column master 106a9 is extracted to acquire data for drawing a chart.

[0111] (5) Using the extracted event master 106a22, the data for drawing a chart is extracted from the data for drawing a chart. Extract data. For example, as shown in Figure 52, use the data of the extraction target diagram ID = Figure 2 in the extraction event master 106a22. Extract data for drawing the diagram as follows. Of the extraction target column number = selected value "1: person in charge code" in the extraction event master 106a22, use the value "person in charge code = T002" used for extraction in the extraction event master 106a22 to extract the data for diagram extraction.

[0112] (6) A diagram is created from the diagram drawing data and the diagram master 106a11. For example, as shown in Fig. 53, a bar graph is created based on the diagram master 106a11, the bar graph master 106a13, and the diagram drawing data, and the person in charge B (=T002) who was used as the extraction condition value is displayed in the diagram title.

[0113] (7) The style of the created chart is changed using the emphasis event master 106a23. 54, the highlight event master 106a23 is set to have the target color set to "#808080" and the transparency set to "200," so the x-axis portion of 2021 / 03 is displayed in semi-transparent gray. Also, the transparency of non-target items is set to "200," so the bars other than 2021 / 03 are drawn semi-transparently, and the 2021 / 03 bar is displayed highlighted.

[0114] [3-5: Extraction / Highlighting Process and Table Correspondence] 55 to 62, we will explain the correspondence with tables on the extraction / highlighting setting screen and how data is used when extracting and highlighting previews in the dashboard creation system 100. The correspondence with tables on the setting screen will be explained in the following order: 1. Identifying a click event, 2. When the extraction setting screen is displayed, 3. When the extraction setting screen is registered, 4. When the highlighting setting screen is displayed, and 5. When the highlighting setting screen is registered.

[0115] 1. Identifying a click event will be explained with reference to Fig. 55. A list of click events is obtained as follows.

[0116] 1. In area A1, specify the diagram ID corresponding to the "diagram name" to be selected from the diagram master 102a11. In the example shown in the figure, "Figure 1" is specified.

[0117] 2. Using the diagram type ID of the diagram master 102a11 corresponding to the identified diagram ID as a key, a click event ID is obtained from the diagram type click event mapping master 106a5. In the example shown in the figure, using the diagram type ID "Polyline" as a key, the click event IDs "XAxisClick, LegendClick, PointClick" are obtained from the diagram type click event mapping master 106a5.

[0118] 3. Using the acquired click event ID as a key, the click event name is acquired from the chart click event master 106a4 and displayed in area 2. In the example shown in the same figure, using the click event ID "XAxisClick, LegendClick, PointClick" as a key, "Legend click, x-axis click, point click" are acquired from the chart click event master 106a4 and displayed in area 2.

[0119] 2. The display of the extraction setting screen will be described with reference to FIG. 56. The list of available items is set in area A3 of the extraction setting screen. The list of available items includes the items of the chart name to be extracted, the data column name, and the extraction condition value use item. The chart name to be extracted is selected from the chart ID set in the chart master 106a11. The data column name is selected from the column name set in the data acquisition column master 106a9. The extraction condition value use item is selected from the available values ​​of the selected click event in the chart click event obtainable value master 106a6.

[0120] 3. Registration on the extraction setting screen will be described with reference to Fig. 57. In Fig. 57, when the Confirm button on the extraction setting screen is pressed, a registration process is executed, and the data for "chart ID," "click event ID," "chart ID to be extracted," "column number to be extracted," and "extracted data value ID" in the extraction event master 106a22 are obtained from the values ​​on the screen and registered. The IDs (codes) corresponding to each value are held in the chart type click event mapping master 106a5 and the chart click event obtainable value master 106a6, and are therefore converted into codes during registration.

[0121] 4. Displaying the highlight setting screen will be described with reference to Fig. 58. The highlight item list in area A3 of the highlight setting screen is set as follows.

[0122] The highlight item list in area A3 includes the following items: name of the diagram to be highlighted, name of the item to be highlighted, item using highlight condition value, highlight style highlight target (color, transparency), and highlight style non-highlight target (color, transparency).

[0123] The name of the figure to be highlighted is selected from the figure IDs set in the figure master 106a11. The name of the item to be highlighted is identified by the diagram type ID of the diagram master 106a11 identified from the diagram type highlight item mapping master 106a3, and a list of highlight item IDs is obtained.The name of the highlighted part is identified by the highlight item ID obtained from the diagram highlight item master 106a2, and a list of the highlighted part names is obtained and displayed.The highlight condition value use items are the same as the available items obtained in "When the extraction setting screen is displayed" in Figure 56.

[0124] 5. Registration of the highlight setting screen will be described with reference to Fig. 59. In Fig. 59, when the Confirm button on the highlight setting screen is pressed, a registration process is executed, and the data of the "diagram ID," "click event ID," "highlight target diagram ID," "highlight target item ID," "highlight condition data value ID," "target color," "non-target color," "target transparency," and "non-target transparency" in the highlight event master 106a23 are obtained from the values ​​on the screen and registered. The IDs (codes) corresponding to each value are held in the diagram type highlight item mapping master 106a3 and the diagram highlight item master 106a2, and are therefore converted into codes during registration.

[0125] The correspondence when a preview is executed will be explained with reference to Figs. 60 to 62. Below, we will use the point click "Person in charge B x 2021 / 03" in Figure 1 described under "Point" as an example. Fig. 60 shows the preview before the click, and Fig. 61 shows the result when the point click of "Person in charge B x 2021 / 03" in Figure 1 is executed.

[0126] A method for identifying the extraction target in the case of Figure 60 will be described with reference to Figure 61. 1. Identify the data in extraction event master 106a22 from the clicked chart ID and click event ID. 2. Identify the chart definition to be extracted from chart master 106a11 in the extraction target chart ID column of extraction event master 106a22 identified in 1. 3. Identify the data acquisition definition from data acquisition master 106a8 in the data acquisition ID column of chart master 106a11 identified in 2. 4. Identify the list of data acquisition column definitions from data acquisition column master 106a9 in the data acquisition ID column of data acquisition master 106a8 identified in 3. 5. Identify the data acquisition column definition of the extraction target column from the data acquisition column number column of extraction event master 106a22 identified in 1 from the data acquisition column definitions identified in 4.

[0127] A method for identifying the highlight target in the case of Figure 60 will be described with reference to Figure 62. 1. Identify the data of the highlight event master 106a23 from the clicked chart ID and the click event ID. 2. Identify the chart definition to be highlighted from the chart master 106a11 using the highlight target chart ID column of the highlight event master 106a23 identified in 1. 3. Identify the list of chart type highlight item mapping master 106a3 using the chart type ID of the chart master 106a11 identified in 2. 4. Confirm that the list of chart type highlight item mapping master 106a3 identified in 3 includes the value of the highlight target item ID column of the highlight event master 106a23 identified in 1.

[0128] As described above, according to this embodiment, the system includes extraction event master 106a22 that registers diagrams, click events, and extraction events in association with each other in accordance with operations by a developer on the setting screen, setting unit 102a that sets data for emphasis event master 106a23 that registers diagrams, click events, and emphasis events in association with each other, and display control unit 102b that, when a click event on a diagram occurs, executes extraction processing by referring to extraction event master 106a22 and executes emphasis processing by referring to emphasis event master 106a23.Therefore, by limiting analysis operations to clicking on diagrams and limiting analysis processing to extraction and emphasis, it is possible to reduce the cost of designing a dashboard.

[0129] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0130] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0131] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0132] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0133] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0134] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0135] Furthermore, with regard to the dashboard creation system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0136] For example, all or any part of the processing functions of the dashboard creation system 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the dashboard creation system 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

[0137] This computer program may also be stored in an application program server connected to the dashboard creation system 100 via any network, and all or part of it may be downloaded as needed.

[0138] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0139] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0140] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0141] Dashboard creation system 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. Dashboard creation system 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0142] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0143] 100 Dashboard Creation System 102 Control section 102a Setting section 102b Display control unit 104 Communication interface unit 106 Storage section 106a DB 106a1 Chart type master 106a2 Figure and table highlighting item master 106a3 Chart type highlight item mapping master 106a4 Chart Click Event Master 106a5 Chart Type Click Event Mapping Master 106a6 Chart click event obtainable value master 106a7 Dashboard definition master 106a8 Data Acquisition Master 106a9 Data Acquisition Column Master 106a10 Diagram placement master 106a11 Chart Master 106a12 Line Graph Master 106a13 Bar Graph Master 106a14 Stacked Bar Graph Master 106a15 Area Graph Master 106a16 Stacked Area Graph Master 106a17 Pie Chart Master 106a18 Scatter Plot Master 106a19 Heatmap Master 106a20 Bar Graph Master 106a21 Table Column Header Master 106a22 Extraction Event Master 106a23 Emphasis Event Master 106b Data Source 106c Data File 112 Input Device 114 Output Device 300 Network 400 Developer Terminal

Claims

[Claim 1] A dashboard creation system including a control unit, The control unit A setting means for setting data of an extraction event master that registers a diagram, a click event, and an extraction event in association with each other, and an emphasis event master that registers a diagram, a click event, and an emphasis event in association with each other, in accordance with a developer's operation on the setting screen; a display control means for executing an extraction process by referring to the extraction event master when a click event occurs on a chart, and for executing an emphasis process by referring to the emphasis event master; Equipped with The control unit further A diagram master in which a diagram ID, a diagram name, a diagram type ID, and a data acquisition ID are associated and registered; A graph / map master that associates and registers a chart ID and a graph / map creation definition; A data acquisition master in which a data acquisition ID, a data acquisition name, and a stored procedure name are associated and registered; A data acquisition column master in which data acquisition IDs, column numbers, and column names are associated and registered; Business data for abnormal value determination, It is configured to be accessible to The extracted event of the extracted event master includes an extracted data value ID, an extracted chart ID, and an extracted column number, when a click event occurs on a chart, the display control means acquires the clicked chart ID, the click type, and an acquirable value, and refers to the chart master, the graph map master, the data acquisition master, the data acquisition column master, and the extraction event master to draw a graph map and execute extraction processing; The emphasis event of the emphasis event master includes an emphasis target diagram ID, an emphasis target item ID, an emphasis condition data value ID, a target color, an out-of-target color, a target transparency, and an out-of-target transparency, The dashboard creation system is characterized in that the display control means executes emphasis processing on the drawn graph / map by referring to the emphasis event master.

Images