LinkedIn
Twitter
This tip is for creating heat map table charts using table views in AppSheet. There are multiple articles available on heat maps on the internet. Heat maps are a useful tool to understand multiple related data points at one glance. In the sample app below, the app user can understand how quantities of various products have been sold in the past six months including current month.
The sample app is based on another sample app "Order Capture" that is available as a sample app in AppSheet help article.
There are 10 products in the app and the heat map shows the sales of those 10 products in last six months. So the user can observe 60 data points at one glance and get a quick understanding of products that are selling well and any pattern in their month wise sales.
A screenshot of the heat map chart is attached below.
A few points to note:
1. The chart can be updated on demand by using the inline action titled "Update Sales Quantity" in any of the rows of the "Heat Map Legend" view as shown below. Alternatively there is also a daily scheduled bot that will update the sold quantity by adding order quantity of the day
2. The chart will of course update only when new data has got added since last snapshot. For new data , please add new orders in the All Orders view. The order status needs to be "Complete" to be included in the chart.
3. The chart will automatically show the sold quantities of last 6 months including current month.
4. The chart obviously looks better in the desktop view mode than mobile view.
Here is the sample app:
