Query-based time-series data display and processing system

1. A system comprising:

a renderer;

at least one processor; and

a storage device configured to store computer-executable instructions, the computer-executable instructions, when executed by the at least one processor, cause the system to at least:

generate user interface data that, when rendered by a user device, causes the user device to display a user interface, wherein the user interface depicts a first data cell;

receive an indication that a first function is entered in the first data cell;

generate a first query using the first function in response to receiving the indication that the first function is entered in the first data cell;

retrieve a plurality of data using the first query;

render a data visualization using the plurality of data; and

update the user interface data such that the user interface displays the rendered data visualization in the first data cell, while storing the first query as a value of the first data cell.

2. The system of claim 1 , wherein the computer-executable instructions are associated with a first application, wherein the storage device is further configured with second computer-executable instructions associated with a second application, the second computer-executable instructions, when executed by the at least one processor, cause the system to at least:

obtain the first query from the first application;

render a second data visualization using the first query; and

generate second user interface data that, when rendered by the user device, causes the user device to display a second user interface, wherein the second user interface includes the rendered second data visualization.

3. The system of claim 2 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

obtain an indication from the second application that the rendered second data visualization is modified;

generate a modified version of the first query using the first function and the obtained indication;

retrieve a modified plurality of data using the modified version of the first query;

rendered a modified data visualization using the modified plurality of data; and

update the user interface data such that the user interface displays the rendered modified data visualization in the first data cell.

4. The system of claim 1 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

receive an indication that a second function is entered in a second data cell, wherein the second function references the first function;

generate a second query using the first function and the second function;

retrieve a second plurality of data using the second query;

render a second data visualization using the second plurality of data; and

update the user interface data such that the user interface displays the rendered second data visualization in the second data cell.

5. The system of claim 4 , wherein the second function references a conditional formatting display operation, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least render the second data visualization according to the conditional formatting display operation in response to a determination that a condition associated with the conditional formatting display operation occurred.

6. The system of claim 4 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

receive an indication that a third function is entered in a third data cell, wherein the third function references the first function, the second function, and a first condition;

generate a third query using the first function, the second function, and the third function;

retrieve a first value using the third query; and

generate a notification in response to a determination that the first value satisfies the first condition.

7. The system of claim 1 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

cache the rendered data visualization; and

retrieve the rendered data visualization from cache in response to reception of a re-paint operation.

8. The system of claim 1 , wherein a first timestamp is stored in a second data cell, wherein the first function references the second data cell, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

generate the query using the first function and the first timestamp;

receive an indication that the second data cell is updated to store a second timestamp;

generate a second query using the first function and the second timestamp;

retrieve a second plurality of data using the second query;

render a second data visualization using the second plurality of data; and

update the user interface data such that the user interface displays the rendered second data visualization in the first data cell, while storing the second query as the value of the first data cell.

9. The system of claim 1 , wherein the first query identifies a number of available cell pixels, and wherein the plurality of data comprises, for each available cell pixel, a minimum value and a maximum value, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least render the data visualization by, for each available cell pixel, drawing a line from the respective minimum value to the respective maximum value.

10. The system of claim 1 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

receive an indication that the first function is pulled to a second data cell, wherein the first function includes a parameter dependent on the location in which the first function is entered; and

enter a second function in the second data cell, wherein the second function comprises the first function with the parameter modified to reflect the location in which the second function is entered.

11. The system of claim 1 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

receive an indication that the first data cell is resized;

generate a modified query using the first function and a representation of a size of the resized first data cell;

retrieve a second plurality of data using the modified query;

render a second data visualization using the second plurality of data; and

update the user interface data such that the user interface displays the rendered second data visualization in the first data cell.

12. The system of claim 11 , wherein the representation of the size of the resized first data cell comprises at least one of a number of available cell pixels in the resized first data cell or a time duration of a single pixel in the resized first data cell.

13. The system of claim 1 , wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least:

receive an indication that the first data cell is selected;

update the user interface data such that the user interface displays a window of a first size;

generate a modified query using the first function and a representation of a size of the window;

retrieve a second plurality of data using the modified query;

render a second data visualization using the second plurality of data; and

update the user interface data such that the user interface displays the rendered second data visualization in the window.

14. The system of claim 1 , wherein the first function comprises a display operation, and wherein the computer-executable instructions, when executed by the at least one processor, further cause the system to at least render the data visualization using the plurality of data and the display operation.

15. The system of claim 1 , wherein the rendered data visualization comprises one of a line graph, a bar graph, a pie graph, a sparkline, an X-Y scatterplot, or a chart.

16. A computer-implemented method comprising:

generating user interface data that, when rendered by a computing device, causes the computing device to display a user interface, wherein the user interface depicts a first data cell;

receiving an indication that a first function is entered in the first data cell;

generating a first query using the first function in response to receiving the indication that the first function is entered in the first data cell;

retrieving a portion of a dataset using the first query;

rendering a data visualization using the retrieved portion of the dataset; and

updating the user interface data such that the user interface displays the rendered data visualization in the first data cell, while storing the first query as a value of the first data cell,

wherein the method is performed using one or more processors.

17. One or more non-transitory, computer-readable storage media storing computer-executable instructions, which if performed by one or more processors, cause the one or more processors to at least:

generate user interface data that, when executed, causes a display of a user interface, wherein the user interface depicts a first data cell;

receive an indication that a first function is entered in the first data cell;

generate a first query using the first function in response to reception of the indication that the first function is entered in the first data cell;

retrieve a portion of a dataset using the first query;

render a data visualization using the retrieved portion of the dataset; and

update the user interface data such that the user interface displays the rendered data visualization in the first data cell, wherein the first query is stored in the first data cell.