US 12,488,015 B2
Systems and methods for interactive analysis
Vijaya Krushna Ponnada, Srikakulam (IN); Senthil Premkumar, Hyderabad (IN); Kapil Kumawat, Hyderabad (IN); David van Heusden, Utrecht (NL); Sandip Devjibhai Patel, Amreli (IN); and Satyanarayana Kondamuri, Hyderabad (IN)
Assigned to ServiceNow, Inc., Santa Clara, CA (US)
Filed by ServiceNow, Inc., Santa Clara, CA (US)
Filed on Sep. 13, 2021, as Appl. No. 17/447,521.
Application 17/447,521 is a continuation of application No. 15/815,118, filed on Nov. 16, 2017, granted, now 11,132,378.
Prior Publication US 2021/0406277 A1, Dec. 30, 2021
Int. Cl. G06F 16/26 (2019.01); G06F 16/2458 (2019.01)
CPC G06F 16/26 (2019.01) [G06F 16/2465 (2019.01)] 20 Claims
OG exemplary drawing
 
1. An interactive analysis system, comprising:
a non-transitory memory; and
one or more hardware processors configured to read instructions from the non-transitory memory to perform operations comprising:
rendering a graphical user interface (GUI) configured to provide a plurality of affordances for selection from the GUI, wherein a first affordance of the plurality of affordances enables a first selection of a first one of a plurality of columns of a data table and a second affordance of the plurality of affordances enables a second selection, different from the first selection, of a second one of the plurality of columns of the data table;
identifying source data records from a data store, wherein the source data records comprise the first one and the second one of the plurality of columns of the data table;
performing an interactive analysis based at least on the source data records, wherein the interactive analysis is configured to determine an aggregation of the source data records for the first selection and the second selection by an aggregation type selection;
generating a heatmap of the interactive analysis to display the aggregation of the source data records, wherein the heatmap is generated based on a first set of data corresponding to the first selection and a second set of data corresponding to the second selection, and wherein the aggregation comprises a third set of data displayed directly on the heatmap as numeric values at corresponding intersections of first elements representing the first set of data on the heatmap and second elements representing the second set of data on the heatmap, wherein the heatmap indicates magnitudes of the numeric values as different visual characteristics;
rendering in the GUI, a filtering dialog box that facilitates filtering out of at least a portion of the source data records from the GUI;
providing, in the filtering dialog box, one or more filtering options from a second data table based upon the data table and the second data table being relationally connected within a threshold degree of separation;
receiving, via the filtering dialog box, one or more filtering inputs; and
based upon the filtering inputs, updating the heatmap, filtering out the at least portion of the source data records.