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.
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
See similar community threads on how to import numeric fields as a dimension (a typical example is “Story Points” field):