Skip to Content
0

Create a github-like heat map

Aug 15, 2017 at 08:51 PM

33

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hi Craig,

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


ujky5.png (10.3 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

I like it.

Questions:

* how did you get the spacing between the months headers?

* is there a way to base the color intervals on a % of total?

* if the crosstab was embedded in a section (perhaps region in your example) to have the color intervals be consistent across the sections, perhaps as a percentage of a grand total?

* is there a way to force the size of the rectangles?

* is there a way to display the count if you move the mouse over the rectangle?

0
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.

0