aqua data studio your query did not return any results

#AQUA DATA STUDIO YOUR QUERY DID NOT RETURN ANY RESULTS CODE#
#AQUA DATA STUDIO YOUR QUERY DID NOT RETURN ANY RESULTS PLUS#

To create a view with a Measure filter for Freight:ġ. You can also right click a Measure field present in any deck except the Filters deck and choose to have the measure's used in a filter. It is possible to right click and convert a Continuous Dimension back to a Measure while it is inside the Filters Deck to create a filter that takes into account its such as SUM or COUNT or Std.

Measure Filters produce sliders in a deck to the right of the view that allow filtering for:īy default, any Measure field dragged and dropped into the Filters Deck is converted to a Continuous Dimension within the Filters Deck. Continuous fields are always indicated by a green color or green background. To create a Measure Filter (or to create a Continuous Filter), drag a measure or continuous field into the Filters Deck. The bottom of the Dimension Filter deck will indicate the use and type of Top N filter. The Filter dialog allows choosing between Top or Bottom, value or parameter, as well as selectively choosing a particular measure and aggregate function to be used for Top N. You can select the highest N values or the lowest N values, where N is a value you type yourself or pass the value using parameter. When a Dimension Filter is created, it is possible to select from within the Filter deck for that Dimension.Ī filter with Top N (or Bottom N) limits the data included to only those items which are the indicated values for that Dimension. The View will change dynamically as you make modifications to your Filter. For example, ab+c matches 'abbc', 'abdbc', but not 'abc'.Ĥ.

#AQUA DATA STUDIO YOUR QUERY DID NOT RETURN ANY RESULTS PLUS#

'+' The plus sign indicates there are at least one of the missing elements. For example, ab*c matches 'abc', 'abbc', 'abdbc', and so on. '*' The asterisk indicates there are zero or more of the missing elements.

For example, colo?r matches 'colour' but not 'color' or 'colouur'. '?' The question mark indicates there is exactly one of missing element. Wildcard Match uses the following three characters as the wildcards. Wildcard Match - Show only the Values that match a Wildcard expression.Multiple Value (List) - Choose multiple Values from a list - default.Single Value (Dropdown) - Choose only one Value from a dropdown.Single Value (List) - Chose only one Value from a list.Displays only the top N values you select Exclude Values - Hides the Values checked.

Include Values - Displays the Values checked - default.

When your Filter is a Dimension, by default, you see check boxes you can enable to show desired categories.Ĭlicking the triangle to the top right of the Dimension Filter deck presents several ways of selecting which categories in a Dimension are part of the Filter: Notice that to the right a new deck appeared displaying options in the Filter for each of the Currency Codes that exist in the data.

#AQUA DATA STUDIO YOUR QUERY DID NOT RETURN ANY RESULTS CODE#

Drag the Currency Code Dimension from the Data Pane into the Filters deck. Begin by dragging Ship Method from Dimensions into Columns.Ģ. To generate a view with Dimension Filters you will edit the view from the Basic View to only show data for Currency Code GBP in Profit and Deck Type.ġ. Filters are possible for both Dimensions and Measures, and are made by dragging one or more fields into the Filters deck.

Aqua data studio your query did not return any results