Data visualization user interface with seamless online and offline user interaction

A system for data visualization offline interaction, comprising:

• a display;
• one or more processors;
• memory;
• 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:
• sending, to a server, a request for a data visualization previously used by a user, wherein the data visualizations is based on a dataset retrieved from a database using a first set of one or more queries;
• receiving a visualization payload from the server, wherein the visualization payload includes (i) a data model representing the data set retrieved from the database, including data aggregated at a level of detail corresponding to dimension data fields used by the data visualization and (ii) a data visualization library corresponding to the data model, wherein the data visualization library is executable software for rendering data visualizations;
• storing the visualization payload in the memory using a caching mechanism;
• receiving a request from the user for the data visualization;
• in accordance with a determination that the computer has no connectivity with the server:
• retrieving the stored data model and data visualization library;
• generating and displaying the data visualization based on the data model using the data visualization library;
• disabling, on the display, one or more executable user interface affordances for the data visualization, wherein each disabled executable user interface affordance corresponds to a respective feature that is unavailable because it requires retrieval of data not stored in the stored data model;
• detecting user input corresponding to a user interface affordance for a first feature manipulating the data visualization;
• in accordance with a determination that the first feature requires retrieval of data not stored in the stored data model, displaying a tooltip for the user interface affordance, that the first feature is unavailable;
• and
• in accordance with a determination that the first feature does not require retrieval of data not stored in the stored data model:
• retrieving the stored data model and data visualization library;
• generating an updated data visualization according to the user input, the data model, and the visualization library;
• and
• displaying the updated data visualization.

A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors and memory, the one or more programs comprising instructions for:

• sending, to a server, a request for a data visualization previously used by a user, wherein the data visualizations is based on a dataset retrieved from a database using a first set of one or more queries;
• receiving a visualization payload from the server, wherein the visualization payload includes (i) a data model representing the data set retrieved from the database, including data aggregated at a level of detail corresponding to dimension data fields used by the data visualization and (ii) a data visualization library corresponding to the data model, wherein the data visualization library is executable software for rendering data visualizations;
• storing the visualization payload in the memory using a caching mechanism;
• receiving a request from the user for the data visualization;
• in accordance with a determination that the computer has no connectivity with the server:
• retrieving the stored data model and data visualization library;
• generating and displaying the data visualization based on the data model using the data visualization library;
• disabling, on the display, one or more executable user interface affordances for the data visualization, wherein each disabled executable user interface affordance corresponds to a respective feature that is unavailable because it requires retrieval of data not stored in the stored data model;
• detecting user input corresponding to a user interface affordance for a first feature manipulating the data visualization;
• in accordance with a determination that the first feature requires retrieval of data not stored in the stored data model, displaying a tooltip for the user interface affordance, that the first feature is unavailable;
• and
• in accordance with a determination that the first feature does not require retrieval of data not stored in the stored data model:
• retrieving the stored data model and data visualization library;
• generating an updated data visualization according to the user input, the data model, and the visualization library;
• and
• displaying the updated data visualization.