# 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:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dschaffe](https://community.eazybi.com/letter_avatar_proxy/v4/letter/d/22d042/32.png) [@dschaffe](https://community.eazybi.com/u/dschaffe)\
**Post date:** [February 25, 2022, 7:51pm UTC](https://community.eazybi.com/t/adding-the-total-of-certain-values/8936/1 "2022-02-25T19:51:00Z")

</div>

I have a Custom field called Happiness on an initiative. It has a value from 1-10. I am looking for a way to show in a report how many 7’s I have in total across those initiatives, or say how many threes there are.

I am looking for a pointer as to where I should start? Aggregates? SumtoStr?

Further to that for some reason when I do an order by 10 is just after 1 and before 2.

 ![2022-02-25 11_46_30-Window](https://community.eazybi.com/uploads/default/original/2X/a/a52b89d94e11d92c94a5417ba0b301e7cb92ca62.png)

in essence what i need is something that says  
I have 5 issues with happiness score of 4  
7 issues with happiness score of 8  
etc etc

---

<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)
