CSAT - Calculate Satisfaction

I’m creating a report to measure customer satisfaction and needed to add up the amount of survey we received for the highest scores, 4 and 5, and then divide by the total surveys. I’ve tried it in different ways and I haven’t got any results. Any suggestion?

Data is coming from Jira Cloud.

Example:

491 + 20 / 516 = 0,9903…

@Marina_Vital

You can create a new calculated measure with % format using this formula for each member (4 and 5)
It will calculate the percentage for each row from all surveys.

[Measures].[Issues with satisfaction date]
/
(
[Measures].[Issues with satisfaction date],
[Satisfaction].[4]
)

And

[Measures].[Issues with satisfaction date]
/
(
[Measures].[Issues with satisfaction date],
[Satisfaction].[5]
)

And this one can be for the total row “Notas”.

Aggregate({
[Satisfaction].[4],
[Satisfaction].[5]
},
[Measures].[Issues with satisfaction date]
)
/
[Measures].[Issues with satisfaction date]

Martins

Thank you!!! The solution helped me perfectly!