Product updates

New functionalities:

• New options for pie charts: slice thickness, display center value, display center text. These options combine seamlessly with others previously available (borders, curved corners, number of values displayed, etc.) to provide a much more personalized and dynamic style and detail in each case.

• New options in chart tooltips: configurable totals along with the applied aggregation function. In some charts, starting with this update, you can specify whether a total value should be added to the tooltip, and also specify which function you want to use for its calculation (sum, average, count, maximum, minimum).

Improvements:

• URL parameter preservation. All parts of Biuwer have been integrated to ensure that any URL parameters that may have been specified are always preserved, especially in the Card Editor, where they can be used for dynamic filtering using card filters.

• The "Where it’s used" feature is only available to advanced users. It's considered advanced and has been limited to advanced users of your Biuwer account since this update.

• We report the number of fields in each block of the Card Editor. Sometimes, especially in table cards, many fields are used in queries and in the tables themselves, and it's interesting to know how many fields are being used in each block, as shown below:

• Reverse engineering retrieves fields in the order they are defined in the source. Previously, they were retrieved and sorted alphabetically, but this alters the original order. Starting with this update, the order of the fields is maintained as defined in the source tables or views.

• Simplifying the setup of connections to Google Sheets cloud spreadsheets. To set up a Google Sheets spreadsheet, simply identify its ID, copy it, and paste it into the connection setup box.

• The possibility of having duplicate parameters (n times) in REST API connection configurations has been expanded. This is because some APIs, due to their usage, require specifying the same parameter multiple times, not just once (for example, some Shopify or Factorial API endpoints). In the following example, we have a Factorial HTTP Rest API call, to get the “Attendance” + “Worked Times”, with authentication, pagination and a bunch of “employee_ids[]” set up. From this update onwards, you can specify parameters such as “employee_ids[]” multiple times as needed.

• The Microsoft Business Central connector has been expanded to include DimensionSetLines endpoints. This allows Biuwer to use the analysis dimensions you define in your Business Central account.

Bug fixes:

• Fixed an issue reported when querying data on date fields in Clickhouse.

• Date formatting has been applied to calculated fields in charts.

• The Biuwer query engine has been adjusted to consider empty strings as valid values in text fields.

• Fixed an issue reported in charts where, in some cases, the first value was not displayed if it was null.

• Adjusted the IS NULL and IS NOT NULL operators when applying conditional formatting to table cards.

• Fixed an issue with the IF function in card calculated fields for cases of very small numeric values, practically 0.

• Fixed an issue reported in map cards where the field dragged to the symbol size was not saved correctly.

• Other minor fixes.