JP2022019031A - Graph display system, method and program - Google Patents

Abstract

To provide graph display system, method and program with which it is possible to determine a narrowing condition by a drill down scheme and thereby easily display various graphs useful for analysis processing, thus allowing even a user not accustomed with data analysis or system operation to easily carry out analysis processing.SOLUTION: A graph display system according to the present invention comprises a graph display unit for displaying a first graph that indicates the number of items of acquired data, a candidate display unit for displaying the candidates of a condition for narrowing down the data, and a narrowing execution unit for narrowing down the data on the basis of the narrowing condition selected from the candidates, the graph display unit displaying, together with the first graph, a second graph that indicates a first result obtained by this narrowing down.SELECTED DRAWING: Figure 1

Description

The present invention relates to graph display systems, methods, and programs.

For example, when discovering regional issues, it is effective to aggregate the records of consultation support from various perspectives. For that purpose, it is necessary to perform the actual data processing after deciding what kind of cut (items to be narrowed down and aggregated) to analyze. Graphs displayed from various perspectives are generally used for this type of analysis.

Toyo University Academic Information Repository, "How to Use Actual Data at Regional Comprehensive Support Center-A Trial for [Visualization] of Consultation Business", Welfare and Social Development Research, No. 7, pp. 5-12, March 2015, http://id.nii.ac.jp/1060/00007351/, (Searched on June 30, 2nd year of Reiwa)

However, for municipal employees who are unfamiliar with system operation, it takes time and effort to display the graph as expected.

Normal graph display is (1) "determine the type of graph", (2) "determine the data format required to draw the graph", (3) "create data for drawing the graph". Therefore, it is carried out in the flow of (4) "narrowing down and totaling data" and (5) "graphing" to narrow down and determine the items to be totaled.

However, for staff who are inexperienced in data analysis and graph display, it takes time and effort to determine graph setting conditions such as which graph is suitable, which items should be narrowed down, and how to aggregate.

In this way, there is a problem that it is not easy for municipal employees who are unfamiliar with data analysis and system operation to analyze regional issues using graphs.

The present invention has been made in view of such circumstances, and by determining the narrowing conditions by a drill-down method, various graphs useful for analysis processing can be easily displayed, and thus data analysis and system operation can be performed. It is an object of the present invention to provide a graph display system, a method, and a program that enable an inexperienced user to easily perform an analysis process.

That is, the invention of claim 1 is selected from the graph display unit that displays the first graph showing the number of acquired data, the candidate display unit that displays the candidates for the narrowing conditions for the data, and the candidates. The graph display unit includes a narrowing down execution unit that narrows down the data based on the narrowing down conditions, and the graph display unit displays a second graph showing the first result obtained by the narrowing down. It is a graph display system that displays together with the graph of 1.

In the invention of claim 2, the candidate display unit displays candidates for narrowing conditions for the first result, and the narrowing execution unit displays the narrowing conditions selected from the candidates. The result of 1 is narrowed down, and the graph display unit displays a third graph showing the second result obtained by this narrowing down at least among the first graph and the second graph. The graph display system according to claim 1, which is displayed together with any of the above.

In the invention of claim 3, the candidate display unit displays candidates for narrowing conditions for the data, and the narrowing execution unit displays the data based on another narrowing condition selected from the candidates. The graph display unit displays a third graph showing the second result obtained by the narrowing down together with at least one of the first graph and the second graph. , The graph display system according to claim 1.

In the invention of claim 4, the candidate display unit displays candidates for narrowing conditions for the second result, and the narrowing execution unit displays the narrowing conditions selected from the candidates. When N is an integer of 2 or more by narrowing down the results of 2 and repeating that the graph display unit repeatedly displays a fourth graph showing the third result obtained by this narrowing down. , The candidate display unit displays the candidates for the narrowing condition for the Nth result, and the narrowing execution unit narrows down the Nth result based on the narrowing condition selected from the candidates. The graph display system according to claim 2 or 3, wherein the graph display unit displays a (N + 2) th graph showing the result of the first (N + 1) obtained by this narrowing down.

In the invention of claim 5, when M is an integer of 1 or more, the narrowing condition for the result of the M th is to narrow down all the series associated with the data displayed in the graph of the M th. The graph display system according to claim 4, which is one of a condition and a narrowing condition for any one series associated with the data displayed in the Mth graph. ..

The invention of claim 6 displays a first graph showing the number of acquired data, displays candidates for narrowing conditions for the data, and based on the narrowing conditions selected from the candidates, the data. This is a graph display method in which a second graph showing the first result obtained by the narrowing down is displayed together with the first graph.

The invention of claim 7 displays candidates for narrowing conditions for the first result, narrows down the first result based on the narrowing conditions selected from the candidates, and by this narrowing down. The graph display method according to claim 6, wherein the third graph showing the obtained second result is displayed together with at least one of the first graph and the second graph.

The invention according to claim 8 displays candidates for narrowing conditions for the data, narrows down the data based on another narrowing condition selected from the candidates, and obtains the narrowing down. The graph display method according to claim 6, wherein the third graph showing the result of 2 is displayed together with at least one of the first graph and the second graph.

The invention of claim 9 displays candidates for narrowing conditions for the second result, narrows down the second result based on the narrowing conditions selected from the candidates, and by this narrowing down. By repeating the display of the fourth graph showing the obtained third result, when N is an integer of 2 or more, the candidates for the narrowing condition for the Nth result are displayed and selected from these candidates. 7. It is a graph display method described in.

In the invention of claim 10, when M is an integer of 1 or more, the narrowing condition for the result of the M th is to narrow down all the series associated with the data displayed in the graph of the M th. The graph display method according to claim 9, which is one of a condition and a narrowing condition for any one series associated with the data displayed in the Mth graph. ..

The invention of claim 11 is a program for displaying a graph, a function of displaying a first graph showing the number of acquired data, a function of displaying candidates for narrowing conditions for the data, and the candidate. A function of narrowing down the data based on the narrowing conditions selected from, and a function of displaying a second graph showing the first result obtained by this narrowing down together with the first graph. It is a program to be realized in a computer.

The invention of claim 12 is a function of displaying candidates for narrowing conditions for the first result, and a function of narrowing down the first result based on the narrowing conditions selected from the candidates. A claim for further realizing in the computer a function of displaying a third graph showing a second result obtained by narrowing down together with at least one of the first graph and the second graph. Item 11 is the program.

The invention of claim 13 is obtained by a function of displaying candidates for narrowing conditions for the data, a function of narrowing down the data based on another narrowing condition selected from the candidates, and the narrowing down. 11. The eleventh aspect of claim 11 for further realizing a function of displaying a third graph showing a second result together with at least one of the first graph and the second graph in the computer. It is a program.

The invention of claim 14 is a function of displaying candidates for narrowing conditions for the second result, and a function of narrowing down the second result based on the narrowing conditions selected from the candidates. By repeating the function of displaying the fourth graph showing the third result obtained by the narrowing down, when N is an integer of 2 or more, the function of displaying the candidates for the narrowing down condition for the Nth result, this function. A function of narrowing down the Nth result based on the narrowing conditions selected from the candidates, and a function of displaying a (N + 2) th graph showing the (N + 1) th result obtained by this narrowing down. The program according to claim 12 or 13, for further realizing the above-mentioned computer.

In the invention of claim 15, when M is an integer of 1 or more, the narrowing condition for the result of the M th is to narrow down all the series associated with the data displayed in the graph of the M th. The program according to claim 14, which is one of a condition and a narrowing condition for any one series associated with the data displayed in the graph M.

According to the graph display system, method, and program of the present invention, various graphs useful for analysis processing can be easily displayed by determining the narrowing conditions by a drill-down method, so that the person is unfamiliar with data analysis and system operation. Even a simple user can easily perform the analysis process.

FIG. 1 is a configuration diagram showing an example of a graph display system to which the graph display method according to the embodiment of the present invention is applied. FIG. 2 is a functional block diagram showing a graph display system to which the graph display method according to the embodiment of the present invention is applied. FIG. 3 is a schematic diagram for explaining the function of the graph display module 21. FIG. 4 is a diagram showing an example of a graph displayed by the graph display module. FIG. 5 is a schematic diagram showing the details of the initial display screen. FIG. 6 is a diagram showing an example of the graph edit generation menu G displayed when the graph edit generation module 22 is started. FIG. 7 is a diagram showing an example of drawing data and detailed data. FIG. 8 is a diagram illustrating candidates for narrowing conditions. FIG. 9 is a diagram illustrating candidates displayed by the candidate display module. FIG. 10 is a diagram illustrating a candidate for the second item displayed by the graph edit generation module. FIG. 11 is a diagram for explaining the operation when the switching to the change with time G4 is selected. FIG. 12 is a diagram showing an example of switching graphs. FIG. 13 is a diagram showing an operation example of displaying a scatter plot and a bubble chart.

Hereinafter, a graph display system to which the graph display method according to the embodiment of the present invention is applied will be described with reference to the drawings.

In the following description of the embodiment, the same parts will be indicated by using the same reference numerals, and duplicate explanations will be avoided.

(Constitution)
FIG. 1 is a configuration diagram showing an example of a graph display system to which the graph display method according to the embodiment of the present invention is applied.

In the following description, an example of displaying a graph based on welfare consultation-related information collected at a government office or a government office will be described, but the graph display system to which the graph display method according to the embodiment of the present invention is applied will be used. It should be noted that the objects displayed in the graph are not limited to the welfare consultation-related information collected at the government offices and offices, but can also be applied to general information.

The graph display system 10 is realized by a computer such as a server, and is communicably connected to a plurality of terminals 80 such as a PC or a tablet via a wired or wireless communication network 70, for example, to the terminal 80. And provides a graph display program.

Each of the plurality of terminals 80 is arranged in, for example, a government office or a department in charge of the government office.

The network environment as illustrated in FIG. 1 may include a LAN such as Ethernet (registered trademark), or a WAN or the like to which a plurality of LANs are connected via a public line or a dedicated line. In the case of LAN, it is composed of a large number of subnets via routers as needed. Further, in the case of WAN, a firewall or the like for connecting to a public line is appropriately provided, but the illustration and detailed description thereof are omitted here.

FIG. 2 is a functional block diagram showing a graph display system to which the graph display method according to the embodiment of the present invention is applied.

The electronic circuit of the graph display system 10 includes a CPU 12, a recording medium reading unit 14, a communication unit 15, a memory 20, and a storage device 30 connected to each other by a bus 11.

The memory 20 stores a graph display module 21, a graph edit generation module 22, a candidate display module 23, and a narrowing down execution module 24 as a program for realizing a graph display system.

These program modules 21 to 23 may be stored in the memory 20 in advance, or may be read and stored in the memory 20 from an external recording medium 13 such as a memory card via the recording medium reading unit 14. You may. These program modules 21 to 23 cannot be rewritten.

In the memory 20, in addition to such a user-unwritable area, a writable data area 29 is secured as an area for storing rewritable data.

The CPU 12 is an example of one or a plurality of processors capable of executing each program module 21 to 24, and controls the operation of each part of the circuit according to each program module 21 to 24.

The storage device 30 includes a consultation relational database 31, an analysis database 32, and a graph display database 33. Hereinafter, the database is abbreviated as "DB".

The consultation-related DB 31 is a database in which data acquired by, for example, the welfare-related departments of government offices and government offices are accumulated, and is data related to welfare consultation, data on the progress of support provided in response to welfare consultation, and persons who visit the welfare consultation. It stores a consultation content table 31a in which data such as address data, data on a support target person who receives welfare support, and data such as the content of welfare consultation are recorded.

Although the consultation-related DB 31 is shown as a part of the graph display system 10 in FIG. 2 for convenience of explanation, the consultation-related DB 31 may be provided in an external system of the graph display system 10. In this case, the graph display system 10 can access the consultation-related DB 31 via the communication network via the communication unit 15.

The analysis DB 32 is a database that stores the analysis consultation relation table 32a created by the graph display module 21.

The graph display DB 33 is a database that stores the minimum graph display data 33a necessary for issuing a graph display and content data acquisition query for each graph displayed on the dashboard 84 of the terminal 80.

The storage device 30 includes, for example, an SSD (Solid State Drive), an HDD (Hard Disk Drive), or the like.

The communication unit 15 is connected to the communication network 70, and controls the transmission and reception of information between the terminal 80 and the graph display system 10 made via the communication network 70. A lot of information is transmitted and received between the terminal 80 and the graph display system 10, all of which is done via the communication unit 15. In the following description, duplication of explanation that the information transmission / reception between the terminal 80 and the graph display system 10 is performed by the communication unit 15 is avoided.

The graph display module 21 displays, for example, a first graph (for example, a pie chart) showing the number of data acquired by a government office or a welfare-related department of the government office and stored in the consultation-related DB 31.

FIG. 3 is a schematic diagram for explaining the function of the graph display module 21.

The graph display module 21 extracts necessary data from the data stored in the consultation relation DB 31, creates a consultation relation table 32a for analysis, and stores it in the analysis DB 32.

Specifically, the graph display module 21 creates an analysis consultation relation table 32a by duplicating the consultation content table 31a and stores it in the analysis DB 32.

The graph display system 10 does not allow the user to specify anything at the operation stage of the graph display module 21 in order to enable graph-first processing.

Since the information stored in the consultation-related DB 31 is master information, it is updated at any time when there is a change in the data content. On the other hand, the analysis performed by the graph display system 10 may take a long time, such as across days, depending on the content. Therefore, the graph display module 21 duplicates the information stored in the consultation-related DB 31 and stores it in the analysis DB 32 so that the analysis does not affect the transfer process.

FIG. 4 is a diagram showing an example of a graph displayed by the graph display module 21.

As illustrated in FIG. 4, the graph display module 21 displays the consultation content data in the data display area 90 including the pie chart f1 showing the number of consultation content data (1500) recorded in the consultation relationship table 32a for analysis. Is displayed from the dashboard 84 of the terminal 80 together with the aggregation period g (April 1, 2017 to September 1, 2019).

FIG. 5 is a schematic diagram showing the details of the initial display screen.

As illustrated in FIG. 5, the data display area 90 includes a title bar A, an edit icon B, a display area C, a graph area D, a series area E, and a narrowing condition display area F.

The example shown in FIG. 5 is an example showing only one pie chart f1 showing the number of cases in one aggregation period, but the graph display module 21 shows a plurality of pie charts showing the number of cases in a plurality of aggregation periods. It is also possible. In this case, the user can click the title bar A with the mouse and then switch the front and back of the display position by dragging and dropping with the mouse.

The edit icon B is also displayed at the right end of the title bar A, and when the user clicks the edit icon B with the mouse, a menu showing functions such as [Delete Graph] and [Enlarged Display] is displayed. When the user clicks [Delete Graph] with the mouse, the graph is deleted, and when the user clicks the [Enlarged Display] icon, the graph is enlarged and displayed in the center of the dashboard 84.

In the display area C, the name of the data that is the aggregation source is displayed.

A pie chart f1 is displayed in the graph area D. In addition to the graph, the series name can also be displayed.

The narrowing-down condition display area F displays the narrowing-down condition.

Left-clicking the mouse at any place in the data display area 90 activates the graph edit generation module 22.

FIG. 6 is a diagram showing an example of the graph edit generation menu G displayed when the graph edit generation module 22 is started.

The graph edit generation menu G has, as items, breakdown data display G1, narrowing down G2, additional aggregation G3, switching to change over time G4, graph switching G5, aggregation source data switching G6, aggregation source data display addition G7, and scatter. Includes figures and bubble chart G11.

FIG. 7 is a diagram showing an example of drawing data and detailed data.

When the breakdown data display G1 is selected by the user by clicking the mouse or the like, the graph edit generation module 22 displays the graph drawing data H as shown on the left side of FIG. 7.

In the graph drawing data H shown on the left side of FIG. 7, when [Breakdown] is further specified by the user by clicking the mouse or the like, the graph edit generation module 22 displays the detailed data I in the table shown on the right side of FIG. (Here, the display of the contents of the detailed data is omitted).

In the detailed data I, it is possible to switch (go back and forth) to each table, and the table to be displayed first changes according to the data of the aggregation source (consultation content, support target person, support progress, etc.).

In the graph edit generation menu G, when the narrowing down G2 is selected by the user by clicking the mouse or the like, the candidate display module 23 is activated.

FIG. 8 is a diagram illustrating candidates for narrowing conditions.

As illustrated in FIG. 8, the candidate display module 23 displays the candidate J of the narrowing condition for the data stored in the consultation relation DB 31.

Candidate J for narrowing down conditions includes consultation content J1, support target person J2, and support progress (support information) J4 as major items.

The consultation content J1 includes the consultation reception date J11, the consultation type / details J12, the consultation route J13, and the received section / institution J14.

The support target person J2 includes a personally designated J21, an additional date J22, a gender J23, an age J24, and existing / non-existing J25.

Support progress (support information) J4 includes support date J41 and support section / person / institution J42.

When any one of the candidates J shown in FIG. 8 is selected from J11 to J14, J21 to J25, and J41 to J42 by the user by clicking the mouse or the like, the candidate display module 23 further displays the data of the selected item. The selection screen J'corresponding to the format is displayed.

Then, from this selection screen J', the data conditions are further narrowed down by the user by clicking the mouse or the like, and when the selection of the narrowing down conditions is completed, the narrowing down execution module 24 is activated.

The narrowing down execution module 24 executes narrowing down for data based on the narrowing down conditions selected by the user in this way, and outputs the result to the graph display module 21.

The graph display module 21 generates a new graph f2 based on the result output from the narrowing down execution module 24, and displays it from the new graph display area 92. The new graph display area 92 is also displayed from the dashboard 84. However, as illustrated in FIG. 8, the graph display module 21 displays the graph display area 92 in the dashboard 84 as a data display area so that the user can proceed with the analysis at a good tempo from the dashboard 84. Instead of overwriting 90, it is displayed in parallel on the right side or lower left of the data display area 90. As described above, the graph display module 21 displays the graph f2 obtained by the narrowing down together with the graph f1.

The number of graph display areas that can be displayed in parallel is, for example, three, but the case of displaying four or more is also included in the present invention.

In the graph edit generation menu G, when the additional tabulation G3 is selected by the user by clicking the mouse or the like, the candidate display module 23 is activated.

FIG. 9 is a diagram illustrating candidates displayed by the candidate display module.

As shown on the left side of FIG. 9, the candidate display module 23 displays a list of candidate K items to be aggregated.

Candidate K includes, as major items, the general tendency K1 of consultation, the attribute K2 of the support target person, the bias of the consultation amount (section / institution) K4, and the status / tendency K5 of support.

The general tendency K1 of consultation includes the consultation type / details K11 and the consultation route K12.

The attribute K2 of the support target person includes K21 for each individual, gender K23, and age K24.

Bias of consultation amount (section / institution) K4 includes the section / institution K41 that has been accepted.

Support status / trend K5 includes support section / person / institution K51.

The user can specify up to two items, one item at a time, from the candidate K as shown on the left of FIG. 9 by clicking the mouse or the like.

First, a case where the user specifies the first item will be described.

When an item is selected by the user from the candidate K by clicking the mouse or the like, the narrowing down execution module 24 executes narrowing down based on the selected candidate and outputs the result to the graph display module 21.

The graph display module 21 creates a graph f3 based on the result output from the narrowing down execution module 24, and displays it from a new graph display area 94. The new graph display area 94 is also displayed from the dashboard 84. However, as illustrated in FIG. 9, the graph display module 21 displays the graph display area 94 in the dashboard 84 as a data display area so that the user can proceed with the analysis at a good tempo from the dashboard 84. Instead of overwriting 90, it is displayed in parallel on the right side or lower left of the data display area 90. As described above, the graph display module 21 displays the graph f3 obtained by the narrowing down together with the graph f1. The state of the graph f3 is stored in the graph display DB 33 as graph display data 33a.

The number of graph display areas that can be displayed in parallel is, for example, three, but the case of displaying four or more is also included in the present invention.

Next, a case where the user specifies the second item will be described.

FIG. 10 is a diagram illustrating a candidate for the second item displayed by the graph edit generation module.

In order for the user to specify the second item, the graph edit generation module 22 displays a graph edit generation menu L that displays a list of candidates for the second item, as shown in FIG.

The second item is a narrowing condition for further totaling the graph generated by designating the first item.

The graph edit generation menu L includes breakdown data display L1, narrowing down L2, additional aggregation L3, switching to change over time L4, graph switching L5, aggregation source data switching L6, aggregation source data display addition L7, and aggregation item switching L10. including.

When the second item is specified from the graph edit generation menu L, the items already used in the aggregation of the first item are grayed out.

When the breakdown data display L1 is selected, the graph display module 21 performs the same operation regardless of the number of items. Further, when the narrowing down L2 is selected, the narrowing down execution module 24 performs the same operation regardless of the number of items.

Additional tabulation L3 and switching to change over time L4 are options for selecting which series in the graph should be processed, and when all graphs are tabulated together, the second item has been tabulated. In the case of, it is grayed out.

The display addition L7 of the aggregation source data and the display addition L9 of the required time are displayed only in the case of the first item, and are setting items for switching the graph to the scatter chart or the bubble chart.

When the tabulation item switching L10 is selected by the user by clicking the mouse or the like, the narrowing down execution module 24 operates for another tabulation item, and a new graph can be generated.

By selecting a desired item from the graph edit generation menu L, as shown in M in FIG. 10, one graph can be extracted and aggregated (M1), or all graphs can be aggregated together (M2). ) Is also possible.

When one graph is extracted and aggregated (M1), the graph edit generation module 22 displays the option N for selecting the series name. Accordingly, the user can select a desired series from the series names displayed in option N by clicking the mouse or the like.

The narrowing down execution module 24 narrows down the data in the selected series, and outputs the result to the graph display module 21.

The graph display module 21 creates a graph f4 based on the result output from the narrowing down execution module 24, and displays it from the new graph display area 96. The new graph display area 96 is also displayed from the dashboard 84. However, the graph display module 21 does not overwrite the graph display area 96 on the data display areas 90 and 94 on the dashboard 84 so that the user can proceed with the analysis from the dashboard 84 at a good tempo. , Display in parallel on the right side or the lower left of at least one of the data display areas 90 and 94. As described above, the graph display module 21 displays the graph f4 obtained by the narrowing down together with at least one of the graphs f1 and f3. Further, it is also possible to execute the above-mentioned additional aggregation L3 from the graph f4.

Then, the execution of the above-mentioned additional aggregation L3 can be repeated (drilled down) for the graph obtained as a result.

On the other hand, when all the graphs are aggregated together (M2), the graph edit generation module 22 displays the aggregated items. When the user selects a summary item by clicking the mouse or the like in response to this, the narrowing down execution module 24 executes narrowing down based on the selected summary item and outputs the result to the graph display module 21. The graph display module 21 generates a new graph f5 based on the result output from the narrowing down execution module 24, and displays it from the new graph display area 98. The new graph display area 98 is also displayed from the dashboard 84. However, the graph display module 21 does not overwrite the graph display area 98 on the data display areas 90 and 94 on the dashboard 84 so that the user can proceed with the analysis from the dashboard 84 at a good tempo. , Display in parallel on the right side or the lower left of at least one of the data display areas 90 and 94. As described above, the graph display module 21 displays the graph f5 (for example, a bar graph) obtained by narrowing down together with at least one of the graphs f1 and f3. Further, it is also possible to execute the above-mentioned additional aggregation L3 for one of the graphs f5.

Then, the execution of the above-mentioned additional aggregation L3 can be repeated (drilled down) for the graph obtained as a result.

FIG. 11 is a diagram for explaining the operation when the switching to the change with time G4 is selected.

In the graph edit generation menu G, when the user selects the switch G4 to change over time by clicking the mouse or the like, as shown in FIG. 11, two items, that is, one graph is extracted and the total G41 is all. G42 is displayed together with the graphs of.

In response to this, when the user selects G41 by clicking the mouse or the like, the graph edit generation module 22 displays the selection screen Q. The selection screen Q is for displaying the series name as an option, and the user can select the series name for which the change with time is desired to be displayed from the displayed series name by clicking the mouse or the like.

When the user selects the series name by clicking the mouse or the like, the graph edit generation module 22 displays the setting screen R.

The setting screen R is a condition for setting the period for displaying the series name selected on the selection screen Q (yearly R1, semi-annual R2, three-monthly R3, monthly R4, etc.). And weekly R5) is displayed.

When the user selects, for example, R1 for each year from the setting screen R, the narrowing down execution module 24 corresponds to the series name “aaaaaa” selected on the selection screen Q every year (in the example shown in FIG. 11, the past 30). The data of months) is output to the graph display module 21.

The graph display module 21 creates a bar graph based on the data output from the narrowing down execution module 24, and displays it in the graph display area 102. The graph display area 102 is also displayed on the dashboard 84 in parallel with other graph display areas.

On the other hand, when the user selects G42 by clicking the mouse or the like, the graph edit generation module 22 does not display the selection screen Q but displays the setting screen R.

In response to this, as described above, when the user selects, for example, yearly R1 from the setting screen R, the narrowing down execution module 24 is carried out yearly (in the example shown in FIG. 11, the past 30 months). ) Is output to the graph display module 21.

The graph display module 21 creates a bar graph for each series name "aaaaaa", "bbbbbb", and "cccccc" based on the data output from the narrowing down execution module 24, and displays the bar graph in the graph display area 104. The graph display area 104 is also displayed on the dashboard 84 in parallel with other graph display areas.

In this way, it is possible to generate a new bar graph showing changes over time at designated delimiters. It should be noted that the subsequent behavior changes depending on whether the first item (G41) is selected or the second item (G42) is selected in the switching to the change with time G4.

In the graph edit generation menu G, when the graph switching G5 is selected by the user by clicking the mouse or the like, the candidate display module 23 displays the options for the graph switching setting displayed on the dashboard 84. When the user selects a graph to be displayed on the dashboard 84 from this option by clicking the mouse or the like, the graph displayed from the dashboard 84 is switched to the selected graph.

FIG. 12 is a diagram showing an example of switching graphs.

Specifically, as shown in FIG. 12, switching between the bar graph (1) representing the aggregation of the first item and the pie chart (2) representing the aggregation of the first item, the second item. Switching between the bar graph (3) representing the aggregation of the items and the bar graph (4) representing the aggregation (stacking) of the second item, the pie chart (2) and the aggregation of the first item are shown. Switching between a line graph (5), switching between a bar graph (4) and a line graph (6) representing the aggregation of the second item, between a bar graph (3) and a line graph (6). There is a switch between them.

In the graph edit generation menu G, when the aggregation source data switching G6 is selected by the user by a mouse click or the like, the candidate display module 23 displays options for switching the aggregation source data for aggregation of the graph. do. The user can select the aggregation source data to be switched from this option. When the source data is selected, a graph is displayed based on the selected source data. Since the graph display has already been explained, avoid duplicate explanations.

In the graph edit generation menu G, when the user selects the display addition G7 of the aggregation source data by clicking the mouse or the like, the candidate display module 23 displays the aggregation source data on the dashboard 84.

In the graph edit generation menu G, when the switching to the required time G8 is selected by the user by clicking the mouse or the like by the mouse or the like, the candidate display module 23 switches from the graph display to the required time display.

In the graph edit generation menu G, when the user selects the required time display addition G9 by clicking the mouse or the like, the candidate display module 23 displays a setting screen for adding the required time display. By setting a desired condition from this setting screen, the user can display the required time to which the set condition is added.

FIG. 13 is a diagram showing an operation example of displaying a scatter plot and a bubble chart.

In the graph edit generation menu G, when the scatter plot and the bubble chart G11 are selected by the user by clicking the mouse or the like, and further, as illustrated in FIG. 13, the graph display area 100 is left with the mouse. When clicked, the candidate display module 23 displays a scatter plot and a bubble chart menu W.

The scatter plot and bubble chart menu W have, as items, breakdown data display W1, narrowing down W2, additional aggregation W3, switching to change over time W4, graph switching W5, aggregation source data switching W6, aggregation source data display addition W7, and Includes switching of summary items W10.

The scatter chart and the bubble chart are special graphs that are displayed only when the first item is aggregated and the addition of the aggregation source data or the addition of the required time is specified. When the graph is displayed, the mode shifts to the dedicated mode.

The transition to the dedicated mode will be described with reference to FIG. When switching to the required time and adding the display are summarized in the aggregation source data, and it is simpler to make the number of consultation contents, the number of support recipients, the number of support information cases, the consultation content required time, and the support information required time. There is.

In such a case, initially only "total" will be used, and "average" and "median" will be supported as functional enhancements. It can be handled simply by increasing the options.

When the display addition W7 of the aggregation source data is selected, the candidate display module 23 displays, for example, three items (consultation content, number of consultations, number of support target persons) as shown in the item table X. This is a data item for a scatter plot.

The data table Z shows an example of aggregation source data for a scatter plot and a bubble chart. In the data table Z, the content of the consultation is described in the first column. In this example, three consultation items (α-inclusive, β-inclusive, and γ-inclusive) are shown. The second column of the data table Z shows the number of consultations, the third column shows the number of support recipients, and the fourth item shows the number of support cases.

The graph display module 21 displays a scatter plot on the two-dimensional coordinates of the number of consultations (horizontal axis) and the number of support recipients (vertical axis) for each consultation content in the data table Z in the graph display area 106. Can be displayed in. Further, a bubble chart in which the number of support cases is displayed by the size of the bubble can be displayed in the graph display area 108. In this way, by extracting only one series and additionally totaling it, a new scatter plot or bubble chart can be generated and displayed.

As described above, according to the graph display system to which the graph display method according to the embodiment of the present invention is applied, an appropriate graph is determined according to the analysis content, and data shaping and the like are automatically performed. Therefore, a user such as a municipal employee can draw a graph by selecting only the items to be narrowed down and aggregated. As a result, even a user who is unfamiliar with graph display and system operation can intuitively perform analysis processing.

Further, according to the graph display system to which the graph display method according to the embodiment of the present invention is applied, after drawing a graph, additional narrowing down / aggregation is performed on the graph to generate a chained graph. It is possible to do. This enables speedy graphing and can bring unexpected awareness to the user.

Although the best mode for carrying out the present invention has been described above with reference to the accompanying drawings, the present invention is not limited to such a configuration. Within the scope of the claimed technical idea, those skilled in the art can come up with various modified examples and modified examples, and these modified examples and modified examples are also the technical scope of the present invention. It is understood that it belongs to.

The graph display system, method, and program of the present invention can be realized as a single device or application, but for example, in a welfare consultation support system that comprehensively manages welfare consultation support operations at a government office or government office. It can also be realized as one of the installed functions.

10 Graph display system 11 Bus 13 External recording medium 14 Recording medium reader 15 Communication unit 20 Memory 21 Graph display module 22 Graph edit generation module 23 Candidate display module 24 Filtering execution module 29 Writable data area 30 Storage device 31 Consultation Database 31a Consultation content table 32 Analysis database 32a Analysis consultation relationship table 33 Graph display database 33a Graph display data 70 Communication network 80 Terminal 84 Dashboard 90 Graph display area 92 Graph display area 94 Graph display area 96 Graph display area 98 Graph display area 98 Graph display area 100 Graph display area 102 Graph display area 104 Graph display area 106 Graph display area 108 Graph display area

The invention of claim 6 is a graph display method implemented by a graph display system, wherein the graph display system displays a first graph showing the number of acquired data, and conditions for narrowing down the data. The second graph showing the first result obtained by displaying the candidates and narrowing down the data based on the narrowing conditions selected from the candidates is shown in the first graph. It is a graph display method to display with.

In the invention of claim 7, the graph display system displays candidates for narrowing conditions for the first result, and narrows down for the first result based on the narrowing conditions selected from the candidates. 6. The graph according to claim 6, wherein a third graph showing the second result obtained by this narrowing down is displayed together with at least one of the first graph and the second graph. It is a display method.

In the invention of claim 8, the graph display system displays candidates for narrowing conditions for the data, and narrows down the data based on another narrowing condition selected from the candidates. The graph display method according to claim 6, wherein the third graph showing the second result obtained by the narrowing down is displayed together with at least one of the first graph and the second graph.

In the invention of claim 9, the graph display system displays candidates for narrowing conditions for the second result, and based on the narrowing conditions selected from the candidates, the second result is narrowed down. By repeating the process of displaying the fourth graph showing the third result obtained by this narrowing down, when N is an integer of 2 or more, the candidates for the narrowing down condition for the Nth result are displayed. Then, based on the narrowing conditions selected from this candidate, the Nth result is narrowed down, and the (N + 2) th graph showing the (N + 1) th result obtained by this narrowing down is displayed. , The graph display method according to claim 7.

Claims (15)

A graph display unit that displays the first graph showing the number of acquired data, and
A candidate display unit that displays candidates for narrowing conditions for the data, and
A narrowing down execution unit that narrows down the data based on the narrowing down conditions selected from the candidates is provided.
The graph display unit is a graph display system that displays a second graph showing the first result obtained by this narrowing down together with the first graph. The candidate display unit displays candidates for narrowing conditions for the first result, and displays the candidates.
The narrowing-down execution unit narrows down the first result based on the narrowing-down conditions selected from the candidates.
According to claim 1, the graph display unit displays a third graph showing a second result obtained by this narrowing down together with at least one of the first graph and the second graph. The graph display system described. The candidate display unit displays candidates for narrowing conditions for the data, and displays the candidates.
The narrowing down execution unit narrows down the data based on another narrowing down condition selected from the candidates.
The first aspect of the present invention, wherein the graph display unit displays a third graph showing a second result obtained by this narrowing down together with at least one of the first graph and the second graph. Graph display system. The candidate display unit displays candidates for the narrowing condition for the second result, and the narrowing execution unit narrows down the second result based on the narrowing condition selected from the candidates. When N is an integer of 2 or more, the candidate display unit displays the fourth graph showing the third result obtained by the narrowing down. The narrowing down condition candidates for the Nth result are displayed, and the narrowing down execution unit narrows down the Nth result based on the narrowing down conditions selected from the candidates, and the graph display unit. The graph display system according to claim 2 or 3, wherein the graph of the second (N + 2) showing the result of the (N + 1) obtained by this narrowing down is displayed. When M is an integer of 1 or more, the narrowing condition for the result of the M is the narrowing condition for all the series associated with the data displayed in the graph of the M and the narrowing condition of the M. The graph display system according to claim 4, which is one of the narrowing conditions for any one series associated with the data displayed in the graph. Display the first graph showing the number of acquired data,
The candidates for the narrowing conditions for the above data are displayed, and
Based on the narrowing conditions selected from the candidates, the data is narrowed down.
A graph display method for displaying a second graph showing the first result obtained by this narrowing down together with the first graph. The candidates for the narrowing conditions for the first result are displayed, and
Based on the narrowing conditions selected from this candidate, the first result is narrowed down.
The graph display method according to claim 6, wherein a third graph showing the second result obtained by this narrowing down is displayed together with at least one of the first graph and the second graph. The candidates for the narrowing conditions for the above data are displayed, and
Based on another narrowing condition selected from the candidates, the data is narrowed down and narrowed down.
The graph display method according to claim 6, wherein a third graph showing the second result obtained by this narrowing down is displayed together with at least one of the first graph and the second graph. Candidates for the narrowing conditions for the second result are displayed, and based on the narrowing conditions selected from the candidates, the second result is narrowed down, and the third result obtained by this narrowing down is performed. By repeating the display of the fourth graph showing, when N is an integer of 2 or more, the candidates for the narrowing condition for the Nth result are displayed, and based on the narrowing condition selected from this candidate. The graph display method according to claim 7 or 8, wherein the Nth result is narrowed down and a (N + 2) graph showing the result of the (N + 1) th obtained by this narrowing down is displayed. When M is an integer of 1 or more, the narrowing condition for the result of the M is the narrowing condition for all the series associated with the data displayed in the graph of the M and the narrowing condition of the M. The graph display method according to claim 9, which is one of the narrowing conditions for any one series associated with the data displayed in the graph. A program for displaying graphs
A function to display the first graph showing the number of acquired data,
A function to display candidates for narrowing conditions for the data,
A function to narrow down the data based on the narrowing conditions selected from the candidates.
A program for realizing a function of displaying a second graph showing the first result obtained by this narrowing down together with the first graph on a computer. A function to display candidates for narrowing conditions for the first result,
A function of narrowing down the first result based on the narrowing conditions selected from these candidates.
To further realize in the computer a function of displaying a third graph showing the second result obtained by this narrowing down together with at least one of the first graph and the second graph. The program according to claim 11. A function to display candidates for narrowing conditions for the data,
A function to narrow down the data based on another narrowing condition selected from the candidates.
A claim for further realizing a function of displaying a third graph showing a second result obtained by this narrowing down together with at least one of the first graph and the second graph. Item 11. The program according to Item 11. A function of displaying candidates for narrowing conditions for the second result, a function of narrowing down the second result based on the narrowing conditions selected from the candidates, and a third obtained by this narrowing down. By repeating the function of displaying the fourth graph showing the result of, when N is an integer of 2 or more, the function of displaying the candidates for the narrowing condition for the Nth result, the narrowing selected from this candidate. Based on the conditions, the computer further realizes a function of narrowing down the Nth result and a function of displaying a (N + 2) th graph showing the (N + 1) th result obtained by this narrowing down. The program according to claim 12 or 13. When M is an integer of 1 or more, the narrowing condition for the result of the M is the narrowing condition for all the series associated with the data displayed in the graph of the M and the narrowing condition of the M. 14. The program of claim 14, which is one of the narrowing conditions for any one series associated with the data displayed in the graph.

Images