# Building a Dynamic Heatmap of OCM Epics with Project Columns in eazyBI

**URL:** <https://community.eazybi.com/t/building-a-dynamic-heatmap-of-ocm-epics-with-project-columns-in-eazybi/20104>\
**Category:** Questions & Answers\
**Created:** [June 9, 2025, 1:42pm UTC](https://community.eazybi.com/t/building-a-dynamic-heatmap-of-ocm-epics-with-project-columns-in-eazybi/20104 "2025-06-09T13:42:28Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [June 12, 2025, 9:38am UTC](https://community.eazybi.com/t/building-a-dynamic-heatmap-of-ocm-epics-with-project-columns-in-eazybi/20104/2 "2025-06-12T09:38:20Z")

</div>

Hi @Behzad_Nazarbakhsh

**Conditional formatting heatmap** is the perfect solution for your reporting requirements. This functionality was introduced in eazyBI version 6.2, released in 2021.  
We always recommend users to use the latest eazyBI version that includes new features and improvements: [Changelog - eazyBI for Jira](https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-data-center/changelog-eazybi-for-jira)

Regarding grouping issues by a similar text in the issue summary, I suggest checking this community post about the [JavaScript calculated custom field](https://community.eazybi.com/t/filter-open-issue-by-summary/6046/2) solution:

> [@Filter open issue by summary](https://community.eazybi.com/t/filter-open-issue-by-summary/6046/2):
>
> Hi @karim , I don’t recommend defining such calculated members in the Issue dimension. They are a performance risk. If you don’t have the option to create a new custom field in Jira, define a new JavaScript calculated custom field in eazyBI. See more details on how to do that here - [Global calculated fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/javascript-calculated-custom-fields/global-calculated-fields). Add parameters similar to the one below to your eazyBI advanced settings: [jira.customfield\_developer\_issue] name = "Issue summary Developer" data\_type = "string" dimension = true javasc…

Kind regards,  
Gerda // [support@eazybi.com](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/building-a-dynamic-heatmap-of-ocm-epics-with-project-columns-in-eazybi/20104)._
