Digest 2025 May

Here’s what’s new in DataTile for May: improvements in moving average calculations, reloading of categorical MR-sets, and a well-thought-out font replacement scheme.

Rolling mode for MA on dashboards

When calculating the Moving Average on the dashboard, there are situations where missing values fall within the specified "window." Now, you can choose which rolling mode option will be used.

Ignore missing values: Missing or zero data points within the window are disregarded. The calculation only averages non-zero numeric values.

Nullify window: Calculating a window that contains missing or zero values will inherently result in a missing data point in the Rolling Trend.

Complete replacement of categories in MR-sets during database re-upload

Now, when the database is reloaded, the system checks the categories in the categorical MR-set and updates the list to match the latest upload exactly.

If an option, such as a brand that is no longer in the market or being studied, is not present in the newly uploaded file, it will be automatically removed from the dataset. This ensures cleaner data and prevents outdated categories from remaining in use.

Font replacement scheme

We explored the frustrating issue of sudden font jumps that occur across different browsers when using DataTile. These unexpected changes can disrupt the look and feel of your dashboards. To fix this, we developed a smart fallback scheme.

Here’s how it works: when rendering a font, the system first looks for an exact match. If the selected font isn't available, it switches to a defined substitute. If that substitute is also missing, the system defaults to the first available font within the same font family.

For example, if 'Arial' is chosen:

• The system will first look for ‘Arial’.

• If unavailable, it will fall back to ‘Helvetica Neue’.

• If neither is found, it will check for any font from the ‘Helvetica’ family.

• As a last resort, it will use the first available sans-serif font.

Here are a few more examples: