In Coda, a table can quickly turn into a number of thingsーincluding several types of charts. However, some of types of charts have stricter data requirements than others. For example, in order to turn a table into a calendar, you’ll need to include some date and time information in your data.
Starting today, we’re making it clearer when your desired chart might require you to add certain data points to your tables, and will guide you through adding them. This update applies most specifically to Gantt charts and calendars, but will also help flag mistakes we’ve all made when we’re in a rushーlike trying to make a bar chart with one column of data (which is still possibleーand now we’ll flag how). For example:
- New red badges and error messages direct you to what you need to fix
- If you don’t have any columns of the right type, you can now add one instead of starting completely over
In addition, we’ve reduced potential “dead ends” while creating calendars and Gantt charts. Previously, we made you select which column type (end date or duration) you wanted to use, and then allowed you to select your column. This meant if you chose duration, but only had date columns in your table, you could get stuck. Now, we just let you choose either type of column to indicate when events end, and do the right thing based on what type of column you pick.
If you’re interested in best practices for structuring your data before having the Chart display menu walk you through the requirements, be sure to check out these helpful articles from our team: