Category Archives: Data Visualization

How to (Mis)use HubSpot Custom Objects

Leave a reply

Custom Object in HubSpot is an enterprise feature which allows you to store customised information about your business, along with standardised objects such as Contacts, Companies and Deals.

Depends on your business, you may have different use cases to leverage this flexibility. In this post I would like to share one of the use cases which I found very interesting to open to more possibilities: using Custom Objects to store metrics for reporting purpose.

If you often work with dashboards and reports in HubSpot, you’ve definitely run into some limitations. For example, you cannot track and visualise historical data in a straightforward way. Taking lead scoring for instance, there’s a way to visualise how a lead score changes overtime, making it less transparent and difficult for sales to follow up.

Continue reading →

How to customize bar colors in a waterfall chart in Google Sheets

3 Replies

Waterfall chart is a good way to show changes overtime. One good example is showing how business revenue is growing in different components over a certain period so that you can have an overview of growth drivers.

Here is a use case where I want to illustrate how ARR is growing in the past year and the formula is very straightforward:

Continue reading →

ggplot2 Theme Elements Demonstration

1 Reply

ggplot2 is one of the most powerful packages in r for data visualizations and it is essential to master the underlying grammar of graphics to fully utilize its power. While the theming system of ggplot2 allows you to customize the appearance of the plot according to our needs in practice, it is always a frustration to identify the elements on the plot you want to change as you may find it difficult to remember the element names and their corresponding functions to modify, at least this is the case for me.

Continue reading →