Infoscenting fields for multi-fact data model analysis using shared dimensions
A computing device displays, in a user interface, data field icons corresponding to a plurality of data fields. Each of the data fields is associated with a respective object in an object model. In response to receiving (i) user selection of a first data field icon corresponding to a first data field, and (ii) placement of the first data field icon in a shelf region of the user interface, where the first data field is associated with a first object of the object model, the computing device generates a first data visualization and updates a visual characteristic of a subset of the data field icons from a first visual characteristic to a second visual characteristic. Each data field icon in the subset is associated with a second object of the object model. The data field icons in the subset are user-selectable independently of the first or second visual characteristic.
1. A method for performing guided analysis using multi-fact object models, comprising:
at computing device having a display, one or more processors and memory storing one or more programs configured for execution by the one or more processors:
displaying, in a schema region of a user interface, a plurality of data field icons corresponding to a plurality of data fields, each of the data fields associated with a respective object of a plurality of objects in an object model;
in response to receiving (i) user selection of a first data field icon of the plurality of data field icons in the schema region and (ii) placement of the first data field icon in a shelf region of the user interface, wherein the first data field icon corresponds to a first data field that is associated with a first object of the plurality of objects of the object model:
generating and displaying a first data visualization in the user interface; and
updating a visual characteristic of a subset of the plurality of data field icons that are displayed in the schema region of the user interface from a first visual characteristic to a second visual characteristic, wherein:
each data field icon in the subset of data field icons is associated with a second object of the plurality of objects, distinct from the first object; and
the data field icons in the subset are user-selectable independently of the first visual characteristic or the second visual characteristic.
2. The method of claim 1 , wherein:
updating the visual characteristic of the subset of data field icons from the first visual characteristic to the second visual characteristic includes visually de-emphasizing the subset of data field icons relative to other data field icons in the plurality of data field icons while maintaining user-selectability of the subset of data field icons.
3. The method of claim 1 , further comprising:
while the visual characteristic of the subset of data fields is the second visual characteristic:
in response to a user interaction with a second data field icon from the subset of data field icons, corresponding to a second data field of the plurality of data fields:
displaying information that the second data field is unrelated to the first data field.
4. The method of claim 1 , further comprising:
while the visual characteristic of the first subset of data fields is the second visual characteristic:
in response to receiving (i) user selection of a second data field icon from the subset of data field icons, corresponding to a second data field of the plurality of data fields, and (ii) user placement of the second data field icon in the shelf region:
generating and displaying a second data visualization in the user interface.
5. The method of claim 4 , wherein:
generating the first data visualization includes executing a first query that specifies an aggregation of data values of the first data field; and
generating the second data visualization includes executing a second query that duplicates, for each data value of the second data field, the aggregated data values of the first data field.
6. The method of claim 4 , further comprising:
concurrently while displaying the second data visualization:
displaying, in the shelf region, a warning visual indicator adjacent to the first data field icon; and
in response to a user interaction with the warning visual indicator, displaying information that the second data field is unrelated to the first data field.
7. The method of claim 1 , further comprising:
after updating the visual characteristic of the subset of data field icons to the second visual characteristic:
in response to receiving (i) user selection of a third data field icon from the plurality of data field icons, wherein the third data field icon corresponds to a third data field and is not a data field icon from the subset of data field icons and (ii) placement of the third data field icon in the shelf region:
executing a second query that specifies an aggregation of data values of the first data field according to the third data field to generate a third data visualization; and
displaying, in the user interface, the third data visualization.
8. The method of claim 7 , further comprising:
concurrently while displaying the third data visualization, updating a visual characteristic of the subset of data fields from the second visual characteristic to the first visual characteristic.
9. The method of claim 7 , wherein the third data field is a shared data field that is shared between the first object and the second object.
10. The method of claim 7 , wherein the third data field is associated with a dimension logical table.
11. The method of claim 7 , wherein the third data field is a dimension data field.
12. The method of claim 7 , wherein the third data field is a geographic data field.
13. The method of claim 7 , wherein the third data field is a date/time data field.
14. The method of claim 7 , further comprising:
after displaying the third data visualization:
in response to receiving (i) user selection of a fourth data field icon from the subset of data field icons, corresponding to a fourth data field, and (ii) placement of the fourth data field icon in the shelf region:
executing a third query that specifies an aggregation of data values of the fourth data field according to the third data field to generate a fourth data visualization; and
displaying, in the user interface, the fourth data visualization.
15. The method of claim 14 , wherein the fourth data visualization is concurrently displayed with the third data visualization in the user interface.
16. The method of claim 15 , wherein the third data visualization and the fourth data visualization share a common data axis.
17. A computing device, comprising:
one or more processors;
memory;
a display; and
one or more programs stored in the memory and configured for execution by the one or more processors, the one or more programs comprising instructions for:
displaying, in a schema region of a user interface, a plurality of data field icons corresponding to a plurality of data fields, each of the data fields associated with a respective object of a plurality of objects in an object model;
in response to receiving (i) user selection of a first data field icon of the plurality of data field icons in the schema region and (ii) placement of the first data field icon in a shelf region of the user interface, wherein the first data field icon corresponds to a first data field that is associated with a first object of the plurality of objects of the object model:
generating and displaying a first data visualization in the user interface; and
updating a visual characteristic of a subset of the plurality of data field icons that are displayed in the schema region of the user interface from a first visual characteristic to a second visual characteristic, wherein:
each data field icon in the subset of data field icons is associated with a second object of the plurality of objects, distinct from the first object; and
the data field icons in the subset are user-selectable independently of the first visual characteristic or the second visual characteristic.
18. The computing device of claim 17 , wherein the instructions for updating the visual characteristic of the subset of data field icons from the first visual characteristic to the second visual characteristic include instructions for:
visually de-emphasizing the subset of data field icons relative to other data field icons in the plurality of data field icons while maintaining user-selectability of the subset of data field icons.
19. The computing device of claim 17 , the one or more programs further comprising instructions for:
while the visual characteristic of the first subset of data fields is the second visual characteristic:
in response to a user interaction with a second data field icon from the subset of data field icons, corresponding to a second data field of the plurality of data fields:
displaying information that the second data field is unrelated to the first data field.
20. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computing device having one or more processors, memory, and a display, the one or more programs comprising instructions for:
displaying, in a schema region of a user interface, a plurality of data field icons corresponding to a plurality of data fields, each of the data fields associated with a respective object of a plurality of objects in an object model;
in response to receiving (i) user selection of a first data field icon of the plurality of data field icons in the schema region and (ii) placement of the first data field icon in a shelf region of the user interface, wherein the first data field icon corresponds to a first data field that is associated with a first object of the plurality of objects of the object model:
generating and displaying a first data visualization in the user interface; and
updating a visual characteristic of a subset of the plurality of data field icons that are displayed in the schema region of the user interface from a first visual characteristic to a second visual characteristic, wherein:
each data field icon in the subset of data field icons is associated with a second object of the plurality of objects, distinct from the first object; and
the data field icons in the subset are user-selectable independently of the first visual characteristic or the second visual characteristic.