# How to get the type of Board in Jira and how many Scrum or Kanban

**URL:** <https://community.eazybi.com/t/how-to-get-the-type-of-board-in-jira-and-how-many-scrum-or-kanban/12286>\
**Category:** Questions & Answers\
**Tags:** jira-reports, jira\
**Created:** [April 4, 2023, 4:39pm UTC](https://community.eazybi.com/t/how-to-get-the-type-of-board-in-jira-and-how-many-scrum-or-kanban/12286 "2023-04-04T16:39:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_Angel](https://community.eazybi.com/user_avatar/community.eazybi.com/miguel_angel/32/9412_2.png) [@Miguel\_Angel](https://community.eazybi.com/u/Miguel_Angel)\
**Post date:** [April 4, 2023, 4:39pm UTC](https://community.eazybi.com/t/how-to-get-the-type-of-board-in-jira-and-how-many-scrum-or-kanban/12286/1 "2023-04-04T16:39:17Z")

</div>

How can I get one list with name of the projects witch has more that 1 scrum board

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [April 11, 2023, 8:31am UTC](https://community.eazybi.com/t/how-to-get-the-type-of-board-in-jira-and-how-many-scrum-or-kanban/12286/2 "2023-04-11T08:31:56Z")

</div>

Hi,

eazyBI does not import Kanban boards into the data model. Only Scrum boards are created in eazyBI at the board level of the Sprint dimension.

The following formula generates the list of boards per project (meaning the list of boards that has at least one issue from the project):

```auto
Generate(
  Filter([Sprint].[Board].Members,
  [Measures].[Issues created]>0 AND [Sprint].CurrentMember.Name<>"(no board)"),
  [Sprint].CurrentMember.Name,
  ","
)

```

Kindly,  
Janis, eazyBI support