Heatmap: how to change values from "average" to "total count" for groups

ted_ellefson

I'm creating a heatmap in graph builder.  I have a "group" column and I've made a local data filter to migrate through the groups or select some or all of the groups for the heatmap.  When I select an individual group, the heatmap displays the count from the group.  When I select multiple groups the heatmap displays the average count for the groups.  I want it to display the sum or total count of all the groups selected.  I'm not able to figure out how to change it to total count.  I'm only finding the options for value or percent of total and not total count.

thanks for your help in advance

jules

Hi @ted_ellefson,

Regardless of any Local or Global data filter, the heatmap element will display total count in the intersections/cells. That is, unless you're using a variable in the Color role, which is what I assume you are doing if you're getting an average value in the cells ("average" is the default operation to perform on the values of a continuous Color role variable). To change the summary statistic used in coloring those cells (and thus, also the values displayed when they are labelled), right click the variable in the Color role, select Summary Statistic > Sum:

 

Now, what is displayed in the cells (and what the colors are defined by) is the sum of the Color variable at those intersections formed by your X and Y role variables. Your Data Filter should now work as you intended. 

I hope this helps!

@jules