Filters
Filters allow you to ask questions about the data in a simple yet powerful way.
Last updated
Was this helpful?
Filters allow you to ask questions about the data in a simple yet powerful way.
Last updated
Was this helpful?
Filters can be configured at the Page and/or Card level, so they can be applied in chain with each other.
In addition to the usual options for specifying a value for filters, you can use parameters specified in the Pages, Cards, and Collections URL.
Following this example, as added to the URL provided by Biuwer
-> ?date_from=2021-01-01&date_to=2021-12-31
The values that can be specified for a filter in the URL depend on the data type configured in the filter and the following.
It is possible to specify a list of values, for which the separator character "|" must be used between each pair of values. For example: product_id=123|456|789|1092&months=2021-01|2021-02
For date type filters it is necessary to specify the values using the internal format used in Biuwer, which depending on the date level used is one of the following:
Year (YYYY -> 2020)
Year and quarter (YYYY-T -> 2020-4)
Year and month (YYYY-MM -> 2020-12)
Year, month and day (YYYY-MM-DD -> 2020-12-22)
Also in date filters, it is possible to specify predefined formats using a set of values, depending on the date level:
Year: thisYear, previousYear, previousTwoYears, twoYearsAgo, lastTwoYears, lastThreeYears
Quarter: thisQuarter, previousQuarter, previousTwoQuarters, twoQuartersAgo, threeQuartersAgo, lastTwoQuarters, lastThreeQuarters, lastFourQuarters
Month: thisMonth, previousMonth, previousTwoMonths, twoMonthsAgo, threeMonthsAgo, lastTwoMonths, lastThreeMonths, lastSixMonths, lastTwelveMonths
Day: today, yesterday, previousTwoDays, twoDaysAgo, threeDaysAgo, currentWeek, lastSevenDays, lastThirtyDays
The parameters are specified according to the .