SHOWVALUES

To display values from a query in a boxed table use the SHOWVALUES() function in an event. Select the source and the size of your table, a event should trigger. The table can be scrolled through and closed again.

Syntax

=SHOWVALUES(Datasource, Targetrange)

Arguments

Name	Description
Datasource	A cell with a query (e.g. TIMESCALE.SELECT(), TIMEAGGREGATE())
Targetrange	A range to display the data over.

Return

TRUE.

Hint

This function should not be used in a cell

Examples

Formula	Result	Comment
=SHOWVALUES(C6,K2:N7)		If this formula is assigned to a shape event, queried data from C6 will be shown in a table covering K2:N7.