Data visualization system with axis binding
View Patent ↗In one general aspect, the application discloses a data visualization method that includes accessing data tables and receiving an axis binding definition for a particular visualization that relates values in a first of the tables to sets of fields in a second of the tables. A marking indication can then be received that selects one of the values in the first of the tables, and a set of fields in the second table is accessed based on the marking indication and the axis binding definition. This accessed set of fields is presented in the particular visualization for which the axis binding definition was received.
1. A data visualization system comprising a processor and a storage device including instructions that are configured to run on the processor, comprising:
access logic configured to access a plurality of data tables, each including a plurality of records that each include values for a plurality of fields,
query device presentation logic configured to present a plurality of query devices that are responsive to pointing device-based user interaction and that correspond to at least some of the fields in the tables,
visualization logic configured to simultaneously display a plurality of visualizations that each present visual elements that are responsive to filtering functions defined by the query devices, wherein a first of the visualizations corresponds to at least some of the fields in a first of the tables, and a second of the visualizations corresponds to at least some of the fields in a second of the tables, and
axis binding logic responsive to the selection of a value in the first of the tables to define a set of fields in the second of the tables to access in presenting the second visualization to allow pointing device-based user interaction corresponding to the first visualization to cause the second visualization to update, and wherein the axis binding logic is operative to 1) receive a first pointer-based marking indication that selects a first portion of the first visualization corresponding to one of the values in the first of the tables, 2) access a first set of fields in the second table based on the first marking indication and the axis binding definition, 3) present the first accessed set of fields in the second particular visualization for which the axis binding definition was received, 4) receive a second pointer-based marking indication that selects a second portion of the first particular visualization corresponding to another of the values in the first of the tables, 5) access a second set of fields in the second table based on the second marking indication and the axis binding definition, and 6) present the second accessed set of fields in the second particular visualization for which the axis binding definition was received.
2. The system of claim 1 wherein the visualization configured by the axis binding control is a chart.
3. The system of claim 2 wherein the visualization configured by the axis binding control is a line chart.
4. The system of claim 2 wherein the visualization configured by the axis binding control is a bar chart.
5. The system of claim 3 wherein the visualization configured by the axis binding control is a pie chart.
6. The system of claim 1 wherein the visualization configured by the axis binding control is a map.
7. The system of claim 1 wherein the visualization configured by the axis binding control is a plot.
8. The system of claim 7 wherein the visualization configured by the axis binding control is a scatter plot.
9. The system of claim 1 wherein the first table is a table of properties and the second table is a table of experimental results.
10. The system of claim 1 further including an axis binding definition interface responsive to user input to define an axis binding definition for use by the axis binding logic.
11. The system of claim 1 wherein the axis binding definition interface includes an expression definition interface configured to create an axis binding definition that includes an expression.
12. The system of claim 11 wherein the axis binding definition interface includes an expression definition interface configured to create a column-based axis binding definition.
13. The system of claim 12 wherein the expression definition interface is configured to create an expression that determines which column to assign to an axis.
14. The system of claim 11 wherein the expression definition interface is configured to create an expression that can include a plurality of the following functions: binning functions, conversion functions, date and time functions, logical functions, math functions, operators, statistical functions, and text functions.
15. A data visualization method, comprising:
accessing a plurality of data tables each including a plurality of records that each include values for a plurality of fields,
receiving an axis binding definition for a plurality of particular visualizations that relate values in a first of the tables to sets of fields in a second of the tables, wherein a first of the particular visualizations corresponds to at least some of the values in a first of the tables, and a second of the particular visualizations corresponds to at least some of the fields in a second of the tables,
receiving pointer-based filtering commands for at least some of the fields in the tables,
receiving a first pointer-based marking indication that selects a first portion of the first particular visualization corresponding to one of the values in the first of the tables,
accessing a first set of fields in the second table based on the first marking indication and the axis binding definition,
presenting the first accessed set of fields in the second particular visualization for which the axis binding definition was received,
receiving a second pointer-based marking indication that selects a second portion of the first particular visualization corresponding to another of the values in the first of the tables,
accessing a second set of fields in the second table based on the second marking indication and the axis binding definition, and
presenting the second accessed set of fields in the second particular visualization for which the axis binding definition was received.
16. The method of claim 15 further including the steps of receiving an additional axis binding definition for an additional particular visualization that relates values in a one of the tables to sets of fields in another of the tables, and presenting an accessed set of fields in the additional particular visualization for which the additional axis binding definition was received.
17. The method of claim 16 wherein the axis binding definition and the additional axis binding definition relate to different visualizations but a same relationship between the first and second tables.
18. The method of claim 16 wherein the axis binding definition and the additional axis binding definition relate to different visualizations and different relationships between the first and second tables.
19. The method of claim 16 wherein the additional axis binding definition relates to at least a third table.
20. A data visualization system comprising a processor and a storage device including instructions that are configured to run on the processor, comprising:
means for accessing a plurality of data tables each including a plurality of records that each include values for a plurality of fields,
means for receiving an axis binding definition for a plurality of particular visualizations that relate values in a first of the tables to sets of fields in a second of the tables, wherein a first of the particular visualizations corresponds to at least some of the values in a first of the tables, and a second of the particular visualizations corresponds to at least some of the fields in a second of the tables,
means for receiving pointer-based filtering commands for at least some of the fields in the tables,
means for receiving a first pointer-based marking indication that selects a first portion of the first particular visualization corresponding to one of the values in the first of the tables,
means for accessing a first set of fields in the second table based on the first marking indication and the axis binding definition,
means for presenting the first accessed set of fields in the second particular visualization for which the axis binding definition was received,
means for receiving a second pointer-based marking indication that selects a second portion of the first particular visualization corresponding to another of the values in the first of the tables,
means for accessing a second set of fields in the second table based on the second marking indication and the axis binding definition, and
means for presenting the second accessed set of fields in the second particular visualization for which the axis binding definition was received.