“Should I sort this data in descending order by values in my number column to show a trend? Or should I sort this data alphabetically by a text column so my viewers can quickly scan for the rows that matter to them?”
With today’s update, hopefully this a question you get to ask yourself much less frequently.
Introducing: Color scales in Coda.
Now, instead of creating a variety of rules with your conditional formats or formulas, you can see trends in numeric data and spot outliers with a single conditional formatting rule. Like our other conditional formats, color scales apply to a single column by default, but you can extend them to other columns and/or entire rows.
With this first version of color scales, we’ve enabled presets based on min, max and mid-point values. In the future, we hope to offer more customization, support for formulaic scales, percents and much more. Hopefully this first step helps you visualize your even more powerfully in Coda!