Systems and methods for interactive analysis

Patent metadata

Field	Value
Publication number	US-2021406277-A1
Application number	US-202117447521-A
Country	US
Kind code	A1
Filing date	Sep 13, 2021
Priority date	Nov 16, 2017
Publication date	Dec 30, 2021
Grant date	—

Abstract

Systems and methods for generating and rendering interactive analysis are provided. The interactive analysis includes filters that may be provided based upon table relationships and/or persistent data inputs.

First claim

What is claimed is:

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 one or more affordances for selection from the GUI, wherein a first affordance of the one or more affordances enables a first selection of one of a plurality of columns of a data table;
identifying source data records from a data store, wherein each of the source data records comprises the one of the plurality of columns of the data table;
performing an interactive analysis based at least on the source data records, by rendering, in the GUI, one or more interactive widgets configured to present visualized data associated with the source data records;
rendering in the GUI, a filtering dialog box that facilitates filtering out of at least a portion of the visualized data from the GUI;
receiving, via the filtering dialog box, one or more filtering inputs; and
based upon the filtering inputs, updating the rendering, in the GUI, of the one or more interactive widgets, filtering out the at least portion of the visualized data.

2 . The interactive analysis system of claim 1 , wherein the one or more hardware processors are configured to read instructions from the non-transitory memory to perform operations comprising:
providing one or more filtering options from a second data table in the filtering dialog box based upon the data table and the second data table being relationally connected within a threshold degree of separation.

3 . The interactive analysis system of claim 2 , wherein the one or more hardware processors are configured to read instructions from the non-transitory memory to perform operations comprising:
identifying whether the data table and the second data table are relationally connected within a threshold degree of separation, by:
identifying a context of the data table;
identifying related tables that are relationally connected within the threshold degree of separation to the context of the data table; and
determining if the second data table is one of the identified related tables.

4 . The interactive analysis system of claim 2 , wherein the threshold degree of separation is 1.

5 . The interactive analysis system of claim 1 , wherein the one or more hardware processors are configured to read instructions from the non-transitory memory to perform operations comprising:
refraining from providing one or more filtering options from a second data table in the filtering dialog box based upon the data table and the second data table not being relationally connected within a threshold degree of separation.

6 . The interactive analysis system of claim 1 , wherein the one or more hardware processors are configured to read instructions from the non-transitory memory to perform operations comprising:
saving the filtering inputs as a persistent filter.

7 . The interactive analysis system of claim 6 , wherein the one or more hardware processors are configured to read instructions from the non-transitory memory to perform operations comprising:
receiving a request to launch a subsequent interactive analysis session; and in response to the request to launch the subsequent interactive analysis session, providing the persistent filter in the subsequent interactive analysis session.

8 . The interactive analysis system of claim 6 , wherein the one or more hardware processors are configured to read instructions from the non-transitory memory to perform operations comprising:
receiving a request to launch a subsequent interactive analysis session; in response to the request to launch the subsequent interactive analysis session, rendering the subsequent interactive analysis session; receiving, during the subsequent interactive analysis session, a request to load the persistent filter; and in response to the request to load the persistent filter, providing the persistent filter in the subsequent interactive analysis session.

9 . The interactive analysis system of claim 1 , wherein the filtering dialog box comprises a filter side panel.

10 . A tangible, non-transitory computer-readable medium, comprising computer-readable instructions that, when executed by one or more processors, cause the one or more processors to:
render a graphical user interface (GUI) configured to provide one or more affordances for selection from the GUI, wherein a first affordance of the one or more affordances enables a first selection of one of a plurality of columns of a data table; identify source data records from a data store, wherein each of the source data records comprises the one of the plurality of columns of the data table; perform an interactive analysis based at least on the source data records, by rendering, in the GUI, one or more interactive widgets configured to present visualized data associated with the source data records; render in the GUI, a filtering dialog box that facilitates filtering out of at least a portion of the visualized data from the GUI; receive, via the filtering dialog box, one or more filtering inputs; and based upon the filtering inputs, update the rendering, in the GUI, of the one or more interactive widgets, filtering out the at least portion of the visualized data.

11 . The tangible, non-transitory, computer-readable medium of claim 10 , comprising computer-readable instructions that, when executed by one or more processors, cause the one or more processors to:
identify whether the data table and a second data table are relationally connected within a threshold degree of separation, by:
identifying a context of the data table;
identifying related tables that are relationally connected within the threshold degree of separation to the context of the data table; and
determining if the second data table is one of the identified related tables;
upon identifying that the data table and the second data table are relationally connected within the threshold degree of separation, provide one or more filtering options from the second data table in the filtering dialog box; and upon identifying that the data table and the second data table are not relationally connected within the threshold degree of separation, refrain from providing the one or more filtering options from the second data table in the filtering dialog box.

12 . The tangible, non-transitory, computer-readable medium of claim 11 , wherein the threshold degree of separation is 1.

13 . The tangible, non-transitory, computer-readable medium of claim 10 , comprising computer-readable instructions that, when executed by one or more processors, cause the one or more processors to:
save the filtering inputs as a persistent filter.

14 . The tangible, non-transitory, computer-readable medium of claim 13 , comprising computer-readable instructions that, when executed by one or more processors, cause the one or more processors to:
receive a request to launch a subsequent interactive analysis session; and in response to the request to launch the subsequent interactive analysis session, providing the persistent filter in the subsequent interactive analysis session.

15 . The tangible, non-transitory, computer-readable medium of claim 13 , comprising computer-readable instructions that, when executed by one or more processors, cause the one or more processors to:
receive a request to launch a subsequent interactive analysis session; in response to the request to launch the subsequent interactive analy

Assignees

• Servicenow Inc

Inventors

• Ponnada Vijaya Krushna
• Premkumar Senthil
• Kumawat Kapil
• Van Heusden David
• Patel Sandip Devjibhai
• Kondamuri Satyanarayana

Classifications

• G06F16/2465

  Query processing support for facilitating data mining operations in structured databases · CPC title

• G06F16/26 Primary

  Visual data mining; Browsing structured data · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06F2216/03

  Data mining · CPC title