Conditional formatting for % data in reports

[Stevie-Kv]

Context

• Hubspot’s table reports allow for conditional formatting to be applied
  • Add conditional formatting to tables in reporting
• Min and Max is set automatically by default, but you can give it a set numerical value if needed

Challenge

• You cannot currently add a “.” to the Min and Max fields when setting up the conditional formatting.
• This prevents you from applying conditional formatting to % values, which display numerically as 0 - 1.
• For example, “Marketing Email Delivery Rate”
  • I want to set the max to 1 (100%)
  • I want to set the min to 0.95 (95%)

Idea

• Let us put decimals into the min and max fields in the report builder!

Note: A less than ideal workaround is to build a dataset and create a calculation to multiply the rate by 100, turning 0-1 into 0-100.