Skip to Content

Create a github-like heat map

I'm hoping to create a heat map that somewhat resembles Github's:

The challenges:

1. The size of the rectangles can vary widely:

vs

2. The number of weekdays and weeks also vary widely (see prior images).

3. The size of the font is dependent upon the number of records in the Secondary Category axis. If the number of records are large enough, the labels aren't displayed.

Desired:

1. the rectangle are formatted as squares w/ a given length and width

2. the report always shows 52 weeks, even if there isn't data to support it

3. the font size is constant; if necessary, the chart could grow to accommodate more 'rows'

Are any of these desired aspects possible?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 16, 2017 at 08:22 AM

    Hi Craig,

    Why not just use a Crosstab with conditional formatting applied to the body cells?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Q1. I've put a break on the Months, keeping the break footer to create the gap in the header.

      Q2. Yes, just define more ranges in the conditional formatting. The one I've used is a simple - is the cell contents > 0, if so then turn the background and text to be green

      Q3. The colours would be consistent across sections, and could be applied as a % of a grand total.

      Q4. The size of the rectangles is fixed by setting the Height and Width of the crosstab body cells

      Q5. Not directly as a text pop-up, but you can use Element Linking and another table to display the count when a rectangle is clicked.