View Source

Using Filters in Views

Filter option is available for Chart, Table, Geo map and KPI label view.

You can access Filter option from toolbox in the upper right corner of the view.

Filter dialog includes list of attributes and indicators used in the view. You can filter either by:

Attribute members
Indicator values

To apply a filter, you have to:

Select Attribute or Indicator for filtering.
Select Condition.
Provide Values for the condition.

BellaDati User Documentation > Using Filters > Screen Shot 2014-07-07 at 09.54.44.png

Filtering by Attribute Members

There are four conditions available:

contains: Allows to select single or more members, which will be displayed within the attribute.
doesn't contain: Allows to select single or more members, which will not be displayed within the attribute.
count: Allows filtering members by their count.
not empty: Hides members with empty (blank) values.
empty: Displays members with empty (blank) values.

Filtering by date and datetime variables

For date and datetime attributes, it is also possible to use relative variables, such as:

now - current date or time
actualMonth - current month
actualYear - current year

Additionally, the variables can be modified with date modifiers:

y - year
m - month
d - day
H - hour
M - minute
s - second

Examples for datetime:

now-1mTnow-1M
now-2dTnow-5H-30M-30s

Examples for date:

now-5d
actualMonth-1m

Filtering by Indicator Values

There are the following conditions available:

equals the value specified
not equal to value specified
lower than value specified
lower than or equal to value specified
greater than value specified
greater than or equal to value specified
not empty
empty

Filtering by indicator values is defined only for basic cases. It can produce unpredictable result if you use complex drill-down paths or date/time dimension.

Hint: See crossValue() function to access all data in the view even if the filter is active. This allows you to calculate eg. ration of some value to total which is not affected by current view filter.

Multiple filters

You can combine different attributes/indicators or even apply more conditions for one attribute/indicator. Multiple filters can be merged with AND or OR condition.

BellaDati User Documentation > Using Filters > Screen Shot 2014-07-07 at 09.57.58.png

Modifying filter

Applied filters are listed under the view title and labeled with Filter tag. In case of attribute filter, you can click on the condition to modify values.

BellaDati User Documentation > Using Filters > Screen Shot 2014-07-07 at 10.01.26.png

Copying Existing Filter

Since BellaDati 2.9.9, it is possible to copy the whole filter configuration from one view to another. The views have to be in the same report.

Open filter settings of a view which does not have any filters.
In the box Copy existing filter and select a view. The filters from the selected view will be copied.

BellaDati User Documentation > Using Filters > image2019-1-17 10:55:58.png

Referencing current user attributes in filter

You can access the current signed user attributes to build the filter. In order to do this, add a custom expression as a filter value:

Name	Description
${user}, ${user.username}	Returns the username of currently signed user
${user.email}	Returns the email of currently signed user
${user.name}	Returns the first name of currently signed user
${user.surname}	Returns the last name of currently signed user
${user.locale}	Returns the user's locale of currently signed user
${user.info}	Returns value from user field additional info.
${domain}, ${domain.name}	Returns the name of currently signed user's domain
${domain.locale}	Returns the locale of currently signed user's domain
${domain.timezone}	Returns the timezone of currently signed user's domain

See example here:

BellaDati User Documentation > Using Filters > 2014-05-16_110330.png

Using wildcards in filters

You can use wildcards in BellaDati which allow you to substitute any number of characters in the custom value.

Name	Description
%	Replace zero or any number of characters.
_	Replace one single character

Using Variables in view filters

See Report Variables and Filters components