Visualizing time metric database
Disclosed herein are applications and platforms for streamlined production of charts and reports from databases containing time series datasets and/or timestamped data. The applications described herein may employ dynamically retrieve data from data centers to quickly provide options to the user. The platform further allows configuration of the charts and/or reports by providing lists of metrics that may be available in the selected data, and lists of transforms that may be applied to the data. The application may employ dynamic user interfaces, which provide processing of the received time series datasets in a data agnostic manner. As a result, the systems and methods described herein may allow generating charts and reports using a streamlined workflow.
1. A system, comprising:
one or more processors; and
a memory, accessible by the one or more processors, storing instructions that, when executed by the one or more processors, cause the one or more processors to perform operations comprising:
transmitting, to a display device for display, a representation of a graphical user interface (GUI) that includes respective indications of a plurality of visualization templates associated with a table and respective additional indications of one or more input fields for selecting one or both of: (1) a grouped metric from a set of grouped metrics associated with the table, or (2) a transform operation from a set of transform operations associated with the table;
receiving, via the one or more input fields, one or more first inputs indicative of the grouped metric, the transform operation, or both;
determining one or more visualization templates from the plurality of visualization templates associated with the table based on the one or more first inputs indicative of the grouped metric, the transform operation, or both;
transmitting, to the display device for display, an updated representation of the GUI that includes the respective indications of the one or more visualization templates of the plurality of visualization templates;
receiving a second input indicative of a particular visualization template of the one or more visualization templates;
generating a time series report based on: (1) the particular visualization template, and (2) one or both of the grouped metric, or the transform operation; and
transmitting, to the display device for display, a representation of the time series report.
2. The system of claim 1 , wherein the set of grouped metrics corresponds to different types of data stored in the table.
3. The system of claim 1 , wherein the operations comprise determining the plurality of visualization templates based on a type of data of the table before transmitting the representation of the GUI to the display device.
4. The system of claim 1 , wherein the operations comprise:
receiving a request to create a hyperlink associated with the one or more first inputs, the second input, or both, wherein the hyperlink is configured to recreate the time series report using one or more third inputs received prior to the one or more first inputs, the second input, or both, that corresponds to the hyperlink.
5. The system of claim 1 , comprising a time metric database configured to store the table.
6. The system of claim 1 , wherein the operations comprise determining the set of grouped metrics associated with the table before transmitting the representation of the GUI to the display device, wherein the set of grouped metrics is associated with a plurality of time series datasets.
7. The system of claim 1 , wherein the operations comprise determining the set of transform operations associated with the table before transmitting the representation of the GUI to the display device.
8. The system of claim 1 , wherein the one or more first inputs are indicative of the grouped metric and the transform operation, and wherein the time series report is generated based on (1) the particular visualization template, (2) the grouped metric, and (3) the transform operation.
9. The system of claim 1 , wherein each transform operation of the set of transform operations is configured to perform a mathematical operation on a dataset associated with the table.
10. A method, comprising:
transmitting, via a processor to a display device for display, a representation of a graphical user interface (GUI) that includes respective indications of a plurality of visualization templates associated with a table and respective additional indications of one or more input fields for selecting one or both of: (1) a grouped metric from a set of grouped metrics associated with the table, or (2) a transform operation from a set of transform operations associated with the table, wherein each transform operation of the set of transform operations is configured to perform a mathematical operation on a dataset associated with the table;
receiving, via the processor from the one or more input fields, one or more first inputs indicative of the grouped metric, the transform operation, or both;
determining, via the processor, one or more visualization templates from the plurality of visualization templates associated with the table based on the one or more first inputs indicative of the grouped metric, the transform operation, or both;
transmitting, via the processor to the display device for display, an updated representation of the GUI that includes the respective indications of the one or more visualization templates of the plurality of visualization templates;
receiving, via the processor, a second input indicative of a particular visualization template of the one or more visualization templates;
generating, via the processor, a time series report based on (1) the particular visualization template, and (2) one or both of the grouped metric, or the transform operation; and
transmitting, via the processor to the display device for display, a representation of the time series report.
11. The method of claim 10 , comprising:
determining, via the processor, a second set of grouped metrics associated with the table; and
receiving, via the processor, a third input indicative of a second grouped metric of the second set of grouped metrics; and
wherein the time series report is generated based on (1) the particular visualization template, (2) the grouped metric, the transform operation, or both, and (3) the second grouped metric.
12. The method of claim 10 , comprising retrieving the table from a data source, wherein the data source comprises a plurality of files.
13. The method of claim 10 , wherein the one or more first inputs are indicative of the transform operation, and the method comprises dynamically displaying a user interface element for receiving a parameter associated with the transform operation in response to receiving the one or more first inputs.
14. The method of claim 10 , wherein the one or more first inputs are indicative of the transform operation, and the method comprises dynamically displaying a second set of transform operations in response to receiving the one or more first inputs.
15. The method of claim 10 , wherein the plurality of visualization templates comprises a line chart template, a stick chart template, a bar chart template, an area chart template, a spline chart template, or a time-step chart template, or any combination thereof.
16. A non-transitory, computer-readable medium, comprising computer-executable instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
transmitting, to a display device for display, a representation of a graphical user interface (GUI) that includes respective first indications of a plurality of visualization templates associated with a table and respective second indications of one or more input fields for selecting a grouped metric from a set of grouped metrics associated with the table;
receiving, via the one or more input fields, a first input indicative of the grouped metric;
determining one or more visualization templates from the plurality of visualization templates associated with the table based on the first input indicative of the grouped metric;
transmitting, to the display device for display, an updated representation of the GUI that includes the respective first indications of the one or more visualization templates of the plurality of visualization templates;
receiving a second input indicative of a particular visualization template of the one or more visualization templates;
generating a time series report based on (1) the particular visualization template and (2) the grouped metric; and
transmitting, to the display device for display, a representation of the time series report.
17. The non-transitory, computer-readable medium of claim 16 , wherein the representation of the GUI includes respective third indications of one or more second input fields for selecting a transform operation from a set of transform operations associated with the table.
18. The non-transitory, computer-readable medium of claim 17 , wherein the operations comprise receiving, via the one or more second input fields, a third input indicative of the transform operation; and
wherein the one or more visualization templates are determined from the plurality of visualization templates based on the first input indicative of the grouped metric and the third input indicative of the transform operation.
19. The non-transitory, computer-readable medium of claim 18 , wherein the time series report is generated based on (1) the particular visualization template, (2) the grouped metric, and (3) the transform operation.
20. The non-transitory, computer-readable medium of claim 16 , wherein each transform operation of the set of transform operations is configured to perform a mathematical operation on a dataset associated with the table.