USER INTERFACE FOR QUERY COMPOSITION AND DATA VISUALIZATION
Technologies are provided for composition of a query via a user interface and for visualization of data responsive to the query. For example, based on interactions with a user interface, a data model may be defined. The interactions may be drag-and-drop interactions with the user interface. Based on the data model and a data context, the query may be determined and executed.
1 . A method comprising:
determining, by a computing device, based on a first interaction with a user interface, a selection of a first element of the user interface defining a data model, wherein the data model comprises a plurality of data tables;
determining, based on a second interaction with the user interface, a selection of a second element of the user interface defining a data context for the data model, wherein the second element is associated with one or more of: a dimension, a measure, or a filter associated with one or more data records within the plurality of data tables of the data model;
generating, based on the data model and the data context, the query, wherein the query is indicative of one or more of: the dimension, the measure, or the filter associated with the one or more data records; and
causing, based on the query, data responsive to the query to be output at the user interface.
2 . The method of claim 1 , wherein generating the query comprises generating a set expression based on the data model and the data context, wherein the set expression is associated with the data responsive to the query.
3 . The method of claim 1 , wherein the user interface comprises a configuration pane, and wherein determining the selection of the first element comprises:
receiving data indicative of a selection of a first selectable visual element within the configuration pane; and
causing presentation of an overlay element comprising one or more second selectable visual elements comprising the first element.
4 . The method of claim 3 , further comprising:
receiving data indicative of the selection of the first element; and
detecting a drag action that moves the first element from the configuration pane to a viewport pane of the user interface.
5 . The method of claim 1 , further comprising:
receiving data indicative of a selection of a defined selectable visual element within the user interface; and
causing presentation of a second user interface configured to edit a set expression associated with the data responsive to the query, wherein the second user interface comprises an edition pane that presents the query and is configured to receive input data defining one or more changes to the query.
6 . The method of claim 1 , wherein the first interaction and the second interaction each comprise drag-and-drop interactions with the user interface.
7 . The method of claim 6 , wherein the drag-and-drop interactions originate in a configuration pane of the user interface and terminate in a viewport pane of the user interface.
8 . An apparatus, comprising:
one or more processors; and
memory storing processor-executable instructions that, when executed by the one or more processors, cause the apparatus to:
determine, based on a first interaction with a user interface, a selection of a first element of the user interface defining a data model, wherein the data model comprises a plurality of data tables;
determine, based on a second interaction with the user interface, a selection of a second element of the user interface defining a data context for the data model, wherein the second element is associated with one or more of: a dimension, a measure, or a filter associated with one or more data records within the plurality of data tables of the data model;
generate, based on the data model and the data context, the query, wherein the query is indicative of one or more of: the dimension, the measure, or the filter associated with the one or more data records; and
cause, based on the query, data responsive to the query to be output at the user interface.
9 . The apparatus of claim 8 , wherein the processor-executable instructions that cause the apparatus to generate the query further cause the apparatus to generate a set expression based on the data model and the data context, wherein the set expression is associated with the data responsive to the query.
10 . The apparatus of claim 8 , wherein the user interface comprises a configuration pane, and wherein the processor-executable instructions that cause the apparatus to determine the selection of the first element further cause the apparatus to:
receive data indicative of a selection of a first selectable visual element within the configuration pane; and
cause presentation of an overlay element comprising one or more second selectable visual elements comprising the first element.
11 . The apparatus of claim 10 , wherein the processor-executable instructions further cause the apparatus to:
receive data indicative of the selection of the first element; and
detect a drag action that moves the first element from the configuration pane to a viewport pane of the user interface.
12 . The apparatus of claim 8 , wherein the processor-executable instructions further cause the apparatus to:
receive data indicative of a selection of a defined selectable visual element within the user interface; and
cause presentation of a second user interface configured to edit a set expression associated with the data responsive to the query, wherein the second user interface comprises an edition pane that presents the query and is configured to receive input data defining one or more changes to the query.
13 . The apparatus of claim 8 , wherein the first interaction and the second interaction each comprise drag-and-drop interactions with the user interface.
14 . The apparatus of claim 13 , wherein the drag-and-drop interactions originate in a configuration pane of the user interface and terminate in a viewport pane of the user interface.
15 . One or more non-transitory computer-readable media storing processor-executable instructions that, when executed by at least one processor, cause the at least one processor to:
determine, based on a first interaction with a user interface, a selection of a first element of the user interface defining a data model, wherein the data model comprises a plurality of data tables;
determine, based on a second interaction with the user interface, a selection of a second element of the user interface defining a data context for the data model, wherein the second element is associated with one or more of: a dimension, a measure, or a filter associated with one or more data records within the plurality of data tables of the data model;
generate, based on the data model and the data context, the query, wherein the query is indicative of one or more of: the dimension, the measure, or the filter associated with the one or more data records; and
cause, based on the query, data responsive to the query to be output at the user interface.
16 . The one or more non-transitory computer-readable media of claim 15 , wherein the processor-executable instructions that cause the at least one processor to generate the query further cause the at least one processor to generate a set expression based on the data model and the data context, wherein the set expression is associated with the data responsive to the query.
17 . The one or more non-transitory computer-readable media of claim 15 , wherein the user interface comprises a configuration pane, and wherein the processor-executable instructions that cause the at least one processor to determine the selection of the first element further cause the at least one processor to:
receive data indicative of a selection of a first selectable visual element within the configuration pane; and
cause presentation of an overlay element comprising one or more second selectable visual elements comprising the first element.
18 . The one or more non-transitory computer-readable media of claim 17 , wherein the processor-executable instructions further cause the at least one processor to:
receive data indicative of the selection of the first element; and
detect a drag action that moves the first element from the configuration pane to a viewport pane of the user interface.
19 . The one or more non-transitory computer-readable media of claim 15 , wherein the processor-executable instructions further cause the at least one processor to:
receive data indicative of a selection of a defined selectable visual element within the user interface; and
cause presentation of a second user interface configured to edit a set expression associated with the data responsive to the query, wherein the second user interface comprises an edition pane that presents the query and is configured to receive input data defining one or more changes to the query.
20 . The one or more non-transitory computer-readable media of claim 15 , wherein the first interaction and the second interaction each comprise drag-and-drop interactions with the user interface, and wherein the drag-and-drop interactions originate in a configuration pane of the user interface and terminate in a viewport pane of the user interface.