Range of Values/Dates -
shows the filtered values as a pair of sliders that you can adjust
to include or exclude more values. Click on the upper and lower
limit readouts to enter the values manually.
The darker area
inside the slider range is called the data bar. It indicates the
range in which data points actually lie in the view. Use this indicator
to determine a filter that makes sense for the data in your data
source. For example, you may filter the Sales field to only include
values between $200,000 and $500,000 but your view only contains
values between $250,000 and $320,000. The range of data you can
see in the view is indicated by the data bar while the sliders show
you the range of the filter.
Data bars only show in filters where
the filtered field is also used in the view (e.g., on Columns, Rows, or
on the Marks card, and son on) and are at the same aggregation level as
the field on the Filters shelf. For example, a quick filter on
SUM(Sales) will only display data bars if the SUM(Sales) field is used
in the view. It won't show if AVG(Sales) is used in the view. Even
though in both scenarios, the filtered field, Sales is used in the view;
in the latter case the aggregation is different than the aggregation of
the filter.
No comments:
Post a Comment