Graphical user interface for a database system
Systems and methods are provided for improved interactive graphical user interfaces. The system allows users to visually construct queries of a database. The system can dynamically generate visual representations of supplemental data and cumulative data. Users can share annotations related to user input queries via the graphical user interface.
1. A computer-implemented method comprising:
by a computer system comprising one or more computer hardware processors and one or more storage devices:
receiving, from a user interface, first user input comprising a plurality of item related query parameters;
executing a query based at least on the plurality of item related query parameters to retrieve item results from one or more databases;
causing presentation, in the user interface, of a first graph of the item results, wherein the item results comprise a plurality of first data value pairs;
receiving, from the user interface, second user input comprising a cumulative option selection;
in response to receiving the second user input, calculating a plurality of cumulative data value pairs, wherein calculating the plurality of cumulative data value pairs comprises:
calculating a current cumulative value from (1) a previous cumulative value, and (2) a current data value from the plurality of first data value pairs; and
causing presentation, in the user interface, of the plurality of cumulative data value pairs as a cumulative graph.
2. The computer-implemented method of claim 1 further comprising:
by the computer system comprising one or more computer hardware processors and one or more storage devices:
receiving third user input comprising a date selection; and
calculating the plurality of cumulative data value pairs starting with the date.
3. The computer-implemented method of claim 1 , wherein the calculating is performed in response to receiving the second user input.
4. The computer-implemented method of claim 1 further comprising:
by the computer system comprising one or more computer hardware processors and one or more storage devices:
calculating a plurality of forecasted cumulative data value pairs; and
causing presentation, in the user interface, of the plurality of forecasted cumulative data value pairs in the cumulative graph.
5. The computer-implemented method of claim 4 , wherein the plurality of forecasted cumulative data value pairs are visually distinguished in the cumulative graph from the plurality of cumulative data value pairs.
6. The computer-implemented method of claim 4 , wherein the plurality of forecasted cumulative data value pairs are calculated starting after a last of the plurality of cumulative data value pairs.
7. The computer-implemented method of claim 4 , wherein the calculating the plurality of forecasted cumulative data value pairs is performed in response to receiving third user input comprising a forecast option selection.
8. The computer-implemented method of claim 1 further comprising:
by the computer system comprising one or more computer hardware processors and one or more storage devices:
constructing the query, wherein constructing the query comprises:
identifying a data source indicated by one of the plurality of item related query parameters; and
determining a query field indicated by one of the plurality of item related query parameters,
wherein the query comprises the query field, and
wherein executing the query is directed towards the data source.
9. The computer-implemented method of claim 1 , wherein the computer system comprises a client device.
10. A system comprising:
a non-transitory computer storage medium configured to at least store computer-executable instructions; and
one or more computer hardware processors in communication with the non-transitory computer storage medium, the one or more computer hardware processors configured to execute the computer-executable instructions to cause the system to at least:
receive, from a user interface, first user input comprising a plurality of item related query parameters;
execute a query based at least on the plurality of item related query parameters to retrieve item results from one or more databases;
cause presentation, in the user interface, of a first graph of the item results, wherein the item results comprise a plurality of first data value pairs;
receive, from the user interface, second user input comprising a cumulative option selection;
in response to receiving the second user input, calculate a plurality of cumulative data value pairs, wherein calculating the plurality of cumulative data value pairs comprises:
calculating a current cumulative value from (1) a previous cumulative value, and (2) a current data value from the plurality of first data value pairs; and
cause presentation, in the user interface, of the plurality of cumulative data value pairs as a cumulative graph.
11. The system of claim 10 , wherein the one or more computer hardware processors configured to execute the computer-executable instructions to further cause the system to at least:
receive third user input comprising a date selection; and
calculate the plurality of cumulative data value pairs starting with the date.
12. The system of claim 10 , wherein the calculating is performed in response to receiving the second user input.
13. The system of claim 10 , wherein the one or more computer hardware processors configured to execute the computer-executable instructions to further cause the system to at least:
calculate a plurality of forecasted cumulative data value pairs; and
cause presentation, in the user interface, of the plurality of forecasted cumulative data value pairs in the cumulative graph.
14. The system of claim 13 , wherein the plurality of forecasted cumulative data value pairs are visually distinguished in the cumulative graph from the plurality of cumulative data value pairs.
15. The system of claim 13 , wherein the plurality of forecasted cumulative data value pairs are calculated starting after a last of the plurality of cumulative data value pairs.
16. The system of claim 13 , wherein the calculating the plurality of forecasted cumulative data value pairs is performed in response to receiving third user input comprising a forecast option selection.
17. The system of claim 10 , wherein the one or more computer hardware processors configured to execute the computer-executable instructions to further cause the system to at least:
construct the query, wherein constructing the query comprises:
identifying a data source indicated by one of the plurality of item related query parameters; and
determining a query field indicated by one of the plurality of item related query parameters,
wherein the query comprises the query field, and
wherein executing the query is directed towards the data source.
18. The system of claim 10 , wherein the system comprises a client device.