Skip to main content

48 posts tagged with "Fixed and Improved"

View All Tags

Fixes and Improvements

  • We have made several improvements to tables:
    • Live connection tables now support up to 50k rows, allowing you to explore larger data sets while maintaining performance. To keep performance, we have limited the display of sample data to 10 rows.
    • Input Table performance has been improved, allowing you to build tables with more rows.
  • You can now create inline results from data views and table aggregations on the first try.
  • Data view titles are now editable again.
  • Formatting text in callout blocks no longer displaces the rest of your text.
  • We have patched a bug that would prevent the menu block from opening again after it was closed.
  • We fixed a bug that caused the notification toast to loop endlessly.
  • We have patched a regression that caused adding weeks to dates to stop working.

Improved Shorthand Notation for Currencies

We have optimized how you define currencies in your notebook. Here’s what's new:

  • Support for multiple currency notations. You can now express currencies in a more flexible ways. For example, 2 billion dollars can now be express as: $2 billion, $2B, $2 000 000 000 or $2 000M.
  • Support for different conventions, such as $5 or 5$.
  • Improved multipliers, such as thousands ($K), millions ($M) and billion ($B); not case sensitive.

Temporary Implications

These new changes may have side effects in a small number of existing notebooks and could potentially break your models. Here is what’s affected:

  • Shorthand notation for distances which include m, mm, cm are temporarily not supported. With the above changes, M and m is now notion for million. You can still use the long format meters, millimeters and centimeters.
  • New reserved variable names, K,M,B, Thousand, Million, Billion. This means that you can no longer use these names as a variable name. To fix affected notebooks, replace these variable names with new ones.

We’re exploring ways to support these limitations again in the future. In the meantime, if any of your notebooks have been affected, you can reach out to support, and we will help you upgrade the notebook.

Charts are easier to use with an improved design

We’ve made some changes to the way charts work in notebooks to make them easier to use. Here’s what’s new:

  • Easily insert a chart to your notebook. You can add a pie, bar, line, or scatter chart from the block menu or directly from a table.
  • Adjust settings with an improved menu. You can now choose new colors, updated data sources, and change its labels or values.
  • Hover to see results: You can now hover over any section of a chart to see its results, making it easier to analyze and understand your data.
  • New Color Pallet: We've updated color palettes with dark-mode support, allowing you to customize the look and feel of your charts.

Fixes and Improvements

  • New notebook with placeholder examples. When you create a new notebook, some examples will be added automatically. You can clear all examples by clicking the 'Clear All' button at the end of your notebook.
  • Autocomplete has been improved to help you create formulas faster. It now shows the syntax for each formulas and has better suggestions.
  • Tables have been updated to prevent accidentally inserting rows. The + button to add/insert rows into a table was replaced. You can now add/insert rows by clicking each row menu and choosing to insert a row above or below.
  • The Numbers Catalog, which provides a summary of your notebook, is now open by default, to help you navigate the numbers.
  • We have introduced new formulas to help you reuse numbers with units. Now you can remove the units on a formula using stripunit(), or get the units a formula is using with getunit().
  • You can now extract the day, month, year or quarter from a date. Here’s an example of how to extract the day: round(date(2023-03-20), day).
  • Long emails no longer break the layout when you invite new teammates.
  • Duplicating tables also keeps the formulas, instead of copying the data.

COLLABORATION

Collaborate in Real-time on Models and Reports

Decipad now allows you to invite teammates to collaborate on your notebooks by simply entering their email. No prior account is required.

  • To invite someone as a collaborator or reader, click the + button near your avatar on the top bar of your notebooks, select a role, and add their emails.
  • To find notebooks shared with you, go to your workspace and select Shared with me on the left**.** Alternatively**,** you can also click the link we send to your email.

Create Formulas Everyone Understands

FORMULAS

We’ve introduced a new block to clearly define inputs and formulas, making it easier for you and your team to understand the context when exploring calculations.

  • To add this new block to your notebook, simply type =. Alternatively, type / or click the + button to open the block menu and search for Number Input or Formula.
  • The original Decipad calculation blocks are still there, so existing notebooks won’t be affected. You can find these original blocks on the menu under their new name: Advanced Formulas.

Better Inspection for Inline Results

We have enhanced the inspector for inline results, allowing you to explore the formulas behind the numbers, make quick edits, and update their name.

Learn more about Inline Results →


Fixes and Improvements

  • Added several formulas for finance. compound(), futurevalue(), netpresentvalue() and paymentamounts(), to help you explore compounding and interest use cases.
  • You can now export backups for your notebooks from the workspace menu.
  • Notebooks imported to a workspace are now added to the top of the list instead of the bottom.
  • Table placeholders have been updated to say Columns instead of Properties.
  • The Decipad Language now supports the latest metric prefixes introduced in 2022.
  • Improved scientific notation for small and big numbers, with better-looking exponents.
  • The inline + button has been improved to avoid misc licks and add the correct blocks in the right context.
  • Any calculation using a column won’t break when you update their name.
  • Fixed an issue that prevented users from dragging inline results to bulleted lists.
  • Table tooltip styles fixed in dark mode.

Data Views Demo

Inline results are now easier to identify by anyone reading your notebook. These are numbers you can add into your text to highlight results that update automatically when there are changes to your model.

Learn more about Inline Results


Fixes and Improvements

  • Inline results were redesigned, so anyone can tell they are connected to your model.
  • Workspace and avatar icons now display their first two letters, so similar names are easier to tell apart.
  • Data Type icons are displayed when picking columns to add to a Data View, so you know which data you are selecting.
  • Made a number of improvements to stability: Empty state table names, deleting workspaces with notebooks, clicking in-line numbers and using = to generate a table formula no longer crash the app.
  • UI buttons no longer stop working after dragging a result from a column to your notebook.
  • Hovering inline results to see their formula, now displays formulas of any size correctly.
  • You can now place your cursor after a variable bubble on a calculation.
  • Try Decipad button is now clickable on Firefox and mobile.
  • Publish toggle was fixed on Firefox.

Fixes and Improvements

  • In read only mode, a viewer can no longer can add new columns to Data Views. So you are in control of the data you want to showcase.
  • Drag & Drop icon added to Data View columns, so they are easier to reorder.
  • Callout blocks now support text formatting.
  • Contact support from error pages. We’ve added a contact support button to all error pages, so anyone can get help when needed.
  • Calculation rows on tables now display a useful level of precision. $0.33 vs $0.333333(3)
  • Publishing notebooks flow was patched, some notebooks used to show as empty to readers
  • Publish button now works when you delete text on your notebook