# Adding the total of certain values

**URL:** <https://community.eazybi.com/t/adding-the-total-of-certain-values/8936>\
**Category:** Questions & Answers\
**Tags:** jira, calculatedmembers\
**Created:** [February 25, 2022, 7:51pm UTC](https://community.eazybi.com/t/adding-the-total-of-certain-values/8936 "2022-02-25T19:51:00Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ilze.leite](https://community.eazybi.com/user_avatar/community.eazybi.com/ilze.leite/32/19_2.png) [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\
**Post date:** [March 3, 2022, 11:00am UTC](https://community.eazybi.com/t/adding-the-total-of-certain-values/8936/2 "2022-03-03T11:00:32Z")

</div>

Hi @dschaffe

You may want to import the “Happiness” field **as a dimension**. This dimension would contain members 1,2,3…10 (and (none) for issues without this field ) and you would use this dimension together with the measure “Issues created” to get the number of issues with a respective happiness level.

By default, numeric fields can be imported as measures and properties, but, with additional **advanced settings** you may import the field as a dimension as well: [Advanced settings for custom fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields)

See similar community threads on how to import numeric fields as a dimension (a typical example is “Story Points” field):

> [@Sprint Point Wise categorization](https://community.eazybi.com/t/sprint-point-wise-categorization/350):
>
> I have requirement to display the Number of Sprints based on points. For example: 1 - 0 point story (defect) was worked in the sprint 2 - 0.5 point stories were worked in the sprint 3 - 1 point stories were worked in the sprint 4 - 2 point story were worked in the sprint 2 - 3 point stories were worked in the sprint 3 - 5 point stories were worked in the sprint There is 1 Story with 0 point in Sprint. There is 2 Story with 0.5 point in Sprint. So on and so forth…

> [@Number of issues with "x" story points](https://community.eazybi.com/t/number-of-issues-with-x-story-points/8186):
>
> Hello, Is it possible to create a report that displays a count of issues with “x” story points in one or more sprints? for example, how many issues have 1 points, 3 points, 5 points, etc. within a sprint. Thank you!

Best,  
Ilze, [support@eazybi.com](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/adding-the-total-of-certain-values/8936)._