What’s new?

With this iteration, you can add manual inputs to multiple variables in one go, in a side-by-side view.

Why does it matter?

Currently, if you want to add a new employee with their start/end date, salary, and bonus, you have to add each one separately. This takes a lot of time and you have to fill out the same information for each one. With this release, you'll be able to link these variables and fill in the information at once.

How does it work? 

In the new pinned column on the right side of the manual input panel, you can now link a variable to one or multiple other variables by clicking on the link icon. This change will make it easier for you to see these variables next to each other both in the module and in Spaces.

What's new?

You can now easily identify if a table or chart is used in another space.

Why does it matter?

This provides better control when making changes across multiple spaces and helps prevent unwanted changes in other spaces.

How does it work?

What's new?

Spaces have a brand new look and feel and more options to customise blocks and report layouts! 

What's included in this release:

• Refreshed Spaces UI: We've given Spaces a fresh new look with an updated visual style for tables, charts, and callouts. You can now also adjust the height of your blocks and control how table columns are displayed as compact or full-width, giving you more flexibility to create polished reports to share or export.
• Flexible report presentation: We understand the significance of presenting your reports effectively. That's why we've introduced a new feature that allows you to set Spaces to a fixed width. This ensures a consistent viewing experience for your audience, regardless of their screen size, and also optimizes the layout for PDF exports.

How does it work?

To set the height of a block go to 6-dots (block contextual menu) and set your preferred height. Try it on side-by-side blocks and it will automatically align them. Full explanation here. 

To adjust the width of spaces go to the 3-dot menu of a space and set it to “fixed”. Everyone visiting the space will now see it exactly like that. Learn how it works here. 

We're excited to announce the release of a new UI for Spaces on October 16th.

With this release, Spaces are getting a fresh new look with more options to customize blocks and the layout of your reports!

Here are some highlights of this update:

• Revamped visual style for tables, charts, and callouts
• Adjustable block heights and table widths
• Choose between dynamic or fixed width for presenting your reports

We believe this update will provide you with greater flexibility to create shinier reports that you can easily share and export with Abacum. 

Please don't hesitate to reach out to your Customer Success partner or dedicated onboarding team with any questions or comments.

What's new?

We've introduced new text manipulation operations in the Data Set Manager, giving you the power to clean and transform your data, making it ready for use in Abacum.

These are the newly added operations:

• MID: Same as its Excel equivalent. It extracts a substring by position indexes. 
• SUBSTITUTE: Looks for the appearance of certain fragments in a text and replaces all occurrences with the desired value. Works in the same way as Substitute in Excel. 
• TEXTSPLIT: Splits text strings by a given delimiter across columns. Then, from the generated splits, it keeps the desired one. 
• TRIM: Removes all spaces from text except for single spaces between words. 

To dive deeper into syntax and the use of operators, check out our academy article.

What’s new? 

Previously, the change input type option was on the top of the manual input panel, and import actuals were under the three-dot menu next to Save changes. 

Now, you can find both options under the 3-dot menu next to the variable name in the table's header.

What's new? 

We've released the first iteration of our transformations editor that will improve your experience when writing formulas and performing transformations. Before, you didn't have feedback on which formulas and syntax were available when making data transformations. Also, the limited space to edit and review formulas made it difficult to interact with the editor. 

In this release, we'll now show you a pop-up within the editor that will allow you to:

• Have an improved experience to visualise your transformations
• Have more space to write, edit and review formulas
• Search and filter through a library of Abacum's transformation formulas
• Access formula descriptions to better understand their usage

Just like before, you click on the + symbol in transformations. In the new pop-up, you can select the column you want to overwrite or type to create a new column. Type your formula in the editor window, and copy and paste the example syntax from the formula library. Once you click "Continue" your transformations will show in the side panel, like before.

For more information, you can check our Academy page.

We are happy to introduce you to our new feature that allows you to Show only relevant dimension filters on spaces!

What's new?

Previously, our filters on spaces showed all possible dimensions users have in the system.

Now, our filters are narrowed down to only the relevant ones (in use) in that space. 

Why does it matter?

🔍 Clarity and Simplicity: Say goodbye to the confusion of seeing irrelevant dimensions cluttering your view. 

🎯 Effortless Navigation: Locate and select the ones you only want to use.

It also represents a relevant performance improvement.

How does it work?

It's simple. Whenever you use the filter on your spaces, you will only see available those dimensions that are in use in that same space.

Considerations:

• If the Space content is modified(add/remove a metric card, add/remove a table), the available dimensions will be refreshed.
• If any of the table variables are changed, the available dimensions will be refreshed.

What's new?

MONTH_FIRST_DAY is a function that calculates the first day of a month based on a given date which has to be a column name.

Why does it matter?

Unlock a new transformation to perform critical date calculations directly in the Web App.

How does it work?

Syntax -> MONTH_FIRST_DAY (transaction_date)

Unifies the dates in the transaction_date column to return the first day of each month.

Considerations:

To learn more about it, please visit this Abacum Academy article.