Patent attributes
Overlay visualizations are implemented utilizing data of a data layer. A table comprises a measure and two or more different dimensions mapping to a same value range. For visualization, the measure for those dimensions may be plotted along a common axis in a same chart. Accordingly, a query executes a UNION of multiple subqueries. A first subquery aggregates the first dimension over the value range, injecting a constant formula field to identify the original first dimension. A second subquery aggregates the second dimension over the value range, again injecting the constant formula field to identify the original second dimension. UNION of these subquery results presents one larger dataset for input to the overlying visualization layer. The constant formula field may be relied upon to differentiate between the combined dimensions on the common axis, allowing association of the measure values with the original dimensions in the displayed plot (e.g., via coloring).
