I have a heatmap showing the MoM % change in treatment count per area. I want to add the treatment counts from each period into the tooltip, however, I have noticed with looker heatmaps that the first field in the data (that is not hidden) is shown in the data.
The problem is that the % change is a table calculation and I cannot put it in front of a measure. Is there a workaround to this issue?