# How to create measure based on project type

**URL:** <https://community.eazybi.com/t/how-to-create-measure-based-on-project-type/10951>\
**Category:** Questions & Answers\
**Tags:** data-mapping, jira\
**Created:** [November 8, 2022, 10:48pm UTC](https://community.eazybi.com/t/how-to-create-measure-based-on-project-type/10951 "2022-11-08T22:48:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lili](https://community.eazybi.com/letter_avatar_proxy/v4/letter/l/b38774/32.png) [@Lili](https://community.eazybi.com/u/Lili)\
**Post date:** [November 8, 2022, 10:48pm UTC](https://community.eazybi.com/t/how-to-create-measure-based-on-project-type/10951/1 "2022-11-08T22:48:33Z")

</div>

Hi,

I want to create an automatic report for specific project type counts per month, but it seems that no current dimension could be used. What I usually do is to create a syntax in wiki space as follows:

projectType = software and category is empty and status changed from Approved to New during (“2022/01/01”,“2022/01/31”)

This syntax could only give me a number but not able to visualize. Could someone help how to add a measure in easyBI?

Thanks!

---

<div class="post-metadata">

**Author:** ![lauma.cirule](https://community.eazybi.com/user_avatar/community.eazybi.com/lauma.cirule/32/8830_2.png) [@lauma.cirule](https://community.eazybi.com/u/lauma.cirule)\
**Post date:** [November 11, 2022, 1:58pm UTC](https://community.eazybi.com/t/how-to-create-measure-based-on-project-type/10951/2 "2022-11-11T13:58:20Z")

</div>

Hi @Lili!

**Project type** is not imported in eazyBI by default. For importing Project type property, you would use [additional data import](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube) with Rest API. E.g., the REST API call `JIRA_BASE_URL/rest/api/latest/project` on server/DC or `https://YOUR_SITE.atlassian.net/rest/api/3/project` would return Project information, including projetTypeKey that you can further add to your Issues cube as follows:

 ![import project type - step6](https://community.eazybi.com/uploads/default/original/2X/7/75beb2a5361d2bfc99750202fc5cdc87fce03d52.png)

Lauma / [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![Lili](https://community.eazybi.com/letter_avatar_proxy/v4/letter/l/b38774/32.png) [@Lili](https://community.eazybi.com/u/Lili)\
**Post date:** [November 11, 2022, 5:17pm UTC](https://community.eazybi.com/t/how-to-create-measure-based-on-project-type/10951/3 "2022-11-11T17:17:23Z")

</div>

Thank you! That really helps!