# US 11,308,131 B2 · Combining visualizations in a business analytic application > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,308,131 B2 - Document ID: US11308131B2 - Status: Granted - Kind: B2 - Application number: 16/880,201 - Filed: 2020-05-21 - Published: 2021-11-25 - Granted: 2022-04-19 - Earliest claimed: 2020-05-21 - Assignees: International Business Machines Corporation - Applicants: International Business Machines Corporation - Inventors: Firas Kazem; Linda Hillis; Anthony Nicola Tasca; Gongjin Zhang - Web page: https://patentgrep.com/patent/US11308131B2 ## CPC - G06F 16/287: {Visualization; Browsing} - G06Q 10/06393: {Score-carding, benchmarking or key performance indicator [KPI] analysis} - G06F 16/24556: {Aggregation; Duplicate elimination} - G06F 17/18: for evaluating statistical data {, e.g. average values, frequency distributions, probability functions, regression analysis (forecasting specially adapted for a specific administrative, business or logistic context G06Q10/04)} - G06N 20/00: Machine learning - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR - G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS ## Abstract In an approach to combining visualizations in a business analytic application, responsive to receiving a plurality of original visualizations from a user, one or more visualization groups are created. A strength score is calculated for each visualization group of the one or more visualization groups. Responsive to the strength score for each visualization group of the one or more visualization groups meeting a minimum threshold score, one or more recommended visualizations are generated, wherein the one or more recommended visualizations are combinations of the plurality of original visualizations. The one or more recommended visualizations are sent to the user. ## Claims ### Claim 1 A computer-implemented method for combining visualizations in a business analytic application, the computer-implemented method comprising: responsive to receiving a plurality of original visualizations from a user: creating, by one or more computer processors, one or more visualization groups in the business analytic application of a device; and calculating, by the one or more computer processors, a strength score for each visualization group of the one or more visualization groups comprising: calculating, by the one or more computer processors, a relationship strength score for said each visualization group of the one or more visualization groups; calculating, by the one or more computer processors, a column strength score for said each visualization group of the one or more visualization groups; and calculating, by the one or more computer processors, the strength score for said each visualization group of the one or more visualization groups based upon the relationship strength score and the column strength score; responsive to the strength score for said each visualization group of the one or more visualization groups meeting a minimum threshold score, generating, by the one or more computer processors, one or more recommended visualizations, wherein the one or more recommended visualizations are combinations of the plurality of original visualizations in the business analytic application; and sending, by the one or more computer processors, the one or more recommended visualizations to the user. ### Claim 2 (depends on 1) The computer-implemented method of claim 1, wherein calculating the relationship strength score for each visualization group of the one or more visualization groups further comprises determining, by the one or more computer processors, at least one of: whether one or more first visualizations of each visualization group of the one or more visualization groups are part of an explicit visual layout group, whether one or more second visualizations of each visualization group of the one or more visualization groups are part of an implicit visual group, whether one or more third visualizations of each visualization group of the one or more visualization groups are part of a same connection group, or whether one or more fourth visualizations of each visualization group of the one or more visualization groups are part of a same drill-through sequence. ### Claim 3 (depends on 1) The computer-implemented method of claim 1, wherein calculating the column strength score for each visualization group of the one or more visualization groups further comprises determining, by the one or more computer processors, at least one of: whether one or more first columns are shared between each visualization group of the one or more visualization groups, whether one or more second columns have comparable measures, whether one or more third columns have an influential relationship, whether one or more fourth columns have a hierarchical relationship, or whether one or more fifth columns differ in one or more data manipulations, wherein the one or more data manipulations include at least one of statistics, filtering, top or bottom truncation, grouping, summary, or aggregation. ### Claim 4 (depends on 1) The computer-implemented method of claim 1, wherein generating the one or more recommended visualizations comprises: determining, by the one or more computer processors, whether one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced; responsive to determining that the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced, deleting, by the one or more computer processors, the one or more excess columns in each visualization group of the one or more visualization groups; determining, by the one or more computer processors, a suitable visualization and a column to slot binding for each visualization group of the one or more visualization groups meeting the minimum threshold score; and recommending, by the one or more computer processors, the one or more recommended visualizations to the user, wherein the one or more recommended visualizations include the suitable visualization and the column to slot binding. ### Claim 5 (depends on 4) The computer-implemented method of claim 4, wherein determining that the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced further comprises determining, by the one or more computer processors, at least one of: whether the one or more excess columns are repeated in each visualization group of the one or more visualization groups meeting the minimum threshold score, whether the one or more excess columns are summaries of other columns, or whether the one or more excess columns are calculations of other columns. ### Claim 6 (depends on 1) The computer-implemented method of claim 1, wherein the threshold is received from the user. ### Claim 7 A computer program product for combining visualizations in a business analytic application, the computer program product comprising one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions including instructions to: responsive to receiving a plurality of original visualizations from a user: create one or more visualization groups in the business analytic application of a device; and calculate a strength score for each visualization group of the one or more visualization groups comprising: calculate a relationship strength score for said each visualization group of the one or more visualization groups; calculate a column strength score for said each visualization group of the one or more visualization groups; and calculate the strength score for said each visualization group of the one or more visualization groups based upon the relationship strength score and the column strength score; responsive to the strength score for said each visualization group of the one or more visualization groups meeting a minimum threshold score, generate one or more recommended visualizations, wherein the one or more recommended visualizations are combinations of the plurality of original visualizations in the business analytic application; and send the one or more recommended visualizations to the user. ### Claim 8 (depends on 7) The computer program product of claim 7, wherein calculating the relationship strength score for each visualization group of the one or more visualization groups further comprises one or more of the program instructions, stored on the one or more computer readable storage media, to determine at least one of: whether one or more first visualizations of each visualization group of the one or more visualization groups are part of an explicit visual layout group, whether one or more second visualizations of each visualization group of the one or more visualization groups are part of an implicit visual group, whether one or more third visualizations of each visualization group of the one or more visualization groups are part of a same connection group, or whether one or more fourth visualizations of each visualization group of the one or more visualization groups are part of a same drill-through sequence. ### Claim 9 (depends on 7) The computer program product of claim 7, wherein calculating the column strength score for each visualization group of the one or more visualization groups further comprises one or more of the following program instructions, stored on the one or more computer readable storage media, to determine at least one of: whether one or more first columns are shared between each visualization group of the one or more visualization groups, whether one or more second columns have comparable measures, whether one or more third columns have an influential relationship, whether one or more fourth columns have a hierarchical relationship, or whether one or more fifth columns differ in one or more data manipulations, wherein the one or more data manipulations include at least one of statistics, filtering, top or bottom truncation, grouping, summary, or aggregation. ### Claim 10 (depends on 7) The computer program product of claim 7, wherein generating the one or more recommended visualizations comprises one or more of the following program instructions, stored on the one or more computer readable storage media, to: determine whether one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced; responsive to determining that the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced, delete the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score; determine a suitable visualization and a column to slot binding for each visualization group of the one or more visualization groups meeting the minimum threshold score; and recommend the one or more recommended visualizations to the user, wherein the one or more recommended visualizations include the suitable visualization and the column to slot binding. ### Claim 11 (depends on 10) The computer program product of claim 10, wherein determining that the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced further comprises one or more of the program instructions, stored on the one or more computer readable storage media, to determine at least one of: whether the one or more excess columns are repeated in each visualization group of the one or more visualization groups meeting the minimum threshold score, whether the one or more excess columns are summaries of other columns, or whether the one or more excess columns are calculations of other columns. ### Claim 12 (depends on 7) The computer program product of claim 7, wherein the threshold is received from the user. ### Claim 13 A computer system for combining visualizations in a business analytic application, the computer system comprising: one or more computer processors; one or more computer readable storage media; and program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the stored program instructions including instructions to: responsive to receiving a plurality of original visualizations from a user: create one or more visualization groups in the business analytic application of a device; and calculate a strength score for each visualization group of the one or more visualization groups comprising: calculate a relationship strength score for said each visualization group of the one or more visualization groups; calculate a column strength score for said each visualization group of the one or more visualization groups; and calculate the strength score for said each visualization group of the one or more visualization groups based upon the relationship strength score and the column strength score; responsive to the strength score for said each visualization group of the one or more visualization groups meeting a minimum threshold score, generate one or more recommended visualizations, wherein the one or more recommended visualizations are combinations of the plurality of original visualizations in the business analytic application; and send the one or more recommended visualizations to the user. ### Claim 14 (depends on 13) The computer system of claim 13, wherein calculating the relationship strength score for each visualization group of the one or more visualization groups further comprises one or more of the program instructions, stored on the one or more computer readable storage media, to determine at least one of: whether one or more first visualizations of each visualization group of the one or more visualization groups are part of an explicit visual layout group, whether one or more second visualizations of each visualization group of the one or more visualization groups are part of an implicit visual group, whether one or more third visualizations of each visualization group of the one or more visualization groups are part of a same connection group, or whether one or more fourth visualizations of each visualization group of the one or more visualization groups are part of a same drill-through sequence. ### Claim 15 (depends on 13) The computer system of claim 13, wherein calculating the column strength score for each visualization group of the one or more visualization groups further comprises one or more of the program instructions, stored on the one or more computer readable storage media, to determine at least one of: whether one or more first columns are shared between each visualization group of the one or more visualization groups, whether one or more second columns have comparable measures, whether one or more third columns have an influential relationship, whether one or more fourth columns have a hierarchical relationship, or whether one or more fifth columns differ in one or more data manipulations, wherein the one or more data manipulations include at least one of statistics, filtering, top or bottom truncation, grouping, summary, or aggregation. ### Claim 16 (depends on 13) The computer system of claim 13, wherein generating the one or more recommended visualizations comprises one or more of the program instructions, stored on the one or more computer readable storage media, to: determine whether one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced; responsive to determining that the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced, delete the one or more excess columns in each visualization group of the one or more visualization groups; determine a suitable visualization and a column to slot binding for each visualization group of the one or more visualization groups meeting the minimum threshold score; and recommend the one or more recommended visualizations to the user, wherein the one or more recommended visualizations include the suitable visualization and the column to slot binding. ### Claim 17 (depends on 16) The computer system of claim 16, wherein determining that the one or more excess columns in each visualization group of the one or more visualization groups meeting the minimum threshold score can be reduced further comprises one or more of the program instructions, stored on the one or more computer readable storage media, to determine at least one of: whether the one or more excess columns are repeated in each visualization group of the one or more visualization groups meeting the minimum threshold score, whether the one or more excess columns are summaries of other columns, or whether the one or more excess columns are calculations of other columns.